Login Page - Create Account

Support Board


Date/Time: Mon, 17 Jun 2024 03:57:47 +0000



Post From: moving averages color alert

[2016-03-08 17:38:08]
Sawtooth - Posts: 4024
Try this:
=OR(AND(ID1.SG1[-1]<ID1.SG1[-2],ID1.SG1>ID1.SG1[-1],ID1.SG2>ID1.SG2[-1],ID1.SG3>ID1.SG3[-1]),
AND(ID1.SG1>ID1.SG1[-1],ID1.SG2[-1]<ID1.SG2[-2],ID1.SG2>ID1.SG2[-1],ID1.SG3>ID1.SG3[-1]),
AND(ID1.SG1>ID1.SG1[-1],ID1.SG2>ID1.SG2[-1],ID1.SG3[-1]<ID1.SG3[-2],ID1.SG3>ID1.SG3[-1]))

where the Multiple Averages study is ID1, edit as needed.

This will alert at the first occurrence of all three MAs sloping up.

To get the alert at the first occurrence of all three MAs sloping down, copy/paste the same to another study's Alerts tab, and reverse all of the comparison operators.

Up and down alerts need to be separated because combining them exceeds the 375 character limit for Simple Alerts.

If you'd like to see a visual of which bars will alert, add two instances of the Color Bar Based On Alert Condition study, one for up slope and one for down slope, and use the same formulas in each.