Support Board
Date/Time: Sun, 07 Sep 2025 19:11:59 +0000
Color Bar Alerts - Is this possible???
View Count: 177
| [2025-08-29 18:05:59] |
| TopGunTrader - Posts: 226 |
|
Hi, Trade Devils makes a 3rd party footprint I don't like the way they look and they use way too much CPU so I never use them HOWEVER they do two cool things I'd like to code up in Sierra using Color Bar Alerts. One is a BOX around entire bar if say 3+ imbalances happen in a bar its a great sign for future short term trend direction. Second is coloring in an AREA in this case notice it shows the value area of the bar colored green because its ABOVE the previous bar's this also tends to be bullish. A few bars later you see a red one and price short term continues that direction. So I'd like to be able to draw a box around the candle from high to low and also FILL in two areas if an alert condition is true. Can either of these be done and if so how? Thanks these will help me so much its just a clean and intuitively obvious way to see important things. |
 Capture.PNG / V - Attached On 2025-08-29 18:05:45 UTC - Size: 115.19 KB - 40 views |
| [2025-08-29 21:43:03] |
| John - SC Support - Posts: 41652 |
|
The general way to do this is to setup two Spreadsheet Formula studies, each that will perform the test you want where one will return the lowest price value in the bar and the other will return the highest price value in the bar and otherwise to be zero. Keep in mind that despite its name, the Spreadsheet Formula uses the Alert syntax. Refer to the following: Spreadsheet Formula Then you would use the "Study Subgraphs Reference" to reference the two Spreadsheet Formula studies and set the Draw Style for the subgraphs for the "Study Subgraphs Reference" to be "Fill Rectangle Top" and "Fill Rectangle Bottom". Refer to the following: Study Subgraphs Reference Chart Studies: Notes about Top and Bottom Draw Style Pairs For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-08-29 21:44:14
|
| [2025-08-30 03:29:19] |
| TopGunTrader - Posts: 226 |
|
Thanks makes complete sense. The other thing I wanted to do was draw a BOX rectangle around the entire space as in the pic. Is this possible as well?
|
| [2025-08-30 13:20:04] |
| TopGunTrader - Posts: 226 |
|
I got the value area shift colored looks absolutely fantastic. Does the Spreadsheet study take up a ton of CPU or resources was considering having it on separate chart with a 20-30 second update frequency and then display on other chart. If I want to have multiple ones I suppose I need to create new spreadsheet name for each I'm now to spreadsheets. |
| Capture.PNG / V - Attached On 2025-08-30 13:18:44 UTC - Size: 96.91 KB - 31 views |
| [2025-09-01 14:58:32] |
| John - SC Support - Posts: 41652 |
|
To get both the colored rectangle and the outline, use draw styles of "Candlestick Body Open" and "Candlestick Body Close". Refer to the following: Chart Studies: Candlestick Body Open (ACSIL: DRAWSTYLE_CANDLESTICK_BODY_OPEN) and Candlestick Body Close (ACSIL: DRAWSTYLE_CANDLESTICK_BODY_CLOSE) We recommend using the "Spreadsheet Formula" rather than the "Spreadsheet Study". The Spreadsheet Formula is not very intensive, so having multiple copies should not be too bad. You need to test and see for your purposes though. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-09-02 16:44:04] |
| TopGunTrader - Posts: 226 |
|
I can't seem to get this to put line around candle. I know you guys are very busy but would like to make a suggestion new Draw Style Rectangle Surrounding Candle. Here's example of what it would look like. Ideally there should be two subgraphs so if an alert is hit one can color between those two levels or have rectangle/square line around it. I'd love to have an alert condition that would for example mark a ZONE above/below candle for future buying/selling. What you guys helped me with spreadsheet study made a HUGE impact on today's trading helped me see trend direction so much better than normal can't thank you guys enough! |
| Capture.PNG / V - Attached On 2025-09-02 16:43:07 UTC - Size: 52.7 KB - 13 views |
| [2025-09-02 19:45:03] |
| John - SC Support - Posts: 41652 |
|
There is a Draw Type of "Box Top" and "Box Bottom", which draws an empty rectangle, but the reason we did not point you to this is that it draws between two bars and not over a single bar, so it will not work for what you are wanting.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-09-03 10:51:56] |
| TopGunTrader - Posts: 226 |
|
Thanks for your help the value area color when it shifts really improves my trading want to use it on 2 or 3 time frames on both ES and NQ and don't want to have up to 6 spreadsheets for this. I appreciate the "Candlestick Body Open" and "Candlestick Body Close" but I can't seem to get it to work on spreadsheet formula. Can you guys upload a sample say if C>O color HI to LO I can't seem to see any examples of this and spent 15-20 mins trying to get it to work and failed it seems to plot to 0 or far above bar off the screen to the top. |
| [2025-09-03 15:41:37] |
| John - SC Support - Posts: 41652 |
|
You need to use the same concept as previously, where you need to have one subgraph set to the High when the condition is true and another subgraph set to the Low when the condition is true, then use the Study Subgraphs Reference to draw what you want using the Top/Bottom draw styles.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-09-03 17:36:32] |
| TopGunTrader - Posts: 226 |
|
Hi, I was unaware the Spreadsheet formula had conditional capabilities I finally figured that out and it draws the value area high and low only when condition is met gray dashes. When I use Study Subgraphs Reference and fill using method above you gave me it doesn't work. I've attached simple 1 chart chartbook with this setup. This is an amazing advanced functionality I will use in this case and many others so really want to know what I'm doing wrong. Thanks |
Capture.PNG / V - Attached On 2025-09-03 17:32:53 UTC - Size: 189.02 KB - 8 views  SierraChartFillValue.Cht - Attached On 2025-09-03 17:33:03 UTC - Size: 4.59 KB - 9 views |
| [2025-09-03 18:10:35] |
| John - SC Support - Posts: 41652 |
|
Two things in particular with your "Study Subgraphs Reference". - The option for "Draw Zeros" is set to "Yes". This should be set to "No". In general, in Sierra Chart, a value of 0 means to hide something or not display it. Since there are times when a zero can actually mean 0, there is the option to show it, but in general this should be no. - The Scale for the "Study Subgraphs Reference" is set to "Independent". It needs to be "Same as Region". Refer to the following: Chart Scale and Scale Adjusting: Same As Region (Scale Range) For the most reliable, advanced, and zero cost futures order routing, use 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: