Login Page - Create Account

# Support Board

Date/Time: Thu, 18 Oct 2018 17:19:38 +0000

## [User Discussion] - Simple Alert RSI (and or OR relation) ?

Support Request:
 [2013-04-01 09:31:27] #1 zatopek - Posts: 15 Hi, Please help me. I want to use a simple alert when the RSI is crossing from below the 70 or crossing from above the 30. In the examples I've seen this =AND(CROSSOVER(SG1, SG2), SG1 > 70) That's only from below crossing the 70. But I want to use the formula also for crossing from above the 30. How do I do this? I am getting confused which parameter I have to use, AND or OR. In my case, SG3 is the 30 line. Would anybody be so kind to give me the complete formula? Thanx! Johan
 [2013-04-01 16:28:34] #2 Sierra Chart Engineering - Posts: 64948 This is the formula you will want to use: =OR (AND(CROSSOVER(SG1, SG2), SG3 <30) ,AND(CROSSOVER(SG1, SG2), SG1 > 70) ) Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2013-04-17 07:29:15] #3 zatopek - Posts: 15 =OR (AND(CROSSOVER(SG1, SG2), SG3 <30) ,AND(CROSSOVER(SG1, SG2), SG1 > 70) ) Thanks for the formula but it doesn't work for 100%.... When SG1 is crossing SG2 to go up I get a soundsignal but when SG1 is crossing SG3 to go down below 30 I get no soundsignal. Maybe there is something wrong in the formula or maybe I have to use ";" instead of "," because of my Windows language? Please help. Regards, Johan
 [2013-04-18 01:44:25] #4 tomgilb - Posts: 1972 Try this formula: =OR(AND(CROSSOVER(SG1,SG3),SG1SG2))

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