Home >> Support Board

Support Board

Date/Time: Sat, 04 May 2024 11:37:15 +0000

How to Post a Message for Support

Color bar help

View Count: 113

[2024-04-23 21:10:19] #1 [Go To First Post]
User411320 - Posts: 265
attached is a picture showing a subgraph of a spreadsheet formula I'm working on. How would I go about coloring bars whenever the line crosses and closes above the 0.200 line? thanks


Screenshot 2024-04-23 170604_.png / V - Attached On 2024-04-23 21:10:08 UTC - Size: 9.15 KB - 21 views

[2024-04-23 21:18:11] #2 [Go To First Post]
John - SC Support - Posts: 31362
Use the following formula for the alert in the "Color Bar Based on Alert Condition" study: ID1.SG1 > 0.2 Where ID1 is the ID of the study that draws the line and SG1 is the subgraph of the study that is the line. Refer to the following: Color Bar Based on Alert Condition For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-24 13:08:49] #3 [Go To First Post]
User411320 - Posts: 265
Thank you

[2024-04-24 18:54:34] #4 [Go To First Post]
User411320 - Posts: 265
so the formula worked, but it's not coloring the bar past this week no matter how much bar I put to color


Screenshot 2024-04-24 145219.png / V - Attached On 2024-04-24 18:54:22 UTC - Size: 81.15 KB - 18 views Screenshot 2024-04-24 145403.png / V - Attached On 2024-04-24 18:54:29 UTC - Size: 50.87 KB - 14 views

[2024-04-24 20:26:44] #5 [Go To First Post]
User411320 - Posts: 265
Also how can I color a bar whenever it closes above or below the 0 line? just the 1 bar

[2024-04-24 23:11:34] #6 [Go To First Post]
John - SC Support - Posts: 31362
so the formula worked, but it's not coloring the bar past this week no matter how much bar I put to color Did you change the formula to be the ID and Subgraph for your study? ID1 and SG1 are just examples. You need to change these for your setup. Also how can I color a bar whenever it closes above or below the 0 line? just the 1 bar We are not understanding this. It will always close either above or below the 0 line (the chances of the studies that you are showing in your image, having a value of exactly 0 are very slim). Are you wanting different coloring for above zero than below zero? And what do you mean by "just the 1 bar"? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-25 12:04:13] #7 [Go To First Post]
User411320 - Posts: 265
Hello John, Did you change the formula to be the ID and Subgraph for your study? ID1 and SG1 are just examples. You need to change these for your setup. Yes I changed the formula, please see attached photos. We are not understanding this. It will always close either above or below the 0 line (the chances of the studies that you are showing in your image, having a value of exactly 0 are very slim). Are you wanting different coloring for above zero than below zero? And what do you mean by "just the 1 bar"? Sorry, I'll try to explain better. I would like to color the bar of the exact candle that causes the study to close above or below 0. I've attached a photo with yellow vertical lines. In essence I would like the study to color those bars


Screenshot 2024-04-25 075435.png / V - Attached On 2024-04-25 11:56:04 UTC - Size: 25.26 KB - 12 views Screenshot 2024-04-25 075502.png / V - Attached On 2024-04-25 11:56:11 UTC - Size: 33.07 KB - 13 views

[2024-04-25 12:04:32] #8 [Go To First Post]
User411320 - Posts: 265
File attached


Screenshot 2024-04-25 080258.png / V - Attached On 2024-04-25 12:04:25 UTC - Size: 42.25 KB - 14 views

[2024-04-25 15:02:11] #9 [Go To First Post]
John - SC Support - Posts: 31362
With regards to the bars that are being colored (or not being colored going back), we see that you have the "Numbers of Bars to Calculate" set to 1000. Try increasing this to get colored bars further back in time. With regards to the other question, the image you provided is basically asking to color the bar when the study value is 0. In order to overcome floating point errors and the fact that the result may not be exactly zero, you would want to test a small range of data around zero. So you would use a formula like the following: =AND(ID1.SG1 > -.01, ID1.SG1 < .01) This will give you a true result when the value of that subgraph at that bar is between 0.01 and -0.01. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-25 20:37:14] #10 [Go To First Post]
User411320 - Posts: 265
Hello John, So I set the bars to calculate to 5000 and still won't go past yesterday. The formula you gave worked and oddly enough it colors bars past yesterday

[2024-04-25 21:39:27] #11 [Go To First Post]
John - SC Support - Posts: 31362
Get us the chart where you are having the issue with it not drawing further back and we'll take a look. Follow these instructions to get us the chart: Support Board Posting Information: Providing Chartbook with Only a Single Chart 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: