I have BA triggered via an Excel spreadsheet, linked to Sheet 1, cell A1. Excel pulls selections from a database every minute and puts them in a table in Sheet 2. The event is auto selected from the quick pick list one minute before start time, and any picks in my Sheet 2 table are compared to the runners in the race on Sheet 1 and if they match, a BACKSP bet is triggered.
I checked the Transaction Log, and BA did not attempt to place any bets for that race. So I checked the Excel error log and found the errors below. Note that there were plenty of other errors, one per minute, which aligns with a VB script I run every minute to refresh my Excel database connection. I've always assumed these errors shouldn't be a problem, as anything missed would be picked up on BA/Excel's next refresh the following second.
- Code: Select all
16:38:42 Reading triggers, bet ref, bet time, matched odds, matched stake, P&L and additional columns (range:Q5:Y15) System.Runtime.InteropServices.COMException (0x8001010A):...
16:39:42 Getting selection range* (range:A1:P4) System.Runtime.InteropServices.COMException (0x8001010A):...
16:41:42 Getting selection range* (range:A1:P4) System.Runtime.InteropServices.COMException (0x8001010A):...
16:42:43 Getting selection range* (range:A1:P4) System.Runtime.InteropServices.COMException (0x8001010A):...
16:43:43 Writing ref, bet time, matched odds, matched stake, P&L and additional columns System.Runtime.InteropServices.COMException (0x8001010A):...
16:44:43 Reading refresh rate cell System.Runtime.InteropServices.COMException (0x8001010A):...
As the event of interest started at 16.40 and the following event at 16.45 I assume only the errors between 16.39 and 16.43 are relevant.
What struck me is that BA is only trying to update range A1:P4, i.e. the header rows, as if there were no runners in the race. However that race had 17 runners.
Can you think of anything that would cause BA / Excel to only populate the header rows and not the runners? Could it be related to the errors in the log above? As I say, I have these every minute, and I've never noticed an issue like this before. Or could the error be on BA or Betfair's end?
Any thoughts or information would be much appreciated!
