Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 22:29:27 +0000



Post From: Formula with one value but different condition

[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