Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 22:28:09 +0000
Post From: Help with Alert Formula on Engulfing Candle Crossing Horizontal Line or w/in 1% of line
| [2021-07-28 00:04:33] |
| Sawtooth - Posts: 3993 |
|
I see there is no reference to ID6.SG2, which references my bearish engulfing. does it not matter?
1) You found a typo I made, sorry about that. I corrected the formula in post #6 to this: =OR( AND(H>=ID7.SG1*0.99,L<=ID7.SG1*1.01,ID6.SG1=3,CROSSFROMBELOW(C,ID7.SG1)), AND(H>=ID7.SG1*0.99,L<=ID7.SG1*1.01,ID6.SG2=4,CROSSFROMABOVE(C,ID7.SG1))) 2) To do two lines: =OR( OR( AND(H>=ID7.SG1*0.99,L<=ID7.SG1*1.01,ID6.SG1=3,CROSSFROMBELOW(C,ID7.SG1)), AND(H>=ID7.SG1*0.99,L<=ID7.SG1*1.01,ID6.SG2=4,CROSSFROMABOVE(C,ID7.SG1))), OR( AND(H>=ID7.SG2*0.99,L<=ID7.SG2*1.01,ID6.SG1=3,CROSSFROMBELOW(C,ID7.SG2)), AND(H>=ID7.SG2*0.99,L<=ID7.SG2*1.01,ID6.SG2=4,CROSSFROMABOVE(C,ID7.SG2)))) You can see that multiple lines will make this formula lengthy and unwieldy. With the Spreadsheet System/Alert study, you would put each line's formula in its own column (O-BR), then combine them with an OR(...) in another column (K). You could have up to 56 line formulas, or you could split the alerts between buy and sell and have up to 28 each. If you want me to build this for you for a fee, contact me here: https://www.sawtoothtrade.com/contact.html |