rolf Posted August 3, 2008 Share Posted August 3, 2008 I've been playing around with some data from football-data and finally getting to grips with it, using a bit of VBA in Excel and plotting some different scenarios of strike rate and yield depending on factors that I tweak. Anyway, while simulating different scenarios, I just worked out that according to my model, if you always bet on the favourite premiership team to win (last season) then at the end of the year, you had a yield of about 2%. This happened if I used the average odds, or even just other bookies' odds on their own such as VC, Bet365 or Ladbrokes. Haven't checked the others yet. Now, can this really be true? I've double checked my model twice but I don't see any errors of my ways, yet. Just wanted to check if this sounds right. btw this is an aggregate result for the entire season with an equal stake each time I bet for the favourite team to win. Now of course, if you are ultra conservative and bet only on the dead cert favourites e.g. Chelsea vs Derby, then your strike rate goes up but your yield dives. But I was still amazed to see that you are still a winner (this 2% yield) even if you bet on every match where there is a clear favourite, even if only by a narrow margin. The strike rate comes out to around 58% for last season. What do you reckon, is this normal? I know that 2% is less than inflation but hey it's still up! Quote Link to comment Share on other sites More sharing options...
rolf Posted August 3, 2008 Author Share Posted August 3, 2008 Re: My Football Model - Have I Made A Mistake? OK, I think my model is probably OK. I decided to retest my "simulator" for a completely different league. I took Serie A from last season and if you always bet on the favourite then you will yield about -3%. Of course, I am going to tweak various variables but you could even make such a basic system like "always bet on the favourite" just by testing different leagues alone. Now I need to compare year on year data and find the leagues that are the most promising in terms of least volatility.... Quote Link to comment Share on other sites More sharing options...
slapdash Posted August 3, 2008 Share Posted August 3, 2008 Re: My Football Model - Have I Made A Mistake? Was this just over one season? If so, you may well find that you get rather different results for other years. A Premiership season has only 380 matches. If the favourite in each match is typically at odds of 2.00, then the standard deviation of the yield from backing favourites over a season is around 5%. So I wouldn't read too much into a yield for one season of +2%: even if the expected yield were -8%, then you'd expect to achieve +2% or better something like one season in 20. Quote Link to comment Share on other sites More sharing options...
rolf Posted August 3, 2008 Author Share Posted August 3, 2008 Re: My Football Model - Have I Made A Mistake? Nice one slapdash, that helps a lot. The very interesting thing is that for each market, I'm finding that by changing a key variable, I can get a curve that shows how the yield decreases with increasing strike rate. But some markets almost always show a profit and there are varying amounts of volatility. What I need to find now is a market that has consistently been undervalued and shows a high yield, even at low strike rates. I think I can modify this for tennis too :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.