Support Board
Date/Time: Fri, 03 Jan 2025 03:46:47 +0000
OHLC from spreadsheet data
View Count: 1993
[2014-11-25 09:34:09] |
jivetrader - Posts: 410 |
i would like to plot 4 spreadsheet columns as OHLC candlesticks (as a subgraph below the chart). how do you recommend, thanks
|
[2014-11-25 15:28:07] |
Sawtooth - Posts: 4144 |
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 - 498 views |
[2014-11-25 17:55:48] |
Sierra Chart Engineering - Posts: 104368 |
This can be done by using the Spreadsheet Study and setting the Use Price Graph Style Input to Yes. Refer to the documentation here for details: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#PriceGraphStyle Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: