Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 27 Sep 2024 05:19:40 +0000
How to apply this condition for study alert?
View Count: 1259
| [2016-02-04 23:29:30] |
| User930527 - Posts: 2 |
|
Using horizontal lines attached to a study - for example RSI - would like an alert *(sound) on crossover of additional-placed-lines..)ok for example: a. Alert on crossover 75, 80, 85 (placed on RSI-study using horizontal-lines-study) b. same as above but on support 25, 20,15 Here is the code i tried but did no work: =CROSSOVER(ID1.SG1, ID2.SG2, ID2.SG3, ID2.SG4, ID2.SG5, ID2.SG6, ID2.SG7) Thanks |
| [2016-02-05 04:27:23] |
| |
|
This is not correct. You need to use the OR function with multiple CROSSOVER functions. Refer to: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html 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 |
| [2016-02-05 20:36:34] |
| User930527 - Posts: 2 |
|
Thanks for the quick reply, Could you please give me an example of OR in Combination with Crossover function. Thanks again RE PJ P.S. - this is what i picked-up from the link you supplied: =OR(AND(H > 100,SG1 > 100),AND(L < 80,SG1 < -100)) |
| [2016-02-08 18:23:25] |
| |
|
Refer to example 12 here: https://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php#FormulaExamples 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: