Support Board
Date/Time: Mon, 15 Dec 2025 15:14:53 +0000
Post From: Rounding error on spreadsheet?
| [2022-02-07 20:37:46] |
| 1+1=10 - Posts: 270 |
|
Hi. Fellow user here. SC has docs explaining what is probably happening. It has to do with the fact computers can't store non-integer numbers precisely. So while the ZB bar low and the position price may both display as 123 1/32, the former might be stored in the computer as 123 1.000000001 / 32, and the latter may be stored as 123 0.9999999997 / 32. See docs explaining this and solution here: Working with Spreadsheets: Floating-Point Values and Comparisons When Using the Spreadsheet Study |