Login Page - Create Account

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:

Login

Login Page - Create Account