Excel refreshes

[Frinck]

I've been having a long-running issue with the refreshes in Excel and I'm hoping to understand what's happnening. Here's the problem...

The standard way that I use to tell if a refresh has been made is to use the following code in a Worksheet_Change:

If Target.Columns.Count = 16 Then
... carry on with processing
Else
... refresh not complete
End If

The problem I get is that even if the first refresh for a race appears to have completed ok, the runner details are not always up-to-date, ie. horse names are from a different race and/or prices are 0 or far too low. I can (and do) check for prices being non-0 pre race (not in-play) but can't verify horse names and odds when they're obviously wrong.

Note that this seems to happen on every first refresh for a given race, and intermittently on subsequent refreshes.

The end result is that my routines will only get processed when the target column count is 16, the back odds 1 for the top horse (f5) is not 0 and the refresh count for each specific race is greater than 1. It's a bit messy and not as straightforward as I was hoping it would be.

Does anyone else suffer from this problem? Maybe people aren't noticing it due to the way their workbooks work - to the naked eye, its undetectable.

I'd really like to understand why this is happening and if there's anything I can do to make my code cleaner and more reliable.

Any help would be much appreciated.
Cheers,
Frinck.

[jokerjoe]

Having similar issues too. Been running a script to log prices and notice that some prices get wiped on changing race. Also trying to pull data from another workbook upon market change but it appears to be grabbing data for horses from the last race too.

Would also appreciate an explanation of how BA refreshes Excel.

Thanks.

[GaryRussell]

I am currently investigating this.

[GaryRussell]

I think I have found the source of this problem. Excel is updated on a background thread. When switching markets the program was not waiting for the thread to finish so it was possible that the background thread could update Excel with data from the previous market after BA had switched markets. I will release a fix for this tomorrow.

[jokerjoe]

Thanks, looking forward to seeing it's effect.

[GaryRussell]

It's fixed in version 1.1.0.5. Also there's a bonus feature, you can now log your current bets to a worksheet, just provide a worksheet named 'MyBets'

[mike]

That's a great bonus Gary! Thank's a lot!

regards,
Mike

[jokerjoe]

Gary, only just tested the changes as was using a workaround, sheets working as expected now, many thanks! And mybets feature proving to be really useful too.