Support Board
Date/Time: Sun, 22 Dec 2024 18:53:59 +0000
[User Discussion] - Alert setting
View Count: 982
[2015-05-11 19:24:30] |
jaban - Posts: 66 |
Maybe somebody can help me with the following I took C as close of the bar ema 20 (high) = ID1.sg1 ema 20 (low) = ID2.sg1 RSI = ID3.sg1 and ID3.sg4 line 1 = ID3.sg2 ( = 55 horizontal line ) line 2 = ID3.sg3 ( = 45 horizontal line ) I came to the following : =OR((C above ID1.sg1) , and (ID3.sg1 above ID3.sg4), and ID3.sg1 above ID3.sg2)) , (( C below ID2.sg1) , and (ID3.sg1 below ID3.sg4) , and ( ID3.sg1 below ID3.sg3)) but it doesnot work. I am not sure about all the "and " Any suggestions appreciated Thanks Jaban |
[2015-05-11 19:38:35] |
Sawtooth - Posts: 4141 |
Try this syntax: =OR(AND(C>ID1.sg1,ID3.sg1>ID3.sg4,ID3.sg1>ID3.sg2),AND(C<ID2.sg1,ID3.sg1<ID3.sg4,ID3.sg1<ID3.sg3)) |
[2015-05-13 06:23:48] |
jaban - Posts: 66 |
Hi tomgilb thanks for formule To avoid an alert after each bar in the same direction , I have to add a "crossfrombelow - crossfromabove function to the C. I tried several combinations but get "error "as answer. Please tell me how to do this. Thanks a lot for your help Jaban |
[2015-05-13 13:29:04] |
Sawtooth - Posts: 4141 |
Try this: =OR(AND(C<ID1.sg1[-1],C>ID1.sg1,ID3.sg1>ID3.sg4,ID3.sg1>ID3.sg2),AND(C>ID2.sg1[-1],C<ID2.sg1,ID3.sg1<ID3.sg4,ID3.sg1<ID3.sg3)) |
To post a message in this thread, you need to log in with your Sierra Chart account: