I have been wanting to do this for a while and is a work in progress but I don't think I will get all the years done, however this dashboard shows 11,12,13 and 14.
Feel free to take and use the underlying data, a few nice trends become apparent (cricket volume increase, football decrease in pe volume..) The volume/number of bets has been summed per day per sport id so no details on the event.
Large: https://public.tableausoftware.com/view ... y_count=no
Small: https://public.tableausoftware.com/view ... y_count=no
All data is taken from 'http://data.betfair.com/' and is unbelievably painful to work with.
Betfair Volume Analysis
Finally worked out how to automate the download/unzip/aggregate the data from http://data.betfair.com/#null. I have yet to fully reconcile and add a few missing but looking at the difference in volume matched per year isn't looking good especially football. Decreasing at almost the same rate it was growing a few years ago!
You do not have the required permissions to view the files attached to this post.
That's good, I'm still sanitising it manually!
Do you have some absolute numbers for that graph?
I imagined 2014 benefited from the World Cup so that would account for the bump up. But the 2015 drop seems far deeper than I imagined.
Do you have some absolute numbers for that graph?
I imagined 2014 benefited from the World Cup so that would account for the bump up. But the 2015 drop seems far deeper than I imagined.
Here is a straight dump from my db as it stands:
https://www.dropbox.com/s/zfj8dy3lsq6ik ... R.csv?dl=0
https://www.dropbox.com/s/zfj8dy3lsq6ik ... R.csv?dl=0
https://www.dropbox.com/s/g3ya6cnj0rqxn ... A.csv?dl=0
No guarantees on this as there is certainly data missing in 2005/2006, looks like there is some missing in August 2014 as well. Cricket was looking good up until this year, there is almost more money traded on it than Tennis, Peter is that where you hide
Football is the worst performer this year with a small drop of 2.2billion, how does 2.2billion disappear?
I noticed on the betfair forum that someone posted a link to the dashboard I posted in the middle of 2014 claiming that volume had dramatically decreased in 2014. Please note that the dashboard only contained data up till the middle of 2014, hence the drop from 2013.
No guarantees on this as there is certainly data missing in 2005/2006, looks like there is some missing in August 2014 as well. Cricket was looking good up until this year, there is almost more money traded on it than Tennis, Peter is that where you hide
Football is the worst performer this year with a small drop of 2.2billion, how does 2.2billion disappear?I noticed on the betfair forum that someone posted a link to the dashboard I posted in the middle of 2014 claiming that volume had dramatically decreased in 2014. Please note that the dashboard only contained data up till the middle of 2014, hence the drop from 2013.
Thanks, I saw that post but Betfair banned me from their forum so I couldn't point out his error. Nobody else seemed to spot it!LinusP wrote:I noticed on the betfair forum that someone posted a link to the dashboard I posted in the middle of 2014 claiming that volume had dramatically decreased in 2014. Please note that the dashboard only contained data up till the middle of 2014, hence the drop from 2013.
Haven't looked at the data just yet, but Cricket probably would have suffered because of the crack down on illegal gambling in India. However that appears to be run from Dubai now according to posts on the forum.LinusP wrote:Cricket was looking good up until this year, there is almost more money traded on it than Tennis, Peter is that where you hide
On Footy Betfair have stopped rushing bets onto the exchange so I reckon that's the cause of a big drop. I noticed they have been setting up the markets so they are similar to Bet365 at 103% of book. I guess that's diverted money as well as people think 5% commission is a 105% book, but it's not.
I'll have a nose around the data over the next week.