Support Board
Date/Time: Mon, 15 Dec 2025 23:22:35 +0000
[Programming Help] - Strange spreadsheet output value for tick size J21
View Count: 1497
| [2017-09-26 09:42:48] |
| User841591 - Posts: 42 |
|
Pls note the attachment. I try to evaluate the H15 (=J21=0.0001). if tick size = 0.0001, the return should be true. However, it return false. Pls help on it
|
Attachment Deleted.  ScreenHunter_03 Sep. 26 1 47.31.jpg / V - Attached On 2017-09-26 09:42:13 UTC - Size: 77.34 KB - 488 views |
| [2017-09-26 16:21:33] |
| Sawtooth - Posts: 4299 |
|
Sometimes the value in J21 contains floating point errors. Use this formula in H21 to remove them: =1/ROUND(1/J21,0) Then use this in H15: =H21=0.0001 |
| [2017-09-26 16:43:52] |
| |
|
Refer to: Using the Spreadsheet Study: Imprecision of Floating-Point Numbers and Comparisons 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: