Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 18:50:06 +0000



[User Discussion] - Formula with one value but different condition

View Count: 1215

[2013-08-25 09:41:34]
levamit12 - Posts: 5
hello Guys,

I tried to build Will%R condition to enter the trade with 4 lines values -80,-50,-20,0 .
The fromula at column K is =CROSSFROMBELOW(B3:B4,BB3:BB4)
The K column is the Long Entry column. If a cell in this column is TRUE.
Where B3:B4 refers to the Last values of the williams%R column, and BB3:BB4 refers to the Horizontal line values (-80).
The columns of horizontal lines values are: BA =-20 BB=-80 BC=-50 BD=0
What formula should be if I want that Will%R crossed above -80 line or -50 line or -20 or 0 line with one formula to enter the trade? and not only one value like i did BB3:BB4 ?

Please Advice,
Thanks
[2013-08-25 14:31:30]
Sawtooth - Posts: 3952
To get a TRUE when the Williams %R crosses from below -80, or -50, or -2; or =0 try this:

=OR(CROSSFROMBELOW(AA3:AA4,BA3:BA4),CROSSFROMBELOW(AA3:AA4,BB3:BB4),CROSSFROMBELOW(AA3:AA4,BC3:BC4),AA3=BD3)

where AA is the Williams %R column.


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

Login

Login Page - Create Account