Login Page - Create Account

Support Board


Date/Time: Fri, 03 Feb 2023 23:35:22 +0000



Spreadsheet quotes

View Count: 1558

[2013-06-20 15:52:00]
Trader10239 - Posts: 4
Hi,

I notice the FXCM forex quotes in spreadsheet has more than 5 digits (eg. 1.2349592392 instead of 1.23495). Am I missing something? Please advise. Thanks.

[2013-06-20 16:04:20]
Sierra Chart Engineering - Posts: 104357
You can set the format. This is documented here:
http://www.sierrachart.com/index.php?l=doc/doc_GettingQuotes.html#NumberFormat
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2013-06-20 16:07:22]
Trader10239 - Posts: 4
Thanks for the link. I think my question is why quotes from FXCM has more than 5 digits. Shouldn't all forex quotes be 4-5 digits for most pairs?
[2013-06-20 16:09:33]
Sierra Chart Engineering - Posts: 104357
We cannot say for sure why this is the case but one reason just has to do with how floating-point numbers are represented in computers.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2013-06-20 16:27:39]
tomgilb - Posts: 3546
If you are comparing price levels in formulas, you may want to round price values to a rounded tick size, to remove floating point errors. Here's one way:

http://www.sawtoothtrade.com/example-3.html
Date Time Of Last Edit: 2015-08-14 01:38:06
[2013-06-20 16:37:18]
Trader10239 - Posts: 4
Thanks again. Great advice from tomglib :)

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account