Home >> Support Board

Support Board

Date/Time: Sat, 07 Mar 2026 05:06:21 +0000

How to Post a Message for Support

Divergence color bar alert condition

View Count: 226

[2026-01-17 20:16:36] #1 [Go To First Post]
jethrogou - Posts: 38
Good day, I am wondering how I could create a color bar alert condition for the divergence of a swing high/low study based on CVD and its study subgraph reference based on main graph. I am currently having trouble with referencing a range of [-3] bars and making the condition also reference the swing high on my CVD. Here is my alert condition: =OR( AND( ID7.SG1 [-1] < 0, ID6.SG1 [-1] > 0), AND( ID7.SG1 [-2] < 0, ID6.SG1 [-2] > 0), AND( ID7.SG1 [-3] < 0, ID6.SG1 [-3] > 0)) Where: ID7 = Study Subgraph Reference ID6 = Swing high and Low (On CVD) SG1 = Swing High SG2 = Swing Low Date Time Of Last Edit: 2026-01-17 20:17:40


Screenshot 2026-01-18 041534.png / V - Attached On 2026-01-17 20:16:28 UTC - Size: 126.44 KB - 37 views

[2026-01-17 20:28:22] #2 [Go To First Post]
jethrogou - Posts: 38
Updated Condition: =OR( AND( ID7.SG1 > ID6.SG1, ID7.SG2 < ID6.SG2), AND( ID7.SG1 > ID6.SG1[-1], ID7.SG2 < ID6.SG2[-1]), AND( ID7.SG1 > ID6.SG1[-2], ID7.SG2 < ID6.SG2[-2]), AND( ID7.SG1 > ID6.SG1[-3], ID7.SG2 < ID6.SG2[-3])) Attached image is the result I want to get the color bar to appear in the previous post's attached image


Screenshot 2026-01-18 042801.png / V - Attached On 2026-01-17 20:28:16 UTC - Size: 116.02 KB - 40 views

[2026-01-19 18:14:52] #3 [Go To First Post]
John - SC Support - Posts: 44982
We are not understanding the issue. The images look exactly the same. What exactly is the issue? What are you trying to do that is not working? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2026-01-20 01:18:26] #4 [Go To First Post]
jethrogou - Posts: 38
Good day, I've recently discovered spreadsheet system/alert study to help me with my issue. But I encountered another issue when loading to current day's price. It was working the day I added the spreadsheet study but is now doing this. Its similar to Sawtooth's spreadsheet but I added some more conditions to a different cell which shouldn't cause an issue the original conditions. Date Time Of Last Edit: 2026-01-20 04:57:06


Screenshot 2026-01-20 091743.png / V - Attached On 2026-01-20 01:18:17 UTC - Size: 122.11 KB - 29 views Screenshot 2026-01-20 091924.png / V - Attached On 2026-01-20 01:19:45 UTC - Size: 101.47 KB - 23 views

[2026-01-20 03:56:45] #5 [Go To First Post]
jethrogou - Posts: 38
I was able to fix the issue by removing the spreadsheet study and adding it back again. Is there a way to not keep doing this?

[2026-01-20 04:54:49] #6 [Go To First Post]
jethrogou - Posts: 38
I'm also having trouble understanding how to pull data from sheet 1 into sheet 2 and having 1 formula cover a column similar to sheet 1.


Screenshot 2026-01-20 125207.png / V - Attached On 2026-01-20 04:52:29 UTC - Size: 48.93 KB - 27 views Screenshot 2026-01-20 125345.png / V - Attached On 2026-01-20 04:54:01 UTC - Size: 65.09 KB - 29 views

[2026-01-20 09:08:23] #7 [Go To First Post]
jethrogou - Posts: 38
All good now. I just decided to increase the cell formula and adjusted my conditions, but I'm still confused as to what the use of sheet2 is and how to configure it similar to sheet1. Overall happy with my work, didn't know you can do so much with the spreadsheet study.


Screenshot 2026-01-20 170440.png / V - Attached On 2026-01-20 09:06:06 UTC - Size: 109.34 KB - 28 views

[2026-01-20 14:03:58] #8 [Go To First Post]
Sawtooth - Posts: 4315
I'm still confused as to what the use of sheet2 is and how to configure it similar to sheet1. By default, the Sheet# matches the Chart#, when adding a spreadsheet study to a chart. However, if you go to Spreadsheet >> Add Sheet, it will add a blank sheet with the next available Sheet#. This can be confusing, so best practice when adding a blank sheet is to rename it. A blank sheet can be used when more complicated static conditions, or a matrix, need to be referenced by the chart's Sheet. (You can also use Column H on the chart's sheet for simpler references, since it's a blank column.) A blank sheet cannot be made to look nor function like a chart's sheet. didn't know you can do so much with the spreadsheet study. Spreadsheet studies are unique to Sierra Chart, and very powerful when using all of its features. It's a bridge between Simple Alerts and ACSIL. Here are some things that can be done: https://www.sawtoothtrade.com/free-stuff Date Time Of Last Edit: 2026-01-20 14:16:39

[2026-01-20 14:18:06] #9 [Go To First Post]
jethrogou - Posts: 38
Oh, thank you for the response! I initially thought a second sheet could replicate the main sheet, and thank you as well for the free access to your Swing High scss file, it became the foundation of my spreadsheet. I simplified it a bit, which made it less precise, and also added some divergence elements based on what I learned from your scss. It was difficult to optimize due to the many conditions involved, but I managed to split them across different spreadsheet study. I’m still not sure if that was the best approach though.

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