Cancelling a bet In Play

[excelhasey]

If you have a BACK or LAY trigger in EXCEL but its criteria has not been met before certain conditions have been met how do you get EXCEL to automatically cancel this bet ??

[GaryRussell]

When you say "critera has not been met" are you saying the bet hasn't actually been placed yet or are you talking about an unmatched bet. If it's an unmatched bet then you can use the CANCEL trigger.

[excelhasey]

The bets are being placed but remain unmatched, for example I wanted to LAY all under 10.0, so what happened it was at something like 7.2 when I placed it and it remained unmatched until it steamed in and someone got a great bargain, which was not what I intended !!!!!

So really I wanted to LAY it within EXCEL and if it isn't taken after say 20 secs ($T$1) then CANCEL, so I wrote this but it didn't trigger in my last race :-

=IF(AND(R5>0,S5>0,A5<>"",$S$1<=0,$T$1<=20,F5<=$AS$2,$F$2<>"Suspended",$E$2="In Play",$F$2<>"Closed"),"LAY",IF(AND(R5>0,S5>0,A5<>"",$S$1<=0,$T$1>=30,F5<=$AS$2,$F$2<>"Suspended",$E$2="In Play",$F$2<>"Closed"),"CANCEL","")

Point 2 - Also earlier today I was trying a LAY when $T$1 (time in play) was between -1 and 11 but in laid before we got In Play, gutted cos I lost then too - Any ideas ?? - Even if $T$1 is blank due to the selections being auto re-freshed 1 min before the off and the race not yet being In Play then the trigger should not have been activated should it ??

[GaryRussell]

So really I wanted to LAY it within EXCEL and if it isn't taken after say 20 secs ($T$1) then CANCEL, so I wrote this but it didn't trigger in my last race :-

You can use fill or kill: "LAY-F20" will cancel the bet if not matched after 20 seconds. You don't need to use the "CANCEL" trigger then.

I'm afraid I have no idea how it could have placed a bet before it went in play because part of your criteria is $E$2="In Play". I am certain that $E$2 cannot show "In Play" unless Betfair's API indicates that it is in play. The only way it could happen is if it was turned in play for a moment by mistake.

[excelhasey]

Cheers Gary,

Will the unmatched bet get cancelled after 20 secs, if so, is my trigger simply :-

=IF(AND(R5>0,S5>0,A5<>"",F5<=$AS$2,$F$2<>"Suspended",$E$2="In Play",$F$2<>"Closed"),"LAY-F20","")

Then would the Bet Ref and Bet Time would also then be removed ??

I am worried that it will then trigger another LAY bet, as all boxes will be unfilled, how do I ensure that doesn't happen ??

[GaryRussell]

Cheers Gary,

Will the unmatched bet get cancelled after 20 secs, if so, is my trigger simply :-

=IF(AND(R5>0,S5>0,A5<>"",F5<=$AS$2,$F$2<>"Suspended",$E$2="In Play",$F$2<>"Closed"),"LAY-F20","")

Then would the Bet Ref and Bet Time would also then be removed ??

I am worried that it will then trigger another LAY bet, as all boxes will be unfilled, how do I ensure that doesn't happen ??

Yes it will cancel the bet if unmatched after 20 seconds. When the bet is cancelled the bet ref column will contain "CANCELLED". It will not continue to place more bets.

[excelhasey]

Yes tried it that works as you say

Now last pester for today :-

One of my original criteria was that the LAY bet did not involve the FAV (or RANK 1), so this row remains empty, when bets originally placed, but In Play if this drifts out to 2nd Fav my current set up would LAY it and then it could return to Fav In Play and steam in but I have already laid it, I think this is what might have happened earlier today, so how would you suggest I can protect myself from this ??

[GaryRussell]

Is the criteria the same for every runner so that the criteria is met on the same refresh? If it is then you could use COUNTA to count the none blank cells in column T. eg. put "=COUNTA(T5:T50)" in cell U1. You can then use cell U1 in your criteria, ie. only trigger bets if cell U1=0