Login Page - Create Account

Support Board


Date/Time: Wed, 21 Oct 2020 05:21:44 +0000



[Programming Help] - Painting Candle (OHLC) with Spreadsheet Study

[2020-09-25 01:52:55]
User753843 - Posts: 7 | Ending Date: 2021-04-20
Hello, would it be possible to post an example spreadsheet study of this? I understand that Price Graph Style must be turned on to "yes" but I am having some difficulty figuring out how the formulas would work in KLMN since the values are constantly changing.

Thank you!
[2020-09-25 05:35:17]
Sierra Chart Engineering - Posts: 90557 | Ending Date: 2021-04-05
If you just want to color a bar a particular color when a condition is true, then you would use the Spreadsheet System/Alert Study:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php

And you would not set Use Price Graph Style to Yes. You just use a formula that returns any nonzero value when true.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2020-09-25 05:35:45
[2020-09-25 06:26:18]
User753843 - Posts: 7 | Ending Date: 2021-04-20
Thanks for the quick response. To clarify, I have a subgraph in a spreadsheet that I'd like to display the OHLC instead of just a point at close. I understand I will need 4 formulas, in columns K,L,M,N for OHLC.

The formulas show the latest reading so I am a bit confused on how to capture the Open, High, and Low, as the numbers are always updating (Close).

Would it be possible to point me to an example of a spreadsheet study with a candle output?
[2020-09-25 19:36:28]
Sierra Chart Engineering - Posts: 90557 | Ending Date: 2021-04-05
So do you want to display different Open, high, Low, Close values as compared to the actual chart bar?
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2020-09-25 22:23:56]
User753843 - Posts: 7 | Ending Date: 2021-04-20
I would like to display the OHLC for AskTrades-BidTrades (Numbers bars calculated values).

Open and Low will be 0 and Close is plotted by default, so really I am curious how to plot the High.

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

Login

Login Page - Create Account