Support Board
Date/Time: Fri, 31 Jan 2025 06:14:27 +0000
Post From: Spreadsheet number precision
| [2013-07-31 03:47:35] |
| Sawtooth - Posts: 4164 |
|
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
|