Login Page - Create Account

Support Board


Date/Time: Sun, 22 Jul 2018 02:38:59 +0000



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

Support Request:
[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: 61947
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]
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]
tomgilb - Posts: 1877
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 login with your Sierra Chart account:

Login


Login Page - Create Account