Login Page - Create Account

Support Board


Date/Time: Sun, 11 May 2025 04:33:12 +0000



Post From: color background based on alert condition

[2016-05-20 03:24:16]
Sawtooth - Posts: 4214
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.