Login Page - Create Account

Support Board


Date/Time: Sun, 19 Jan 2025 06:22:32 +0000



Color Cell Numbers Bars Calculated Values

View Count: 2128

[2014-10-20 03:04:47]
2garin - Posts: 184
Good afternoon.
Please tell me: Is it possible to fill the color of the cell Numbers Bars Calculated Values ​​of the indicator in accordance with their values​​?
image11.png / V - Attached On 2014-10-20 03:04:18 UTC - Size: 4.34 KB - 455 views
[2014-10-22 04:52:01]
Sierra Chart Engineering - Posts: 104368
This can be done sort of. You cannot change the background color of the cells but you can change the foreground color of the text. Refer to step 6 here:
http://www.sierrachart.com/index.php?l=doc/doc_NumbersBars.php#NumericInformationBelowBars
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2014-10-23 00:21:42]
2garin - Posts: 184
Good day.
I asked: Is it possible to paint the cell completely but not the text in the cell.
[2014-10-23 02:01:56]
Sierra Chart Engineering - Posts: 104368
No.
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2014-10-23 02:35:40]
ganz - Posts: 1048
User62522

FYI: "Colored Bar Statistics" study
[2018-02-28 07:29:55]
whats1thingnow - Posts: 407
is it possible to do this now since the 2014 request?

i want to replicate this market delta chart attached with "numbers bar calculated values" study
image1.png / V - Attached On 2018-02-28 07:29:12 UTC - Size: 471.89 KB - 493 views
[2018-02-28 18:28:24]
Sierra Chart Engineering - Posts: 104368
We will look into this. So you want to color the background of the cell rather than the text foreground?
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2018-02-28 20:17:53]
binaryduke - Posts: 375
Would be a great enhancement
[2018-03-01 02:57:48]
whats1thingnow - Posts: 407
We will look into this. So you want to color the background of the cell rather than the text foreground?

yes thank you!

basically the background of the calculated values will tell a story.

shown is a 5 min bar footprint chart and numbers bar:

1st row = volume
- light blue means little volume
- mid blue means some volume
- purple means higher than avg volume
- dark blue means lots of volume

2nd row = delta of bar
- light blue means delta is positive low in magnitude
- mid blue means delta is mid positive
- purple means delta is higher than avg
- dark blue means delta is very positive
(vice versa for negative delta)
- pink
- salmon
- bright orange
- dark red

3rd row = delta of day (same as row 2)



--



for the comparison of values, it would be great if we compare it to
1) actual value
- -1000 to 0, color 1
- 0-1000, color 2
- 1000-2000, color 3
- etc

or

2) % relative to yesterday/today
e.g. avg vol of today = x
- 25% of avg, color 1
- 75% of avg, color 2
- 150% of avg, color 3
- 300% or more of avg, color 4
[2018-03-01 08:35:42]
Acro - Posts: 441
I agree.

Whilst I only have three rows of NBCV (delta, CD and volume) being able to use some "color intelligence" on the background colors would be very useful
[2018-03-10 13:40:34]
scalperdude - Posts: 20
Yes, would be a great enhancement. Cheers.
[2018-03-11 04:01:19]
Logan W - Posts: 28
+1
[2018-03-18 00:25:54]
whats1thingnow - Posts: 407
for the comparison of values, it would be great if we compare it to



3) % relative to yesterday/today vol + have an absolute minimum threshold
e.g. avg vol of today = x
- default color is white
- 25% of avg, color 1 (light blue)
- 75% of avg, color 2 (mid blue)
- 150% of avg, color 3 (purple)
- 300% or more of avg AND 'min threshold 50000', color 4 (dark blue)



just adding more context here as i'm watching more how market delta does it (their color boxes changes over time)

this is the way they have it implemented i think, because volume changes so much from a day to day basis even for the same market

if we can set it like this, that means the color boxes CAN keep changing as new bars form

e.g.

5 min after market started
- bar1 (current bar) volume is at 10000 and it's the highest of the day
- without the 'min threshold 50000', it would be color 4 (dark blue)
- however, because there is a min threshold of 50000, even though it's the highest volume of the day, it will only be purple

10 min after market started
- bar2 (current bar) volume is 60000
- this is now highest of the day & passes 'min threshold 50000', it would be color 4 (dark blue)
- bar 1 color was purple, now will become light blue
- math: ((10000+60000)/2=35000 = avg volume; .25*35000=8750; bar 1 is 10000, 10000 is greater than 8750)


be great if anyone else can chime in if they know how market delta configures their number boxes
[2018-03-23 20:47:09]
John - SC Support - Posts: 37327
This is now available in version 1723 (currently the Prerelease).

The documentation for how the background coloring is done can be found here:
Numbers Bars: Calculated Values Background Coloring Logic
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