Tuesday, 4 August 2009

PlopPlop System Rating History 2000/01 to 2008/09

PlopPlop System Ratings are created from a database of over 20,000 English Football matches. 9 full seasons of the Premiership down to Coca Cola League 2 and 4 seasons of the Blue Square Conference Premier. Utilising many of the variables described in the Data section a rating is generated for each of the teams involved in upcoming fixtures. It is the difference between these two ratings that we are interested in, a positive differential suggests a Home Win, a negative differential, an Away Win.
Obviously we cannot divulge exactly how the ratings are calculated but what we can reveal is that they are based on complex statistical modelling, complimented by elements of modelling score distributions given by the Poisson distribution.

PlopPlop System Rating requires that each team in an upcoming fixture has played 6 matches. This stipulation gives the complex statistical models enough data with which to make a judgement about each teams ability. Removing fixtures where either team has played less than 6 games reduces the data from 20,442 matches to 17,602.

For ease of comparison the rating is banded into 10 groups; each containing 10% of the matches in the database. Below are the minimum and maximum PlopPlop rating within these bands.

PlopPlop System
Rating (1-10)MinimumMaximum# Bets
18.0034.001,760
25.008.001,760
33.005.001,760
41.173.001,760
5-0.671.171,761
6-2.33-0.671,760
7-4.17-2.331,760
8-6.33-4.171,760
9-9.33-6.331,760
10-28.83-9.331,761

The most important thing is to understand whether segregating the matches via the PlopPlop System Rating drives a profit or not. As mentioned in other areas, if profit exists we would expect it to be observed at the extreme of these ratings. Namely a rating of 1 and a rating of 10.

NB: All of the following financial information is settled to a £1 level stake bet. For example, if there are 100 bets, this equates to a stake of £100. Where a positive rating exists (0 and above) returns are settled to a £1 home win. A negative rating is settled to a £1 away win. Returns are settled at the average odds available for the match. This ensures the results are realistic and achieveable.

PlopPlop System
Rating (1-10)# BetsStrike RateReturnsYield (%)Avg Odds
11,76064.8%£76.494.3%1.64
21,76053.1%-£98.14-5.6%1.82
31,76049.8%-£132.17-7.5%1.91
41,76049.2%-£90.65-5.2%1.98
51,76145.8%-£163.72-9.3%2.51
61,76030.4%-£75.38-4.3%3.35
71,76032.2%-£87.20-5.0%3.15
81,76032.7%-£135.02-7.7%2.98
91,76035.0%-£132.82-7.5%2.79
101,76147.4%£168.879.6%2.43
Grand Total17,60244.0%-£669.73-3.8%2.46

In line with expectation we observe profit at the extremes of the ratings, a yield of 4.3% where we anticipate a home win and 9.6% for an away win.

In order to home in on the matches where we observe profit, only a rating of 1 and 10 are retained.

PlopPlop System
Rating (1-10)#BetsStrike RateReturnsYield (%)Avg Odds
11,76064.8%£76.494.3%1.64
101,76147.4%£168.879.6%2.43
GrandTotal3,52156.1%£245.367.0%2.03

Making this change reduces the total number of matches to just over 3,500 and has us realising a yield of 7.0% overall at average bet odds of just above evens (2.00). The next step to improve the situation is to look at performance within certain odds ranges, first up is home win bets, rating = 1:

PlopPlop System
Rating (1-10)Odds Band# BetsStrike RateReturnsYield (%)Avg Odds
10.00 - 1.25 9783.5%-£0.18-0.2%1.19
1.25 - 1.50 49973.1%£4.730.9%1.38
1.50 - 1.75 61660.4%-£18.57-3.0%1.61
1.75 - 2.00 31963.3%£52.5616.5%1.85
2.00 - 2.25 15950.3%£10.546.6%2.12
2.25 - 2.50 5655.4%£16.3929.3%2.34
2.50 - 2.75 560.0%£2.8356.7%2.62
2.75 - 3.00 862.5%£6.1877.2%2.82
3.00 - 3.50 1100.0%£2.01201.4%3.01
Grand Total1,76064.8%£76.494.3%1.64

It is a well known problem within football betting that betting at short odds, whilst providing regular winners, is incredibly hard to drive a significant profit from in the long term. The sensible step here is to remove matches where, at average odds, we cannot obtain odds for a home win better than or equal to 1.75.

PlopPlop System
Rating (1-10)Odds Band# BetsStrike RateReturnsYield (%)Avg Odds
11.75 - 2.00 31963.3%£52.5616.5%1.85
2.00 - 2.25 15950.3%£10.546.6%2.12
2.25 - 2.50 5655.4%£16.3929.3%2.34
2.50 - 2.75 560.0%2.8356.7%2.62
2.75 - 3.00 862.5%£6.1877.2%2.82
3.00 - 3.50 1100.0%£2.01201.4%3.01
Grand Total54858.8%£90.5216.5%2.00

We have removed two thirds of non-profiting bets for this rating. As these were largely loss making bets we can see that overall, across 548 bets, we have a yield of 16.5% at average odds of evens (2.00).

Now we move on to away win bets; rating = 10:

PlopPlop System
Rating (1-10)Odds Band# BetsStrike RateReturnsYield (%)Avg Odds
100.00 - 1.25 2100.0%£0.3718.3%1.18
1.25 - 1.50 7178.9%£7.6510.8%1.40
1.50 - 1.75 15169.5%£19.0612.6%1.62
1.75 - 2.00 18647.8%-£21.22-11.4%1.86
2.00 - 2.25 29947.5%£4.021.3%2.14
2.25 - 2.50 35744.3%£16.214.5%2.37
2.50 - 2.75 30347.2%£72.2623.8%2.62
2.75 - 3.00 15832.3%-£12.36-7.8%2.84
3.00 - 3.50 13041.5%£44.3334.1%3.23
3.50 - 4.00 5834.5%£17.2229.7%3.72
4.00 - 5.00 3928.2%£9.2123.6%4.43
5.00 - 6.00 540.0%£5.78115.6%5.35
6.00 - 7.00 10.0%-£1.00-100.0%6.36
8.00 - 9.00 1100.0%£7.33733.3%8.33
Grand Total1,76147.4%£168.879.6%2.43

Again we must adhere to the old adage that profits are hard to achieve at short odds. Despite some impressive yield figures in the very short odds ranges, by reducing the number of matches in a similar fashion to the home wins, more profit per £1 staked can be realised. Going one step further than home wins; lets look at the effect of removing all games with odds of less than evens (2.00).

PlopPlop System
Rating (1-10)Odds Band# BetsStrike RateReturnsYield (%)Avg Odds
102.00 - 2.25 29947.5%£4.021.3%2.14
2.25 - 2.50 35744.3%£16.214.5%2.37
2.50 - 2.75 30347.2%£72.2623.8%2.62
2.75 - 3.00 15832.3%-£12.36-7.8%2.84
3.00 - 3.50 13041.5%£44.3334.1%3.23
3.50 - 4.00 5834.5%£17.2229.7%3.72
4.00 - 5.00 3928.2%£9.2123.6%4.43
5.00 - 6.00 540.0%£5.78115.6%5.35
6.00 - 7.00 10.0%-£1.00-100.0%6.36
8.00 - 9.00 1100.0%£7.33733.3%8.33
Grand Total1,35143.1%£163.0112.1%2.65

Unlike with home wins, this has not reduced the number of matches in the sample by much, 23% in this case. We do however see an increase in yield to 12.1% at average odds of 2.65. The Odds Band '2.00 - 2.25' drives very little profit for some considerable effort, an additional 299 bets. The decision therefore is to remove this marginal group and concentrate our efforts where we clearly have an advantage over the bookmaker. It would be improper to ignore the '2.75 - 3.00'. There is however no sense to removing this group. Why would a bet with a rating of 10 be a bad bet just because the odds are longer? Longer odds bets with a rating of 10 return handsome profits. The feeling here is that this is a slight statistical anomaly that over seasons to come will iron out and we will observe a trend similar to the home win bets where profits increase in line with the odds. Betting at longer odds levels the playing field somewhat where bookmakers over-round is concerned.

The final away win table; rating of 10 and odds >= 2.25:

PlopPlop System
Rating (1-10)Odds Band# BetsStrike RateReturnsYield (%)Avg Odds
102.25 - 2.50 35744.3%£16.214.5%2.37
2.50 - 2.75 30347.2%£72.2623.8%2.62
2.75 - 3.00 15832.3%-£12.36-7.8%2.84
3.00 - 3.50 13041.5%£44.3334.1%3.23
3.50 - 4.00 5834.5%£17.2229.7%3.72
4.00 - 5.00 3928.2%£9.2123.6%4.43
5.00 - 6.00 540.0%£5.78115.6%5.35
6.00 - 7.00 10.0%-£1.00-100.0%6.36
8.00 - 9.00 1100.0%£7.33733.3%8.33
Grand Total1,05241.8%£158.9915.1%2.65

We settle on a yield of 15.1% across 1,052 bets at average odds of 2.65.

The following tables are a further dump to show the consistency and growing profits over the past 9 seasons as more and more bookmakers move online and competition forces the book closer and closer to 100%. It is also worth noting how when the proportion of home wins and away wins moves around season to season, as we are betting on both sides of the coin, one type of bet compensates for a reduction in profits on the other side.

To reiterate the conditions under which a bet is placed:
Home Win Bet: Rating = 1 (+8.00 or higher) and HW Odds >= 1.75
Away Win Bet: Rating = 10 (-9.33 or lower) and AW Odds >= 2.25

Season By Season:

Season# BetsStrike RateReturnsYield (%)Avg Odds
2000/0115946.5%£23.3614.7%2.48
2001/0213740.9%£1.150.8%2.51
2002/0313643.4%£7.555.6%2.48
2003/0420345.3%£24.4612.0%2.54
2004/0518046.7%£18.9810.5%2.51
2005/0617648.9%£33.1418.8%2.51
2006/0721452.3%£61.1028.6%2.57
2007/0819049.5%£34.2118.0%2.53
2008/0920551.2%£45.5522.2%2.53
Grand Total1,60047.6%£249.5115.6%2.52

Season By Season, split by Rating:

PlopPlop System
Rating (1-10)Season# BetsStrike RateReturnsYield (%)Avg Odds
12000/014257.1%£6.1614.7%2.01

2001/023545.7%-£4.64-13.3%1.92

2002/034047.5%-£3.60-9.0%1.93

2003/047250.0%£0.070.1%2.03

2004/056566.2%£20.7431.9%2.00

2005/066462.5%£13.7521.5%1.97

2006/078956.2%£12.7014.3%2.04

2007/086459.4%£9.9215.5%1.97

2008/097772.7%£35.4346.0%2.04
1 Total
54858.8%£90.5216.5%2.00
102000/0111742.7%£17.2014.7%2.65

2001/0210239.2%£5.795.7%2.71

2002/039641.7%£11.1611.6%2.71

2003/0413142.7%£24.3918.6%2.83

2004/0511535.7%-£1.77-1.5%2.79

2005/0611241.1%£19.3917.3%2.82

2006/0712549.6%£48.4138.7%2.96

2007/0812644.4%£24.2919.3%2.81

2008/0912838.3%£10.127.9%2.83
10 Total
1,05241.8%£158.9915.1%2.79
Grand Total
1,60047.6%£249.5115.6%2.52

No comments:

Post a Comment