Support Board
Date/Time: Thu, 30 Oct 2025 10:20:45 +0000
Post From: Spreadsheet for trading routinely misses entry triggers
| [2024-09-02 04:29:38] |
| Sawtooth - Posts: 4281 |
|
All I am doing is counting the number of ticks, how can there be a floating-point error?
Some symbol prices have floating point errors, especially if the tick size is small.This is what I do: First, remove any floating point errors in the tick size Then reference the new tick size to remove any floating point errors in the price. Spreadsheet Example Formulas and Usage: Removing Floating Point Imprecision I take it a step further, and use columns AB-AE, (relative to columns B-E) so that it's easier to remember the MROUNDed prices. |