Support Board
Date/Time: Wed, 26 Feb 2025 21:33:19 +0000
Post From: Spreadsheet formula outputs
| [2021-05-29 20:59:04] |
| Sawtooth - Posts: 4176 |
|
That imprecision is due to this: Using the Spreadsheet Study: Imprecision of Floating-Point Numbers and Comparisons Assuming the 1.75 is 7 ticks, you could use this formula: =4215-4213.25 >= $J$21*7 Sometimes the OHLC prices in columns B-E, and the tick size in J21, have floating point errors that need to be removed. You can use this method, which is much less annoying/problematic: Spreadsheet Example Formulas and Usage: Removing Floating Point Imprecision When I need to do this, I use columns AB-AE so that they easily match B-E when creating formulas. (You'd need to increase the Number of Formula Columns to at least 21.) Date Time Of Last Edit: 2021-05-29 21:00:05
|