Support Board
Date/Time: Sat, 12 Jul 2025 01:11:40 +0000
Post From: Spreadsheet number precision
| [2013-07-31 03:47:35] |
| Sawtooth - Posts: 4238 |
|
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
|