Login Page - Create Account

Support Board


Date/Time: Mon, 21 Apr 2025 23:36:11 +0000



Overlay or Special Color for Number Bars Calculated Values When Event Occurs

View Count: 173

[2025-02-14 16:08:30]
User708541 - Posts: 135
I'd like to have the Delta value on my Numbers Bars Calculated Values study be highlighted or colored in some way when a specific Numbers Bar closes within 95% of the Max or Min delta.

I'd also like to highlight or color the Max/Min Delta Values in my N.B. Calc. Values study if they have a very low or high value that I would set.

I've attached an image explaining what I'd like to do.

Is this possible?
imageColor Num Bar Calc Value.jpg / V - Attached On 2025-02-14 16:07:42 UTC - Size: 203.36 KB - 42 views
[2025-02-14 18:39:33]
John - SC Support - Posts: 39395
We are a bit confused by what you are asking, as we think the Numbers Bars Calculated Values option for "Color Background Based on Value Percentage" does exactly what you are asking for.

For example, if you want to color the background when the delta value is within 95% of the Maximum Delta for the defined period, then you would set your "Percent Compare Threshold" values to have the third number be 0.95 (i.e. "0.25, 0.50, 0.95") and then adjust the colors as you want them. At the other end, if you want to color values that are within 5% of the minimum, then your first value would be 0.05 (i.e. "0.05, 0.50, 0.95") and again, adjust the colors as needed.

Keep in mind you can control the whether the Maximum/Minimum values are determined from All Data or Daily Data through the Input for "Determine Maximum/Minimum Values for Background From". Refer to the following:
Numbers Bars: Determine Maximum/Minimum Values for Background From
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-02-15 20:42:03]
User708541 - Posts: 135
Support,

I must not have been clear. If you refer to my image, I am looking for a way to color a cell based on a comparison from another row. (Max Delta compared to Delta & Min Delta compared to Delta)
Based on the image I provided, if the Max delta for a bar is 940 and the bar closes with a delta of 940 then I want a color denoting that the the bar closed with a delta within 95% of that bar's max delta (Suggesting that aggressive buying is in control). Further if the bar's minimum delta is -1658 and the bar closes with a delta of -1657 than I want a color that denotes the bar closed with a delta within 95% of that bar's min delta Suggesting that aggressive selling is in control).

I want to go further than coloring based on the data within a row.

Hopefully this makes sense.

Is there a way to do this?
Date Time Of Last Edit: 2025-02-15 20:42:16
[2025-02-16 03:26:32]
Sierra_Chart Engineering - Posts: 19290
The only way to do something like this is to use the Color Bar Based on Alert Condition study:
Color Bar Based on Alert Condition

You will then have to create a formula referencing the data from the Numbers Bars Calculated Values study.

But this is going to give you an indication separate from the Numbers Bars Calculated Values table.
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, use the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2025-02-16 03:27:31

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

Login

Login Page - Create Account