Excel Trigger Multiple Bets for same selection

[gilbertrd3079]

Hi,

I'm hoping someone can help me with a question regarding Excel trigger bets. I am running a VBA script to determine the selections I wish to bet and I'm finding that when I try to bet on the same selection multiple times only 1 bet is being recorded in BetFair. For instance, when my code runs and places a bet on Favourite then Second Fav then Favourite again, only 1 bet against the favourite and 1 bet on the second favourite (the second bet on the favourite is not recorded).

Does anyone have ideas for how to fix this issue? I've tried to clear the bet reference after the first bet and also the application.wait function but they have not been successful.

Thanks

[Captain Sensible]

Are you using VBA to place the bets too? Why not simply send blank values for T to W along with the trigger, stake and odds see if that helps.

If you're using VBA to detect when to bet you'll have so much more control also placing bets with VBA, I've had problems in the past with BA repopulataing the bet reference column when I've cleared the references.

[Captain Sensible]

Another thing to note for you bots is that BA updates the columns T onwards in a second set to the sheet after the price data A:P has been written. My coding now runs only when the second set of data has been wiritten not the first 13 columns.

[gilbertrd3079]

Thanks for the tip. I'm using Vba to place bets so it's a bit strange why it's not placing them. I was wondering if it doesn't like multiple bets on same selection in a very short period of time. When I bet on multiple selections it works fine. My bot basically follows a sequence as follows

1. If criteria x is met then back Favourite
Next step
2. If criteria y is met then back 2nd
Next step
3. If criteria z is met then back favourite

For some reason only 1 bet is actually placed against the favourite.

Does it 'batch' bets up before sending to Betfair?

[Captain Sensible]

I've never noticed a problem with bets being placed in separate refreshes. But it does seem to batch bets up when i place a few at a time, not sure if that's a throwback to when you needed to 'trick' the system with under £2 bets but many times if I lay the field close to the off I'll get caught out with half not taken so it must be splitting them for some reason.

Not sure how your code is written but like I mentioned BA sends two sets of data on each refresh, so unless you set your code to only run on one of those sets of data any worksheet change events will run twice per refresh. Maybe that's happening to you especially if it's the second set of bets being placed as they may be overwriting the first lot on the sheet.

Try adding

Code: Select all

Debug.Print Target.Address

after your Worksheet_Change and it'll show the data sets being sent to the sheet in your immediate window.

I usually include the following high in my code so it only runs once per refresh, you may need to change the 6 dependant on however many additional columns you send to excel.

Code: Select all

 If Target.Columns.count <> 6 Then Exit Sub

[Captain Sensible]

1. If criteria x is met then back Favourite
Next step
2. If criteria y is met then back 2nd
Next step
3. If criteria z is met then back favourite

For some reason only 1 bet is actually placed against the favourite.

Is the bet the criteria z bet ? BA can only place one bet per selection per refresh.