Home >> Support Board

Support Board

Date/Time: Fri, 10 May 2024 17:21:25 +0000

How to Post a Message for Support

[User Discussion] - Formula for once column K has a true signal, it can not repeat a true signal until column L has

View Count: 1110

[2014-04-19 22:28:19] #1 [Go To First Post]
User33781 - Posts: 5
In columns K and L for buy and sell I wish to not have any repeating true signal before the other column has a true signal. In other words once column K has a true signal, it can not repeat a true signal until column L has a true signal. I there a formula for this?

[2014-04-22 23:07:37] #2 [Go To First Post]
vegasfoster - Posts: 444
Maybe you already got this figured, but maybe try, in O3, =if(K3=true, 1, if(L3=true, 2, O4)) in K3, =and(original entry formula, O4=2) in L3, =and(original entry formula, O4=1)

[2014-04-27 04:52:15] #3 [Go To First Post]
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.

[2014-04-27 17:27:43] #4 [Go To First Post]
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.

[2014-04-27 21:53:47] #5 [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)

[2014-04-28 01:40:03] #6 [Go To First Post]
vegasfoster - Posts: 444
I am not completely following, do you have =AND(O4=TRUE,AC3>AM3) in U3 and =AND(P4=TRUE,AC3<AM3) in V3? If you do, then I don't think your buy entry and sell entry should be referring to O4 and P4, respectively. If I do exactly what you have except insert =AC3>AM3 in U3 and =AC3<AM3 in V3, e.g. for a moving average crossover, then everything works correctly.

[2014-04-28 03:32:03] #7 [Go To First Post]
skoosht - Posts: 13
I figured it out. Yeah i had some extra filters in O4 & P4, those were messing up your formula. My system has elements of crossovers but filtering out all the horrible consequences that crossovers bring to your price entry. Your formula helped me out with a part of it that I had been struggling to overcome. Thanks again, it works like a charm so far!

To post a message in this thread, you need to log in with your Sierra Chart account: