Running Excel unattended and monitoring response times

[greenfingers]

Hi, I'm running Excel unattanded and was wondering if there is a way to code the VBA to flag-up when there are serious issues with Betfair response times or a high %age of failed bet / price requests, as I don't want it to run in these instances.

Perhaps then I could put the spreadsheet into a monitoring mode without triggering bets until stability has returned.

Any ideas?

[GaryRussell]

I'm afraid there isn't. This is something we can consider for a future release.

[silver]

Greenfingers,

Do you calculate average refresh intervals? If not, might that be of some use?

http://www.gruss-software.co.uk/forum/v ... t=avgcount

[greenfingers]

Thanks for the link Silver, I hadn't seen that and it will enable me to stop the 'sheet when the connection / Betfair is sluggish.

Gary, thanks for adding to the suggestions.