Support Board
Date/Time: Wed, 30 Apr 2025 20:09:51 +0000
[User Discussion] - Simple Alert RSI (and or OR relation) ?
View Count: 2883
| [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] |
| |
|
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: 4211 |
|
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: