Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 24 Apr 2024 08:52:22 +0000
[Programming Help] - Painting Candle (OHLC) with Spreadsheet Study
View Count: 448
| [2020-09-25 01:52:55] |
| User753843 - Posts: 8 |
|
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] |
| |
|
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: Spreadsheet Systems, Alerts and Automated Trading 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. 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 Date Time Of Last Edit: 2020-09-25 05:35:45
|
| [2020-09-25 06:26:18] |
| User753843 - Posts: 8 |
|
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] |
| |
|
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. 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 |
| [2020-09-25 22:23:56] |
| User753843 - Posts: 8 |
|
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 log in with your Sierra Chart account: