Support Board

Date/Time: Tue, 07 May 2024 20:44:53 +0000

Post From: OHLC from spreadsheet data

[2014-11-25 15:28:07] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
It can be done, but you'll need a total of 12 formula columns: - your 4 existing OHLC columns, to the left of the below columns. - 4 up-bar columns for HLOC (in this order), to the right of the above columns and to the left of the below columns. - 4 down-bar columns for HLOC (in this order), to the right of the above columns. The order of these columns is necessary because higher numbered subgraphs will overpaint lower ones. You'll need formulas in the up-bar and down-bar columns to separate up-bars from down-bars. See formulas in O3-V3 of the attached spreadsheet as examples. Then use these Draw Styles for both the up-bar and down-bar columns: H = Bar Top L = Bar Bottom O = Candle Body Open C = Candle Body Close


usdx.scwbf - Attached On 2014-11-25 15:26:23 UTC - Size: 399.32 KB - 336 views