Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 17:53:44 +0000



How to draw candlesticks from spreadsheet formulas?

View Count: 390

[2022-06-11 16:44:41]
Techotomy - Posts: 104
I would like to draw candlesticks from custom formulas on the chart. I can calculate the open, high, low, close with four different formulas and assign the open and close to Candlestick Body Open and Candlestick Body Close draw styles, but don't see how to draw the wicks using the high and low. What is the best way to draw candlesticks from a custom formula?
[2022-06-11 17:04:10]
Sawtooth - Posts: 3973
What is the best way to draw candlesticks from a custom formula?
You can do it with either of these spreadsheet studies:
Spreadsheet Study study
Spreadsheet System/Alert study
Set 'Use Price Graph Style' to Yes, then the OHLC formulas are in columns KLMN
Spreadsheet Study Inputs: Use Price Graph Style

You can also do it with the Spreadsheet Formula (Bar) study.
This study is not yet documented.
[2022-06-11 17:26:44]
Techotomy - Posts: 104
Figured it out with the SpreadSheet Formula (Bar) Study.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account