Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 22:11:20 +0000



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

View Count: 2630

[2013-04-01 09:31:27]
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]
Sierra Chart Engineering - Posts: 104368
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. 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
[2013-04-17 07:29:15]
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]
Sawtooth - Posts: 3976
Try this formula:

=OR(AND(CROSSOVER(SG1,SG3),SG1<SG3),AND(CROSSOVER(SG1,SG2),SG1>SG2))

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

Login

Login Page - Create Account