In running E2 and F2

[alrodopial]

Hi,
Is it possible that while a race is in running BA (through Betfair) will send in E2 the "In play" and in F2 the "Suspended" ?
Secondly when a race is finished is the "closed" in F2 sended always and quickly?
Is this a good way to identify that the race has finished?
Thanks

[Steve Voltage]

=IF(AND(E2="In Play",F2=Suspended"),"True","False") is the formula i use.

[alrodopial]

=IF(AND(E2="In Play",F2=Suspended"),"True","False") is the formula i use.

In which case do you use it?
Do you use it to identify that the race has ended?

[jokerjoe]

Just to be pedantic... the following does the same job

Code: Select all

=AND(E2="In Play",F2="Suspended")

A market may come out of suspension for a photo finish, and markets are generally closed a few minutes after the end of an event.

[alrodopial]

I'm recording odds IR every 0.5 sec and if the race is finished i change the refresh rate at 999 sec.
But few times while the race is IR and not Finished the refresh rate goes to 999 sec and after that the race has finished.
I name the race as finished when E2=In Play and F2=Suspended (among few other conditions) so i suspect that i get from betfair these signals in E2,F2 in running by error.
I'll check it again and come back.