MyBets sheet not updating

[olisav]

Hi Gary,

At the moment I am putting all the horse races in one tab of Betting Assistant and I trade on them through out the day. The actual refresh rate is about once every 5-10 minutes as my throttling is quite low. The issue I am having is that MyBets is not always updated so I will have a bet that is fully matched but it will not be showing in MyBets even though the market has refreshed. Other times the market is closed and the bets have been settled but we still have the old bets in MyBets and these can randomly go up to an hour after the market has finished.

Any ideas why this is happening.

Thanks,

[olisav]

Hi Gary,

Have you had a chance to look at this?

Thanks,

[GaryRussell]

I am investigating this now. I will get back to you as soon as possible.

[GaryRussell]

Do you close any of the markets while still linked to Excel?

[GaryRussell]

Also what version of Betting Assistant are you using? I am investigating this in the Beta version, but haven't found any problems yet.

[olisav]

Hi Gary,

Thanks for looking into this. We do not close any races. Our version is 1.1.0.66X84.

It got particularly bad when we set the refresh rate to a longer rate when the race has finished. So for example if the 14.00 race had finished we set the refresh rate to 600 so our other races would refresh quicker. Now we have changed the refresh rate to 1 second for every race even if it is over and MyBets seems to be refreshing better. Does MyBets get refreshed everytime the one market refreshes or do they all have to refresh, or is it just on one race?

Thanks again,

[Captain Sensible]

Each sheet keeps track of the bets for the market it's logging, it won't update other markets so if you have a refresh set for 600 seconds it won't update that sheet and set of MyBets until the next refresh 600 seconds later.

You could always use the Market Closed indicator to shut down or increase the refresh rate on those markets especially as betfair are pretty quick at settling these days

[olisav]

Thanks for that. The issue only happens when we have all the horse races on one sheet. It seemed to get worse when we had closed races on refresh of 600 seconds, even though the races we had bets on were refreshing every few seconds it would take a long time for MyBets to be updated.