Support Board
Date/Time: Sat, 23 Nov 2024 21:22:51 +0000
[User Discussion] - Formula with one value but different condition
View Count: 1307
| [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: 4118 |
|
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: