Support Board
Date/Time: Sun, 09 Nov 2025 11:50:00 +0000
Post From: Spreadsheet number precision
| [2013-07-31 03:47:35] |
| Sawtooth - Posts: 4287 |
|
Here is what I do to round the OHLC to the tick size: 1) Round the tick size to remove floating point errors. Put this in H21: =1/ROUND(1/J21,0) 2) Round the Last price to the tick size multiple: =MROUND(E3,$H$21) Date Time Of Last Edit: 2013-07-31 03:49:02
|