Login Page - Create Account

Support Board


Date/Time: Mon, 20 May 2024 21:28:04 +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 17:27:43]
vegasfoster - Posts: 444
Sorry, either drunk or tired, except I don't drink or sleep, so I dunno,

Anyway,

In K3, =AND(O3=TRUE, Q4=2)
In L3, =AND(P3=TRUE, Q4=1)
In O3, =buy entry condition
In P3, =sell entry condition
In Q3, =IF(AND(O3=TRUE, P4=TRUE), 1, IF(AND(O4=TRUE, P3=TRUE), 2, Q4))

Note that column L is the buy cover column and not the sell entry column.