Login Page - Create Account

Support Board


Date/Time: Sat, 12 Jul 2025 07:37:59 +0000



Post From: color background based on alert condition

[2016-05-20 03:24:16]
Sawtooth - Posts: 4238
These formulas will eliminate some of the alerts because they require the CCI to be on the OB/OS side of zero:
=OR(AND(CROSSFROMABOVE(ID9.SG1,ID9.SG3),ID6.SG1>ID7.SG1),AND(ID9.SG1<ID9.SG3,ID9.SG1>0,CROSSFROMBELOW(ID6.SG1,ID7.SG1)))
=OR(AND(CROSSFROMBELOW(ID9.SG1,ID9.SG4),ID6.SG1<ID7.SG1),AND(ID9.SG1>ID9.SG4,ID9.SG1<0,CROSSFROMABOVE(ID6.SG1,ID7.SG1)))

See bolded above. You could experiment with using a value other than zero to eliminate more spurious alerts.