Cancel unmatched trigger

[Ian1506]

Hi folks.
I am using excel to LAY-IP at set odds a minute before the off and will let the bets go in play.

As soon as the first bet is matched I would like to cancel all the remaining bets and not place any furher bets.

Below is the lay bet part of the trigger but I have no idea how to word the cancel unmatched part.

=IF(AND(Time<=begin_after,$E$11<>"Suspended"),"LAY-IP",...................

When the lay bets are sent there will be a bet reference so I am guessing something will be dependent on the Matched Stake column. (Of course I could be wrong about that too)

Any help is gratefully accepted

[Captain Sensible]

There's a trigger called CANCEL-ALL-MARKET that will do as it say cancel all bets within the market.

You could monitor the matched stake column W and fire the trigger either when that's greater than 0, i.e. part of the bet matched , and then send the CANCEL-ALL-MARKET trigger. If you wanted to only cancel when the bet was fully matched you'd just add another criteria of your stake equalling your matched stake i.e. AND(W5>0,W5=S5,.....etc (assuming S is a fixed value and not formula)

You'd just simply nest your current IF statement within that one


=IF(W5>0,"CANCEL-ALL-MARKET",IF(AND(Time<=begin_after,$E$11<>"Suspended"),"LAY-IP",...................)

[Ian1506]

Thanks for the really quick reply Captain. I'll give it a shot. Cheers Ian