Support Board

Date/Time: Mon, 20 May 2024 21:44:53 +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] Link To Thread - Link To Post [Go To First Post]
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)