Support Board

Date/Time: Fri, 27 Sep 2024 03:56:40 +0000

Post From: Spreadsheet for trading routinely misses entry triggers

[2024-09-02 04:29:38] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4092
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.