Trigger to CANCEL IF

[manager1]

I'm after some help with a trigger please?

Currently in the trigger column I have =IF(A5<>"","LAY","")

I also need to include in the above formula, that if F5>=R5 AND my bet is still unmatched, then cancel my current lay and resubmit at the new odds in R5.

(I already have a formula in the stake column to change the stake depending on the odds, so that part is covered)

I'm really struggling with it, and got mixed up.

Any ideas?

[Smokin Joe]

Not sure you can cancel the current lay (as the formula can only fire once, so how can it place the bet and then check if it is matched and then place another bet) and place a new one with a formula. You may have to use VB.

[Roger]

I think it could be done with formulas by comparing the time to the off in cell D2 with constants in your formula, so that the required actions are done one after the other. But I have never actually checked a bet for being unmatched, nor cancelled a bet, so I can't show you the formula you need.

[Smokin Joe]

I think it could be done with formulas by comparing the time to the off in cell D2 with constants in your formula, so that the required actions are done one after the other. But I have never actually checked a bet for being unmatched, nor cancelled a bet, so I can't show you the formula you need.

I do use something like that, but I use code to do it.

Have a look at this post for how I do it. http://gruss-software.co.uk/forum/viewt ... 0&start=24