Login Page - Create Account

Support Board


Date/Time: Sun, 29 Dec 2024 16:03:05 +0000



Using Color Bar Based On Alert Condition

View Count: 837

[2016-01-29 23:10:57]
User469312 - Posts: 97
Just need some guidance here. using 2 different current indicators. When they line up or when both hovering around zero and or just fractionally Plus or minus from zero (will look to scale this value ) would like to have the Bar on chart turn a different color. I know the mechanics but seem to be having a problem with the fact that both current indicators can both have a positive or negative value but close to zero. any help or direction would be of great help.
[2016-01-30 00:27:55]
Sawtooth - Posts: 4143
Try something like this:
=AND(ID1.SG1>-0.5,ID1.SG1<0.5,ID2.SG1>-0.5,ID2.SG1<0.5)
[2016-01-30 03:58:19]
Sierra Chart Engineering - Posts: 104368
We do not provide formula programming help.

Although possibly using the ABS function would help:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html#AvailableFunctions
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

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

Login

Login Page - Create Account