Excel Across Multiple Markets

[jrarmstrong]

I am looking to create a spreasheet to place bets in a number of separate and unrelated markets. So far I have been using the Place Bets sheet on single markets and was wondering how best to structure the new sheet.

I know I can link separate workbooks to BA but as I will be interrogating a load of data to find the triggers I would like to use a single sheet if that is possible?

Thanks,

James

[MarkRussell]

Hi,

You can create a custom coupon view of the markets that wish to use in the first tab of Betting Assistant.

Then link the tab with the multiple market view to an Excel spreadsheet. The markets will then all be on a single sheet underneath each other.

If you plan on using the place_bets example spreadsheet in this scenario then you will probably need to modify it as the formulas used only go to row 55 and the triggers in column Q will clash with the special trigger cell Q2 which will be lower down for subsequent markets

Regards,
Mark

[jrarmstrong]

Cheers Mark. I had tried that but did not amend column Q. I'll give it a go.

James

[jrarmstrong]

Mark,

I tested this last night using a couple of markets. All bets were placed but a few returned PENDING in the bet ref column. They were actually placed and a ref was populated in the MyBets sheet. I use the bet ref to look up and trigger other positions so is there something I need to tweak to ensure it is populated?

Thanks,

James

[GaryRussell]

Mark,

I tested this last night using a couple of markets. All bets were placed but a few returned PENDING in the bet ref column. They were actually placed and a ref was populated in the MyBets sheet. I use the bet ref to look up and trigger other positions so is there something I need to tweak to ensure it is populated?

Thanks,

James

They possibly got stuck at pending due to API problems yesterday. See if it happens again today.

[jrarmstrong]

Gary,

I have tried again a few times this week and keep get the PENDING result for some of the bets. Each bets is actually placed but the bet ref is not populated. Any ideas?

Thanks,

James

[GaryRussell]

Gary,

I have tried again a few times this week and keep get the PENDING result for some of the bets. Each bets is actually placed but the bet ref is not populated. Any ideas?

Thanks,

James

Next time it happens check the transaction log under the account menu. Check if the bet ref is there and let me know what is listed under the API response column.

[jrarmstrong]

Gary, I have tried again and the bet reference was populated in the transaction log but the PENDING message was returned on the sheet. Any suggestions?

Thanks,

James

[GaryRussell]

I now need to see the diagnostic log. Next time it happens please send the log file named BA_Diagnostic.txt in "c:\temp\Betting Assistant Logs" folder to admin@gruss-software.co.uk. If it doesn't reveal the problem then I will need to add more info to the log until it does. Sorry, but this is the only way I can find out.

[jrarmstrong]

Gary,

Will do and thanks.

James

[GaryRussell]

I have received your email. I can now see the problem. I think it is the way your VBA code copies the bet ref and is not a BA fault. I have replied to your email.