Login Page - Create Account

Support Board


Date/Time: Mon, 17 Jun 2024 08:18:31 +0000



Color bar help

View Count: 187

[2024-04-23 21:10:19]
User411320 - Posts: 278
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
imageScreenshot 2024-04-23 170604_.png / V - Attached On 2024-04-23 21:10:08 UTC - Size: 9.15 KB - 33 views
[2024-04-23 21:18:11]
John - SC Support - Posts: 32379
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]
User411320 - Posts: 278
Thank you
[2024-04-24 18:54:34]
User411320 - Posts: 278
so the formula worked, but it's not coloring the bar past this week no matter how much bar I put to color
imageScreenshot 2024-04-24 145219.png / V - Attached On 2024-04-24 18:54:22 UTC - Size: 81.15 KB - 33 views
imageScreenshot 2024-04-24 145403.png / V - Attached On 2024-04-24 18:54:29 UTC - Size: 50.87 KB - 28 views
[2024-04-24 20:26:44]
User411320 - Posts: 278
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]
John - SC Support - Posts: 32379
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]
User411320 - Posts: 278
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
imageScreenshot 2024-04-25 075435.png / V - Attached On 2024-04-25 11:56:04 UTC - Size: 25.26 KB - 22 views
imageScreenshot 2024-04-25 075502.png / V - Attached On 2024-04-25 11:56:11 UTC - Size: 33.07 KB - 30 views
[2024-04-25 12:04:32]
User411320 - Posts: 278
File attached
imageScreenshot 2024-04-25 080258.png / V - Attached On 2024-04-25 12:04:25 UTC - Size: 42.25 KB - 28 views
[2024-04-25 15:02:11]
John - SC Support - Posts: 32379
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]
User411320 - Posts: 278
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]
John - SC Support - Posts: 32379
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:

Login

Login Page - Create Account