Support Board
Date/Time: Wed, 26 Feb 2025 21:56:27 +0000
Post From: Spreadsheet formula outputs
| [2021-05-29 21:38:36] |
| Sierra_Chart Engineering - Posts: 18571 |
|
Why did sierra add .0000000000000002 to my given value? I am spending hours debugging all these formulas on triggers to find the software is just making up its own stuff. This is due to floating-point values as implemented by your CPU. Refer to:Using the Spreadsheet Study: Imprecision of Floating-Point Numbers and Comparisons And thank you for post #2. 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, use the Teton service: Sierra Chart Teton Futures Order Routing |