Login Page - Create Account

Support Board


Date/Time: Tue, 04 Mar 2025 21:11:14 +0000



[Programming Help] - Would like to have a Color bar base on Alert condition for a Cumulative Delta Study. BUT..

View Count: 562

[2021-12-31 04:22:14]
GravisHTG - Posts: 306
I cant find the way to make it work when the number have both more than 0 and less than 0 to be considere.

I go with (((High minus Low)*2)/2) of [0] >= (((High minus Low)*2)) of [1]

My goal is to paint the bar if the Bar size is greater than 2 times of the last bar.

It work on some occation but now I realize , it just wont work if in the negative , How should I approach it to make it work at all time ?

Just had an idea - Will use the ATR on the Cumdelta to get the bar range than plot one the graph with Color bar.
Date Time Of Last Edit: 2021-12-31 05:21:21
[2021-12-31 13:58:22]
Sawtooth - Posts: 4179
Try this:
=ABS(ID1.SG2-ID1.SG3) >= ABS(ID1.SG2[-1]-ID1.SG3[-1]) *2
where ID1 is the Cumulative Delta Bars study.

https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ABS_Function

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

Login

Login Page - Create Account