Login Page - Create Account

Support Board


Date/Time: Fri, 07 Feb 2025 15:10:19 +0000



[Programming Help] - How to Colour Price Bars base on Green and Red Cumulative Delta Volume bars ?

View Count: 1535

[2021-06-21 04:50:53]
FH87 - Posts: 43
HElPPPppPPppp.................How to Colour Price Bars, base on those Green bar and Red bar for that Cumulative Delta Volume ?



Try out search on how to do it, can't get it. Come to board for Help. Thank You

SG and ID details on attachment PNG file
Color Bar Based on Alert Condition study


http://www.sierrachart.com/image.php?Image=162425045675.png
Date Time Of Last Edit: 2021-06-21 04:52:54
imageaa20210621777882.png / V - Attached On 2021-06-21 04:47:22 UTC - Size: 87.97 KB - 254 views
[2021-06-21 12:21:48]
Sawtooth - Posts: 4173
You'll need to create a persistent value for each of the two colors so that it stays the same until the next color change.

Add the Spreadsheet Formula study
- Set the Chart Region to 1
- Use a formula like this in the Formula field:
=IF(AND(ID8.SG1[0]>ID8.SG1[-1],ID8.SG1[-1]<=ID8.SG1[-2]),1,IF(AND(ID8.SG1[0]<ID8.SG1[-1],ID8.SG1[-1]>=ID8.SG1[-2]),-1,ID6.SG1[-1]))
where ID6 is the Spreadsheet Formula study, and ID8 is the SMA Length 1 of the CDelta study.
- Set the Draw Style to Color Bar
- Set the Auto-Coloring to Based On +/-

The formula is a variation of example #9 here:
Study/Chart Alerts And Scanning: Alert Formula Examples
Date Time Of Last Edit: 2021-06-21 12:22:02
[2021-06-22 04:24:32]
FH87 - Posts: 43
Yooo Tonmgib,

thank for your help

with trial and error I manage to get it from your guide

Thanksssssssss...........Have a Nice Day !

http://www.sierrachart.com/image.php?Image=1624335905209.png
Date Time Of Last Edit: 2021-06-22 04:25:12
[2022-09-22 13:56:20]
User314524 - Posts: 14
HI
Is it possible to show exactly how you achieved to colour the price bars based on the CD
Thanks

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

Login

Login Page - Create Account