Support Board
Date/Time: Wed, 05 Nov 2025 17:18:40 +0000
Post From: Spreadsheet: special bars as doji and pin-less
| [2020-02-15 03:28:31] |
| Sawtooth - Posts: 4285 |
|
Do this: Set 'Number of Formula Columns to something 20 or larger. Put this in H21: =1/ROUND(1/J21,0) Put this in AB3: =MROUND(B3,$H$21) Put this in AC3: =MROUND(C3,$H$21) Put this in AD3: =MROUND(D3,$H$21) Put this in AE3: =MROUND(E3,$H$21) Now reference OHLC values that are rounded to the rounded tick size, using AB3, AC3, AD3, AE3, respectively. (You only need to use the ID#.SG#@[row] format when referencing study outputs. Use cell/row references for all others. This keeps things tidier.) |