Support Board
Date/Time: Tue, 26 Nov 2024 11:42:26 +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 21:53:47] |
| skoosht - Posts: 13 |
|
thanks vegasfoster, i've been looking for something exactly like this too. I've tried the formula with my settings and it seems to work for the Buy column but doesn't change for the Sell column. My formulas are a bit different but this is what I have, can you see if you can tell what i'm doing wrong? I've moved the columns around a little because i have some extra formulas being calculated. The W column only has 2 in it. It never changes to 1 for the sell side. In K3, =AND(U3=TRUE, W4=2) In M3, =AND(V3=TRUE, W4=1) In U3, =buy entry condition In V3, =sell entry condition In W3, =IF(AND(U3=TRUE, V4=TRUE), 1, IF(AND(U4=TRUE, V3=TRUE), 2, W4)) buy entry =AND(O4=TRUE,AC3>AM3) sell entry =AND(P4=TRUE,AC3<AM3) |