In conjunction with our regular match previews published in the German Betfair blog we are pleased to present our league match with head-to-head history ‘Value’ bet detector spreadsheet.
with H2H History
WITH Asian Handicap
(ex VAT; see below)
WITHOUT Asian Handicap
(ex VAT; see below)
0% VAT to UK customers
0% VAT to Non-EU customers
Read more: EU VAT Legislation
e-shop: Product Overview
View Your Shopping Cart
Our bet selections are always based on true odds calculations identifying mathematical ‘value’ in the markets. Of course, not every bet can win, but ‘value’ betting is the only reliable method of ensuring long-term betting profits.
‘VALUE’ bet detector: The Excel spreadsheet calculates the ‘true’ odds (= expected probabilities based on historical statistics) and then displays each ‘value’ bet recommendation. For every event included the expected values are calculated, compared to market prices, and finally the statistical probability of winning the bet is shown.
Soccerwidow follows the philosophy that only through identifying bets containing mathematical ‘value’ in the prices offered by bookmakers or exchanges is it possible to make consistent profits.
It should be noted that the spreadsheet is not a tool for automated betting. The tables provide vital information to improve the accuracy of your own predictions, and the figures do not substitute for reading salient news and applying good judgement.
The Excel spreadsheet offered for sale comes pre-filled with data from the Premier League game Liverpool v. Manchester City on 26/8/2012. Just delete or over-type this to analyse any match of your choosing.
Read a few sample match previews which apply ‘League Games with H2H History’ calculations:
- 26.8.2012 English Premier League: Liverpool v. Manchester City – Statistical Match Analysis & Football Betting Predictions
- 6.8.2012 Norwegian Tippeligaen: Stabæk v. SK Brann – Statistical Match Analysis & Football Betting Predictions
- 5.8.2012 Belgian Jupiler League: Zulte-Waregem v. Gent – Statistical Match Analysis & Football Betting Predictions
Notes: Adjust the picture quality at the bottom of the screen above by clicking on the ⚙ button (to the left of the YouTube logo), then click on ‘Quality’ and choose a higher resolution as desired. Go to full screen mode by clicking on the box symbol (to the right of the YouTube logo).
Supporting Videos
Data Sourcing: Learn where to find historical match data and download it from www.football-data.co.uk to make your own Excel store of statistics.
Data Input: Historical match results and head-to-head data input to populate the Value Bet Detector ready for input of the best odds you can find.
Frequently asked questions:
Can I use the spreadsheet in other leagues?
Yes, the calculations apply for any league in the world. The only parameters are that the game in question must be between two teams which have played at least their last 25 home or away games in the same league. The calculations are based on the home team’s last 25 home games and the away team’s last 25 away games, in the same league. Also, both teams must have played the corresponding fixture at least 6 times in the last 10 years (in other words, the home team has hosted the away team at least 6 times in all competitions (not friendlies) in the last 10 years).
How long does it take to enter historical data into the spreadsheet?
This is a manual procedure and you will quickly find which sources are best for the full-time and half-time results of both teams in the 25 matches to be analysed, plus the head-to-head encounters. We recommend Football-Data, Betexplorer, Oddsportal and Soccerway, although there are a host of other sites specialising in historical statistics.
At the start, you will find data collection will take about 30 minutes per match including entering the best bookmaker odds you can find (try Betfair and Oddschecker).
Are the formulas for the spreadsheet calculations visible?
Yes, we have hidden none of the formulas.
Exactly which historical records do I have to input?
The full-time and half-time scores for both team’s last 25 matches (home games only for the home team, away games only for the away team), plus the same for the head-to-head encounters over the last 10 years.
What knowledge is required?
You should already have a understanding of odds and how they are calculated. The spreadsheet is just a tool to identify potential bet candidates. You will need to understand what is meant by the term ‘value’ and also have a good idea how to spread risk with a well-structured betting portfolio. The spreadsheet is intermediate level, and you should be become entirely familiar with its mechanics before committing money to any bet recommendations suggested by the spreadsheet.
Hey SoccerWidow
I’ve just bought this spreadsheet and i think it’s amazing. I deal with excel myself, but its kinda complicated. There are so many formulas (Actually, i think its fantastic, but I cant understand everything).
Do you think about launch a PDF or something to explain in detail this spreadsheet? I’ve watched the video, but i’m not an English speaker myself. I understand a lot in there, but I miss some valuable points. A PDF or some tutorial will be great.
Thanks again!
Hi Alex, I’m happy to hear that you love the spreadsheet. There is an update on the way which will identify even more accurate picks, and also a manual and tutorial. We will inform all buyers as soon as it’s ready… However, unfortunatelly this project is on ice at the moment as I had a quite serious horse riding accident end of April which completely took me out since; I spend two weeks in intensive care in hospital followed by many weeks with a clowded mind at home. Luckily I’m getting better every day, but it will take time until I’m back to full strength again and able to adjust formulas in spreadsheets, prepare them for sale and write explanatory articles and tutorials.
So sad to hear about your accident… hope you get better soon!
About the spreadsheet, it is amazing. It does all the math needed to find good value bets (not only value bets, but value bets with high chance to occur). Looking foward for the update and tutorials, especially about the Asian Handicap sheet. Man! there is so many information in there! lol
And one last thing: thanks for the fast reply!
Hi Soccerwidow,
Great news!!! Looking forward to the User Manual and an updated version of the Value Detector. I am using the current version and I think its a great tool to analyse upcoming matches.
I wonder what you have got up your sleeve to improve the current version?
Its easy to use and the information you get out of it is absolutely fantastic!!
I usually copy the data across from http://www.football-data.co.uk, I use the SEARCH function in Excel and copy all the data straight into the Value Detector. For the H2H I use http://www.soccerbase.com – just click on Head-to-Head and select the teams – it couldnt be easier!!
Its easy to use and it does exactly what it says – it helps to find VALUE BETS which is what you want if you want long term profits
I hope you will feel better soon and I cant wait to see your next piece of work!
All the best from Australia!!
I’m really looking forward for this update, I’ve been using this tool for some time and it’s very helpful to have a mathematical edge in addition to own knowledge and perceptions for each game. It would be nice if it could calculate value in the for example 0.25, 0.75, 1.25 etc. asian handicap and goal markets, of course it can be done manually but it could speed up the process.
There’s another very reliable web site for raw data picking called http://www.footballzz.co.uk , it covers some leagues like those from latin america not featured in the other sites.
Hope you get well soon and keep the great work!
I could not leave a reply in your article about over/under guide so i try here instead, i hope thats ok. I am in the beginning om my betting season, using what i learned in your over under tutorial and collected data from 12 leagues around europe (many hours spent). After just 30 bets its looking quite good, i know that i need many more to be sure if my idea works. If all is looking good after a couple of months i am wondering, can i take what i learned from your over/under tutorial and collect data from hockey also. It should not matter if it is fotball or hockey ? i come to the conclusion that if it works for fotball it would be great to be able to let the money work because the hockeygames plays in other timelines.
Statistics always work.. for football, for hockey, for horse racing, for everything.
The only thing that is always necessary is of course a sufficent amount of data and the knowledge how to analyse and use it.
Thanks for your comment and good luck with your betting! 🙂
Hi Soccerwidow
First, can I say your website is superb. I’ve been looking for this kind of material for years and it has helped me immensely with my betting, thank you.
I am trying to work out how i can calculate the true odds for games involving teams that have just been promoted/relegated to a new league.
For example I am currently pricing up the English Championship fixtures for this weekend, and i’m experiencing problems with Yeovil who were promoted last season.
You normally advise using the last 25/30 home/away games and head to heads.
However Yeovil’s last 25/30 games were played in a weaker division so these will be misleading.
Also, Yeovil have never played at Championship level before, so there will be almost no head to head history for any of their opposition this season.
I’m having this problem with many of the promoted/relegated teams throughout the english leagues, Yeovil are just an example.
So how would i go about producing accurate ‘true odds’ for these kind of teams?
Thank you for your help
Hello again Jonathan, and thanks for all your praise (blush!), current, and past support of Soccerwidow.
The problem you describe is one that we try to avoid for the sake of comparing apples with apples.
Any fixtures within a team’s last 25 home or away games which have been played in a lower or higher league than their opposition in the game you are analysing automatically discounts that team from our analysis.
In other words, we do not analyse such teams with the Value Bet Calculator, nor do we include any matches where there are not at least six competitive head-to-head games in the last 10 calendar years at the ground in question.
You have to be consistent with statistics and if they are in any way a miss-match then there is no chance you will obtain a ‘true’ reflection of the odds. You will have to leave Yeovil, Bournemouth and Doncaster out of The Championship reckoning for this season and concentrate only on matches between teams which have remained in the division from last season. The same goes for all the other leagues.
Jonathan, we hope this helps, but by all means ask again should you require clarification on any matter.
Best wishes for the new season.
Thank you for your prompt reply.
I completely understand where you are coming from about why these kind of teams are not included in the Value Bet Calculator, and that a prudent betting portfolio would not contain these games due to the statistical deficiencies.
But purely out of a thirst for knowledge i remain intrigued as to how these teams can be priced up as accurately as possible. After all, the bookmakers are able to do this (before adjusting the odds according to how the market will react).
So i think it’s just a case of me experimenting and seeing what i can come up with. Maybe an interesting place for me to start would be the methods used in Soccerwidow’s international qualifiers and international club competitions spreadsheets, as both try and cater for the lack of head to head history.
Many thanks for your help, and i hope the site continues to go from strength to strength.
The international spreadsheets you mention are certainly a good place to begin making value estimations of these teams, but it takes to garner data and enter odds for each of the historical 25 matches, as well as the results. In addition, the international games are all in the international arena, but you cannot make this comparison between the Championship and the EPL for example – different arenas altogether.
Newcomers are unpredictable without having any comparable data. We answered your question in form of an article: Calculating Odds for League Newcomers is Unpredictable
Hi Soccerwidow,
quick question in regards to the True Odds and Value Detector:
For the H2H comparison of both teams, would you include games played on neutral ground, i.e. domestic cup games for example? Or would you only include games played at the home teams home ground?
I came across this a few times especially in the Scottish Premier League
Hi Julian,
league games with H2H history are either played on the teams home grounds or on the other teams home grounds. Therefore domestic cup games played on neutral ground are not applicable for H2H comparison as it’s for both teams an away game.
Another question which comes up regularly is, if it is wise to include friendlies as well as cup games which are played at the home teams ground, or matches where the away team played on another teams ground.
I have not found any statistical reasons yet why these games should not be included. Their inclusions/exclusions neither make the odds calculation more accurate nor do they increase/descrease observed deviation.
Being a football supporter, my husband feels strongly not to include friendly matches, as they are not competitive games. But we disagree on this point. Me, being a practical and by nature lazy mathematical mind who is speeding up the data collection process by using macros and automated copy and paste functions to fill in the value sreadsheets with data, I dislike time spend to sweep through H2H matches to delete manually friendlies. Especially as I don’t see any mathematical, statistical reason for this.