Historical Betfair BSPs

A place to discuss anything.
User avatar
gutuami
Posts: 1858
Joined: Wed Apr 15, 2009 4:06 pm

freddy wrote:Anyone know what the average wining odds are for uk horse racing ?

that should help
~3.80 is the average of uk races
~3.90 average for IRE
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

I used a firefox addin that allows you to download multiple files at once from a web page then used python to join them together.

Here are the results from laying, as you can see its commission that kills this strategy. If you could trade/bet without paying commission you would be printing money.
You do not have the required permissions to view the files attached to this post.
freddy
Posts: 1132
Joined: Sun Aug 01, 2010 8:22 pm

gutuami wrote:
freddy wrote:Anyone know what the average wining odds are for uk horse racing ?

that should help
~3.80 is the average of uk races
~3.90 average for IRE
Thanks, I thought it was around that.
the 1st spreadsheet had way higher than average winners, the second was about right, but it's a none point now anyway as Jeff got his sums wrong :) .

By the way Jeff, I once spent days and days going through some Football data and thought i found a great system, only to find out a stupid mistake in my calculations, it easily done :oops:
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

It sure is! :lol: :D

The other challenging thing is that you might think you've found a great system, when in fact you may have hit upon something caused by randomness or a temporary feature of the markets.

Take the graph that Linus posted: viewtopic.php?f=2&t=9801&start=10#p81555.

You might have examined lots of data between about 84,000 and 94,000 or 180,000 and 188,000, and thought you'd come up with a cracking laying system, only to have your dreams destroyed once mean reversion kicked in.

Jeff
freddy wrote: By the way Jeff, I once spent days and days going through some Football data and thought i found a great system, only to find out a stupid mistake in my calculations, it easily done :oops:
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

Just realised my calcs are slightly wrong, need to calculate the profit for each race before applying the commission. Can be done using a sumif I believe.
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

That makes me feel a bit better about my own miscalculation! :lol: :D

Jeff
LinusP wrote:Just realised my calcs are slightly wrong, need to calculate the profit for each race before applying the commission. Can be done using a sumif I believe.
Post Reply

Return to “General discussion”