[Solved] Decimal points

Discuss the spreadsheet application

[Solved] Decimal points

Postby elliot13458 » Sun May 13, 2018 11:13 pm

i want this to show up as 88 pips, but its showing as 0. something how do i get rid of the 0s on this sheet

=d2-c2
Attachments
EUR_USD Historical Data-new.ods
(24.66 KiB) Downloaded 40 times
Last edited by Hagar Delest on Mon May 14, 2018 8:54 am, edited 1 time in total.
Reason: tagged solved
Openoffice 4.1.1 on windows 7
elliot13458
 
Posts: 10
Joined: Sun May 13, 2018 10:59 pm

Re: decimal points

Postby RoryOF » Sun May 13, 2018 11:25 pm

g2=(d2-c2)*10000
Apache OpenOffice 4.1.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32345
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: decimal points

Postby elliot13458 » Sun May 13, 2018 11:28 pm

thank you very much for this, what does the *1000 mean at the end? i had to remove the g2 part of it for it to work in the begining
Openoffice 4.1.1 on windows 7
elliot13458
 
Posts: 10
Joined: Sun May 13, 2018 10:59 pm

Re: decimal points

Postby RoryOF » Sun May 13, 2018 11:36 pm

It multiplies the result of the subtraction to remove the zeros. G2 was the cell in which I did the calculation.
Apache OpenOffice 4.1.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32345
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: decimal points

Postby RusselB » Sun May 13, 2018 11:36 pm

The * is the character used to indicate multiplication in spreadsheets, so the *1000 means multiply by 1000
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6355
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: decimal points

Postby elliot13458 » Sun May 13, 2018 11:44 pm

thanks for this info and help. i was trying to see if their was a difference between the eur usd and usd chf for buying both, so i can profit from the rates(one buying or selling more then another). like 2 buys on it, one on eurusd and one on usdchf
Openoffice 4.1.1 on windows 7
elliot13458
 
Posts: 10
Joined: Sun May 13, 2018 10:59 pm

Re: decimal points

Postby keme » Mon May 14, 2018 8:12 am

elliot13458 wrote:thank you very much for this, what does the *1000 mean at the end? i had to remove the g2 part of it for it to work in the begining

Please note: It is ten thousand, not one thousand.

A pip, in currency trading, is (in all practical cases) a "hundredth of a hundredth". That makes one ten-thousandth, so you have to multiply by 10000 (not 1000) to show an amount (difference, change) in pips.
User avatar
keme
Volunteer
 
Posts: 3404
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: decimal points

Postby elliot13458 » Mon May 14, 2018 8:21 am

thanks for this info
Openoffice 4.1.1 on windows 7
elliot13458
 
Posts: 10
Joined: Sun May 13, 2018 10:59 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 21 guests