FLAG

[BERTRAND]

I am Backing one horse before the "off" with an auto level offset in play.
I have a 5 sec trigger window for the "back". My selection is determined by "rank" and this can change within the 5sec window. What sort of flag can I use to prevent more than one backing bet being placed? I can't use my normal flag because this would prevent the offset bet triggering(I think). I have enabled the display of "Offset Bet" and "Offset Bet Reference" on my sheet.

Bert

[MarkRussell]

Hi,

You could set a count of the Bet Reference column, so as soon as a bet is accepted i.e. there is a bet reference, then you can use the count as part of your trigger criteria, i.e. if equal to 1 then don't bet.
So for example in cell T3 you could use =COUNTA(T5:T54)

Regards,
Mark

[BERTRAND]

Thanks Mark
For years it has never crossed my mind to use the COUNTA function!
I'm wondering if the Betfair servers can cope with the 9 meetings today
Bert