Excel column T BetLimitExceeded entry

[MiniBlueDragon]

Hi all. Just experimenting with a little in running idea and I frequently get an entry of "BetLimitExceeded" in the relevant row of column T in Excel.

Bet is being added at odds of 1.01 with a 50p stake and the bank is plenty big enough so I'm not sure what it is?

I've tried searching the forum for "BetLimitExceeded" but it returns 0 results.

[Captain Sensible]

Are you betting on the Betdaq or Betfair site?

Betdaq handle their API slightly differently to Betfair and bet limits rather than transaction fees to control how many bets a user can submit, if you exceed it they reject them and freeze you for a while. Mainly their to stop people hammering and overloading the system. You can ask Betdaq to raise your limits if it's too small and depending on your turnover and comms paid they will or won't.

If it's the Betfair BA just ignore the above and I'm sure Gary will say what that message pops up for

[MiniBlueDragon]

It's BetDaq but I can't see how the limit is being exceeded as all the sheet does is monitor in-play markets for a specific set of conditions and then place one single 50p bet into the market at odds of 1.01.

The only thing I can think is perhaps 1.01 isn't possible in play for some strange reason and only available pre-race?

[MiniBlueDragon]

Update on this; it's occasionally doing it even pre-race for some reason. The BA for BD software bottom left shows "Error placing bets: BetLimitExceeded" in red as well as the excel column displaying it in the Bet Ref column.

[Captain Sensible]

Don't think it's an API error response probably best to PM Gary as it's most likely the wording is Gary's for some API response.

[MiniBlueDragon]

Still experiencing this on a daily basis. I've PM'd Gary but I assume he's busy and that's perfectly fine as BA for BD is free and it's using up support time for paying BD for BF customers to answer.

I believe it may be to do with Excel trying to fire in a bet exactly when refreshing. *seems* to occur exactly on a refresh. I have my refresh set to 1 second for the minute before the off and then back to 10 second intervals for any time the race is not imminent.

In Q2 I have:

Code: Select all

=IF(AND(HOUR(D2)=0,MINUTE(D2)<1),1,10)

Any other ideas as I missed a 12/1 and a 15/2 winner yesterday where it failed.

[MiniBlueDragon]

*bump*

[MiniBlueDragon]

Devs I know you're busy but any help at all would be greatly appreciated as it's been over 6 months now and still occurring.

[kiint]

Are you on Betdaq and have you enabled API access?

If yes to both, then the limits applied to you are lower and you have to reduce refresh rates and what have you.
I was playing about earlier and I could put a single bet on and then I would get the same message with subsequent bets. Turning Throttling off in preferences allows bets to go in. However, be careful of bets not showing up when they have been placed and I think if your refresh rate is too hig you will get briefly blacklisted which can be problematic as well.

[MiniBlueDragon]

Hi there. Yep I'm on BetDaq. If you mean "Enable triggered betting" when attaching to Excel then yes that's always done.

I have throttling enabled but set to 240 Place/Update/Cancel Orders per minute and 240 Total requests including orders per minute.

Max Price Refreshes per second is set to 2 so that might confuse the software if Excel is saying it needs 4 per second. I'll try increasing that and see if it helps tomorrow.

I'd completely understand if I was placing multiple bets, scalping or trading but all I do is place one single bet at the odds I want 20 seconds before the race goes in play so there aren't any subsequent bets to be capped as in your example.

[kiint]

By API I mean have you requested Betdaq to allow you to use the API and so be able to create your own apps that don't use BA?
If you haven't then you shouldn't have a lot of problems with the limits. Try disabling throttling & if your requests & bet placements aren't excessive, then you should be okay.
Note that Betdaq don't charge you if you exceed the limits, they just restrict you for a bit.
However, to reiterate what I said before, be careful as bets, although placed & matched, don't seems always show up in the Bet Manager. Something that Gary should look into perhaps?

[MiniBlueDragon]

Ah nope; never spoken to BD at all about the API as I didn't even know I could/should.

Today I'll increase the software Max Refreshes to 5 to make sure the Excel refresh of 4 per second isn't exceeded and see how that goes but at least I've got a next step in turning off the throttling if need be.

Thanks for the help; glad someone had some idea on what to do.