Can the race be loaded at the actual start of 'In Play'

[aubweaver]

Thanks Mark,
That made things easier, however I now have another question.
Can I set the race to load onto the excel sheet at the actual off?
ie when it turns to 'IN PLAY'. I'm presently getting bets I don't want where the odds movements are quite dramatic just before the start.
Thanks Peter

[GaryRussell]

I'm afraid not. That would require the race is monitored in advance in the background which BA does not do. Just use cells E2 and F2 in your criteria. For example

Code: Select all

=IF(AND(E2="In Play",F2<>"Suspended"),"BACK","")

The above formula would only trigger a back bet if the market is in play.