Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 25 Apr 2024 01:22:08 +0000
Post From: Spreadsheet: special bars as doji and pin-less
| [2020-02-15 03:28:31] |
| Sawtooth - Posts: 3976 |
|
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.) |