Support Board
Date/Time: Tue, 26 Nov 2024 11:50:36 +0000
Post From: Formula for once column K has a true signal, it can not repeat a true signal until column L has
| [2014-04-27 04:52:15] |
| User33781 - Posts: 5 |
|
Thanks, I tried the formula and it looks like it would work for row 3 and 4 (or 2 rows back). I need it to go back as many rows as needed to find the last true signal until the opposite buy/ sell column has a true signal. I'm looking for just the first signal true for buy (K3) and then to skip any new true signals in column K until the first true signal in L (L3). Then after the first true signal in column L skip any true signals in column L until the first true signal in column K. My problem is after I reach my target price and the position is closed I do not want to re enter on the 2nd or 3rd 4th ect true signal in the same column. It seems like a formula would be easy enough to make, but I have tried for 2 months and cant come up with one. A formula would need to monitor the 2 columns (K, L),be able to find the last True signal, and then only allow the opposite column to signal the next true signal. Any help would be appreciated.
|