HAS MY TRIGGER JUST RUN AMOK ?

[xraymitch]

Hi Gary,

Can you throw any light on yesterdays mysterious events ?

30th August returned home after leaving Excel triggers running all day across the 5 scheduled UK race meetings to find this devastation in one race at Woverhampton. £150 loss in a race where my maximum liability is £20.

The trigger executed perfectly in the other 30 or so races thus I am at a loss to understand what has happened.

Each race is loaded into it's own worksheet 15 minutes before the start and Wolverhampton was in sheet 5 which you can see from the images only had that one error - no errors before or after that race.









Only, 'Change The Subject', 'Kyllachy Spirit' and 'Mahfal' are correctly staked in the 19:55 race.



The only error text in the diagnostic log is the following:

19:40:01:047: Market id:103620439 selected, error:
19:40:01:344: Error loading silks for market:Wolv 30th Aug - 19:55 1m1f Mdn Stks, runner:Mahfal: System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Betting_Assistant.RefreshSilks.getFile(String url, String market, String runner)
19:40:03:953: updateBets error, ref: 16126076441, result code:BET_TAKEN_OR_LAPSED
19:40:03:953: updateBets error, ref: 16126076442, result code:BET_TAKEN_OR_LAPSED
19:40:04:187: updateBets error, ref: 16126076512, result code:INVALID_PRICE_AND_SIZE
19:40:04:187: updateBets error, ref: 16126076513, result code:INVALID_PRICE_AND_SIZE
19:40:04:344: Excel bet placement error:System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Betting_Assistant.Excel.multiBet(Int32 first, Int32 last)
19:40:16:703: Error loading silks for market:Wolv 30th Aug - 19:55 1m1f Mdn Stks, runner:Mahfal: System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Betting_Assistant.RefreshSilks.getFile(String url, String market, String runner)
19:45:16:703: Error loading silks for market:Wolv 30th Aug - 19:55 1m1f Mdn Stks, runner:Mahfal: System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Betting_Assistant.RefreshSilks.getFile(String url, String market, String runner)
19:50:16:734: Error loading silks for market:Wolv 30th Aug - 19:55 1m1f Mdn Stks, runner:Mahfal: System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Betting_Assistant.RefreshSilks.getFile(String url, String market, String runner)
19:55:16:719: Error loading silks for market:Wolv 30th Aug - 19:55 1m1f Mdn Stks, runner:Mahfal: System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Betting_Assistant.RefreshSilks.getFile(String url, String market, String runner)
20:10:01:141: Market id:103620441 selected, error:
20:40:01:141: Market id:103620443 selected, error:

Should I contact Betfair at this stage or wait until you have had a chance to comment ?

Give me your thoughts when you have a moment.

Cheers,

Ray

[xraymitch]

Sorry Gary,

I messed up on the links.

These are now clickable.

Ray



http://imageshack.us/photo/my-images/83 ... ugust.jpg/

http://imageshack.us/photo/my-images/37/wolv1925.jpg/

http://imageshack.us/photo/my-images/10/wolv1955.jpg/

Only, 'Change The Subject', 'Kyllachy Spirit' and 'Mahfal' are correctly staked in the 19:55 race.

http://imageshack.us/photo/my-images/24/wolv2025.jpg/

[GaryRussell]

I'm afraid I cannot tell what went wrong from that information. Also I'm not sure how Betfair are going to help. If you triggered the bets using Excel and Betting Assistant then it could be a problem with the logic in your spreadsheet.

How is the maximum liability enforced? Is your spreadsheet calculating a total stake of £20?

Do you normally place 1 bet on each selection and on the incorrectly staked selections are there multiple bets?

[GaryRussell]

You got 4 bets matched at 1000 which before the start of the race is unusual. There may have been a withdrawal at the time your bets were triggered and the market was reforming. Do your trigger formulas make assumptions? ie. you seem to stake more when the odds are lower. Could the £106.15 stake for example have been calculated from very low odds? Do your formulas have any logic to protect from this?

[Captain Sensible]

Only, 'Change The Subject', 'Kyllachy Spirit' and 'Mahfal' are correctly staked in the 19:55 race.

http://imageshack.us/photo/my-images/24/wolv2025.jpg/

Can't see how Gary's gonna be able to see what went wrong from the limited info you've given him.

You need to be looking at the runners where it's overstaked, look at the betting history files rather than the pnl one as that'll give you bet times and amounts staked.

Is bot set to stop at a limit of £20 does it fire that in one step etc. Once you've the times and amounts it's been betting it should be easier for you to track down any errors especially if your code clears bet refs etc to allow more than one bet per selection

[GaryRussell]

After thinking more about this to get 4 bets matched at 1000 it's more likely that the race was in play. Are your bets supposed to be triggered in play? Have you checked the times the bets were placed from betting history on Betfair's website?

[xraymitch]

Thanks Gary and Captain for your comments.

Basically I am putting on bets 15 minutes before the scheduled off and the stakes are calculated on £20/Odds, thus at a 1000 odds I would only be putting on 0.20 pence.

All staking is completed before InPlay and a selection should be only staked upon once. Yet several bets have been made and I am still trying to see where my logic has failed that could permit such a scenario.

Appreciate your thoughts though.

Cheers,

Ray

[xraymitch]

After thinking more about this to get 4 bets matched at 1000 it's more likely that the race was in play. Are your bets supposed to be triggered in play? Have you checked the times the bets were placed from betting history on Betfair's website?

Gary,

If you look at the images you will see the time the bets were placed.

Thanks for spending your precious time on it.

Ray

[GaryRussell]

Sorry, yes the times are there. Something odd must have been going on with the prices for you to get matched at 1000 on Midnight Waltz when your bet was placed at 19:40. It's SP was 12.95.

[GaryRussell]

Just trying to figure out where the odds of 1000 came from. Have you ticked "Fill missing prices" in grid preferences? If you have then that would explain where those odds came from if there were no odds currently being offered by layers. It would display 1000 and show this in Excel. If you also are placing these as keep bets then it would explain why you got matched, because they were matched in play. It doesn't explain the high stakes though.

[Captain Sensible]

You need to be looking at the betting history screen as that gives you a lot more info such as the odds you requested rather than just the odds you matched.

Might help you track down some of the errors, was there a non runner in the market and your bets fired as the market was reforming? Was your code set to fire bets at 19:40 and 19:54??

I've had plenty of mishaps with my botting thru the years but can't remember a case where I haven't been able to track down where things went wrong eventually.

[GaryRussell]

You need to be looking at the betting history screen as that gives you a lot more info such as the odds you requested rather than just the odds you matched.

Might help you track down some of the errors, was there a non runner in the market and your bets fired as the market was reforming? Was your code set to fire bets at 19:40 and 19:54??

I've had plenty of mishaps with my botting thru the years but can't remember a case where I haven't been able to track down where things went wrong eventually.

Unfortunately there's a problem with Betfair's betting history. When the bets are settled the requested odds display the same value as the matched odds regardless of the actual odds requested.

[xraymitch]

Hi Again,

I don't have Fill missing prices ticked, and here is the BetHistory.

Cheers,

Ray 8)

Bet ID Bet placed Persistence Odds req. Stake(GBP) Avg. odds matched Profit/Loss(GBP)
16126365623 30-Aug-11 19:54 C 50 6.00 50 (6.00)
16126365620 30-Aug-11 19:54 C 70 6.71 70 (6.71)
16126365618 30-Aug-11 19:54 C 28 19.64 28 (19.64)
16126365614 30-Aug-11 19:54 C 48 10.21 48 (10.21)
16126365613 30-Aug-11 19:54 C 13 106.15 13 (106.15)
16126076508 30-Aug-11 19:40 C 1,000 0.50 1,000 (0.50)
16126076507 30-Aug-11 19:40 C 1,000 1.38 1,000 (1.38)
16126076442 30-Aug-11 19:40 C 1,000 2.00 1,000 (2.00)
16126076441 30-Aug-11 19:40 C 1,000 2.00 1,000 (2.00)
16126076433 30-Aug-11 19:40 C 10 2.08 10 (2.08)
16126076432 30-Aug-11 19:40 C 7.8 2.66 7.8 18.09
16126076431 30-Aug-11 19:40 C 1.77 11.73 1.77 (11.73)

[GaryRussell]

The Betfair API team are usually quite helpful. If you give them the bet references they can tell you the odds actually requested which could throw some light on how the stakes were calculated. The requested odds in the betting history are not necessarily correct as they always match the matched odds. Email bdp@betfair.com

[xraymitch]

The Betfair API team are usually quite helpful. If you give them the bet references they can tell you the odds actually requested which could throw some light on how the stakes were calculated. The requested odds in the betting history are not necessarily correct as they always match the matched odds. Email bdp@betfair.com

Thanks Gary, I will give that a try this evening.

Ray