Support Board
Date/Time: Sat, 23 Nov 2024 08:34:59 +0000
Spreadsheet quotes
View Count: 1998
| [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] |
| |
|
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] |
| |
|
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] |
| Sawtooth - Posts: 4118 |
|
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: