Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 19 Sep 2024 22:07:46 +0000
Post From: Trading Spreadsheets FX and precision
| [2014-02-26 13:41:33] |
| Sawtooth - Posts: 4091 |
|
I would try rounding J21 and OHLC columns to remove any floating point imprecision. Put this in H21: =1/ROUND(1/J21,0) Put these in the respective cells: AB3: =MROUND(B3,$H$21) AC3: =MROUND(C3,$H$21) AD3: =MROUND(D3,$H$21) AE3: =MROUND(E3,$H$21) J22: AE3+H21 You can use any 4 spare formula columns, but I use AB-AE so they match B-E. (The Number Of Formula Columns needs to be at least 21). Also, all of your other formulas that reference columns B-E should be edited to reference AB-AE instead. You might also try setting 'Strict Signal Only On Bar Close Evaluation' to Yes. |