Support Board
Date/Time: Mon, 27 Oct 2025 16:56:21 +0000
spreadsheet is miscalculating
View Count: 1344
| [2015-06-15 21:07:02] |
| jivetrader - Posts: 410 |
|
K903 should return FALSE because E903=B903. what is wrong with Spreadsheets? |
 spreadsheet wrong calc2.png / V - Attached On 2015-06-15 21:05:31 UTC - Size: 101.23 KB - 433 views |
| [2015-06-16 04:25:44] |
| |
|
They may not be exactly equal. Select the cells being referenced and select Spreadsheet >>Number Format. Increase the number of decimal places and see if the values actually match.
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 |
| [2015-06-16 23:30:26] |
| Sawtooth - Posts: 4280 |
|
Here's what I do to eliminate floating point errors so that values can be accurately compared with formulas: http://www.sawtoothtrade.com/example-3.html |
| [2015-06-16 23:49:02] |
| jivetrader - Posts: 410 |
|
thank you tomg! i figured some kind of rounding was in order. would be nice if sierra didnt have these kind of 'invisible' issues.... |
To post a message in this thread, you need to log in with your Sierra Chart account: