Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 10:22:45 +0000



[User Discussion] - Range Bar Alert Formula Needed???

View Count: 1858

[2013-07-07 22:56:34]
User20200 - Posts: 38
Hello Guys,

I use Range Bars and want an Email Alert Formula when a Price BAR CLOSES the other way! (Range Bars only close up (High) or down (Low)...

Example:
You have Price Bars going UP (Long) say 4 in a row, then the 5th Price Bar Closes Down (Short)...

I only want an alert on that bar that closes the opposite way, so I am Alerted that the direction has changed.

Thank you,
Team One

[2013-07-08 15:21:41]
Sawtooth - Posts: 3976
Try this:

=OR(AND(C[-4]=L[-4],C[-3]=L[-3],C[-2]=L[-2],C[-1]=L[-1],C=H),AND(C[-4]=H[-4],C[-3]=H[-3],C[-2]=H[-2],C[-1]=H[-1],C=L))
[2013-07-08 16:47:44]
User20200 - Posts: 38
Not working properly...

If there is only 1 Price Bar and it flips or reverses the other way, I want to be alerted!

Need an alert for every Price Bar that closes opposite of the previous Price Bar...

Thank you,
Team One
[2013-07-08 16:56:24]
Sierra Chart - Max - Posts: 5596
Try the following formula:

=OR(AND(C[-1]=L[-1],C=H),AND(C[-1]=H[-1],C=L))
Sierra Chart Support
Date Time Of Last Edit: 2013-07-08 16:57:15

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account