Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 15:40:48 +0000
Post From: Decimals in the new spreadsheets
| [2014-11-08 19:13:42] |
| Sawtooth - Posts: 4000 |
|
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
|