Support Board
Date/Time: Tue, 13 May 2025 14:50:53 +0000
Post From: Decimals in the new spreadsheets
| [2014-11-08 19:13:42] |
| Sawtooth - Posts: 4214 |
|
This is what I do to round the price to tick size: First, round the J21 Tick Size, with this in cell H21: =1/ROUND(1/J21,0) This will correct any floating point errors that may exist even if the value displayed appears to be precise. Then round the OHLC to the tick size, referencing the OHLC columns like this: =MROUND(E3,$H$21) Date Time Of Last Edit: 2014-11-08 23:21:15
|