Demystifying Betting Myths
Statistics are the language of betting; learn to speak fluently, and the market will reveal its secrets.

Experience the future of sports betting education at our new store – visit Soccerwidow's new store!

HDAFU Tables: £20k in 214 days with the Winter Leagues


Following up the successful 2016 Summer League Campaign, here is our complete report on the 2016-17 Winter League Campaign, based on 18 different top flight leagues.

300x300 Illustration: 2016-17 Winter League Profit Curve2016-17 Winter League Profit Curve



We will try to avoid repeating what was said in the summer league article so that it is all new information for you here.

For the sake of completeness, you should still read and digest both reports for a full idea of our strategies and thought processes.

And you will find the current stock of available HDAFU tables via this link.



2016-17 Campaign Report

Measures of Risk

Before beginning to plan any portfolio or placing bets, you will need to review your analyses and rank the systems you have found according to risk exposure based on the values of the upper inflection point odds.

This will allow you to compile a portfolio with a healthy balance of risk, which is essential to the success of any investment plan.

Here is our rough guide:

  • Low Risk (Probability 45.00% or more; upper inflection point maximum odds of 2.22)
  • Low-medium Risk (Probability 44.99%-35.00%; upper inflection point maximum odds of 2.85)
  • Medium Risk (Probability 34.99%-22.50%; upper inflection point maximum odds of 4.44)
  • Medium-high Risk (Probability 22.99%-16.00%; upper inflection point maximum odds of 6.25)
  • High Risk (Probability 15.99% or less; upper inflection point odds above 6.25)

Discretion is used if a system does not fit these parameters or crosses two or more classifications – In these cases, the harmonic mean odds of all the games in the set is used as the benchmark to guage risk. The Excel formula for a range of odds in cells A1 to A100 would be: =HARMEAN(A1:A100)

Measures of Success

You will also need a definitive framework to be able to judge the final results.

For us, the final results of any league fall into four distinct categories:

  • Systems that achieve a six-season-high (i.e. profits larger than any of the previous five seasons). (Over-Achievers).
  • Those that make a profit over and above the size of the initial stake (£100 in our case), but fall short of six-season-high results. (Achievers).
  • Strategies that break-even or, record a tiny profit or loss up to the size of the initial stake (£100 in our case). (Zero-Sum).
  • Leagues that make a loss over and above the size of the initial stake. (Losers).

You can already see that two of these outcomes are favourable, one is neutral, and only one is detrimental.

2016-17 League-by-League Review

Let’s have a brief look at each league to see how our 22 systems fared. (Alphabetically according to the tab codes in the workbook):

1. AUS1 – Austria Bundesliga – Whole Season System

Risk: Medium-high

Only eight of 28 bets won, but this was enough to see a profit of £882.00. Hit rate and yield were both below the calculated averages and the resultant profit figure was lower than any of the five previous seasons’ figures.

Result: Achiever

2. BEL1 – Belgium Jupiler League – Whole Season System
Up to, but not including Europa League and Championship Group splits

Risk: Medium

Both the estimated hit rate (33 out of 97 bets won) and yield figures were surpassed by wide margins, leading to a six-season-high profit figure of £3,108.00.

Result: Over-Achiever

3. CZE1A – Czech Republic 1. Liga – First Half Season System
Up to the 04/12/2016 winter break

Risk: Medium

Nine out of 22 bets won, and whilst the hit rate and yield both outstripped expectations, the profit figure settled at £1,247.00, the fourth largest in the last six seasons.

Result: Achiever

4. CZE1B – Czech Republic 1. Liga – Second Half Season System
From 18/02/2017 start of the second half of the season

Risk: Low

This one suffered its worst result in the last six seasons, but the resultant loss was minimal at -£310.00.

Result: Loser

5. DEN1A – Denmark Superligaen – First Half Season System

Risk: Medium

This was the only system employed in this league purely because the format of the second half of the 2016-17 season was to change from previous seasons.

Although hit rate and yield were both below estimates, the system still recorded its third highest total for six seasons at £1,238.00.

There were twice as many bets than expected (largely due to the fact that around 40% more games than usual were played in the first half of the season to accommodate the new second half season format).

Result: Achiever

6. ENG1 – England Premier League – Whole Season System

Risk: High

This system suffered the longest losing streak we have ever encountered, almost 14% worse than expected, for a very painful 36 straight losses. (A six-season-low).

However, the situation was mostly recovered by three big winners all carrying odds of over 12.00, for a final loss of just -£32.00.

The last six bets of the season lost, but had only one of these been a winner, this system would have returned a profit. Small margins.

Result: Zero-Sum

7. FRA1 – France Ligue 1 – Whole Season System

Risk: Low-medium

Hit rate and yield were both below par, but the league turned in a steady performance for a profit of £1,634.00, ranked fifth largest in the last six seasons.

Result: Achiever

8. FRA2 – France Ligue 2 – Whole Season System

Risk: Low-medium

The same story as France Ligue 1, but with a profit of £2,801.00, for its third largest profit figure in six seasons.

This one was unusual for a much higher number of bets than expected. (215 vs. 119 estimate – Profit was at £2,523.00 after 119 bets).

Result: Achiever

9. GER1A – Germany Bundesliga 1 – First Half Season System
Up to 21/12/2016 winter break

Risk: Medium-high

Another below par system, but one that still achieved a profit of £1,098.00. (Fourth largest in six seasons).

Result: Achiever

10. GER1B – Germany Bundesliga 1 – Second Half Season System
From 20/01/2017 start of the second half of the season

Risk: Medium

The very rare inclusion of a system with two non-profitable seasons (the oldest two) in the previous five.

It featured one more bet than expected, which won, to total one more winner than expected. Hit rate and yield both exceeded estimates for a profit of £1,294.00. (Fourth largest in six seasons).

Result: Achiever

11. GRE1 – Greece Super League – Whole Season System

Risk: Low-medium

The hit rate here was almost 8% below estimate and resulted in the worst performance for six seasons, and a loss of -£819.00.

Result: Loser



Last Update: 2 August 2017

Categories:1x2 Betting Betting Advice Betting Systems Case Studies



231 Responses to “HDAFU Tables: £20k in 214 days with the Winter Leagues”

  1. 25 December 2019 at 12:55 pm #

    Dear Soccerwidow, i’ve tried out inflection point graphs for U/O2.5 goals using HO/AO and HO/AO range of (0.095-0.237) gave me results which look good for Germany BL 1 2016-15 season when back tested because all games ended in O2.5 goals. I think may be I made a mistake some how. Can I email you the table I used to check it out?

    • 26 December 2019 at 11:25 am #

      It seems, Odoo, that I misunderstood your previous question as you placed in an HDAFU Table article but referring to the Cluster Tables. Please ask any further questions re. Cluster Tables in the FAQ article: Frequently Asked Questions – Over Under Cluster Tables

      In answer to your question… Do you know this article here? What are Inflection Points and their Use in System Betting It will probably provide you with the answer you’re looking for.

      To answer your query shortly: No, it’s pretty unlikely that you made a mistake. Bookmakers adjust odds according to market pressure and expectations. So, if your backtesting shows good results then the future is likely to bring good results too. Just be very careful and adhere to a strict staking plan.

  2. 24 December 2019 at 12:33 am #

    Dear Soccer widow, is it possible to get systems from HDAFU simulation table using quartiles in the IPHOAO section?

    • 24 December 2019 at 3:37 pm #

      Dear Odoo, you can certainly try but to be honest, I do not know. This particular scenario I have not analysed and, therefore, I cannot say if it works or not. Sorry.

      The Inflectionpoint HDAFU tables provide such a plethora of information and different angles that the quartile approach may be well worthwhile to explore.

      Have a very Happy Xmas and good luck with your betting!

  3. 13 December 2019 at 6:41 pm #

    Hi? I’ve purchased the 2011-16 winter league campaign. I want to know how you compute the odds rank* column.

    • 13 December 2019 at 8:54 pm #

      Hi Odoo,

      Firstly, Excel can only cope with 200 markers for a graph.

      The Inflection Points graph in your spreadsheet is powered by data from the Odds Rank column.

      If you sort the data (rows 6:1833) by the odds column L (smallest to largest), you will see that the odds rank numbers in column B then line-up in batches from 1-200.

      To assign the 200 groups of numbers it is merely a case of dividing the total number of data sets by 200. In this case, 1,828 matches divided by 200 provides roughly nine matches per batch (rank).

      I hope this answers your question and helps you to understand how Excel graphs work.

      Thanks for your question and all the best for now!

  4. 16 May 2019 at 12:32 am #

    Dear Elena and Rob,

    I hope you are doing well! 🙂 if I may ask you the following: which odds have you been using for your 2016/2017 winter leagues excel sheets? I have tried to reproduce your portfolio for the French Ligue 1 on the paper backing the favorite. However the odds ive been using slightly differ from yours and interestingly this small difference eventually makes a big difference. My result is 904 units compared to your 1.634 units. As the odds decide which game you bet we have a different portfolio (your portfolio consists of 138 matches in France, mine has 131). I would like to reproduce your portfolio but would need to know the exact odds you were using.

    My odds: I used historical data from football-data.co.uk. For whatever reason their excel sheet does not contain maxodds at the market.)

    So I took Bet365 Interwetten, BWin, Ladbrokes, Pinnacle, William Hill, VC Bet and Pinnacle closing odds (last odds before match starts). That’s all the odds I got from the excel sheet from football-data.co.uk. for the French Ligue 1 2016/2017 season.

    Now, which odds exactly have you been using? My guess is that you have been using the highest odds available on the market at kickoff. But where do you get the data from?

    Last question: do you know any other website that provides historical odds in excel sheets?

    Thank you and warm greetings to Teneriffe!

    Florian

    • 19 May 2019 at 8:51 pm #

      Hi Florian,

      Yes, we are both fine, thanks very much for asking – I am back in the UK these days whilst Elena continues to bask in the warmth of Tenerife (lucky girl!) 🙂

      2016-17? Seems almost an aeon away now! If I remember rightly, Australia A-League, EPL and Greece Super League were all based on audited Oddsportal odds at the point of kick-off, where manual adjustments had been made according to the timestamps on each set of match odds. They were as accurate as we could get them.

      The other Winter Leagues used unaudited Oddsportal odds (i.e. scraped as they appeared), again at the close of the ante-post market.

      The range of bookmakers we used is outlined in our article about the settings in Oddsportal.

      One thing I will say is that when revisiting Oddsportal after more than three seasons (bearing in mind the odds used for 2016-17 were for the seasons 2011-16), what you will find now is not going to be the same picture. Oddsportal odds have a habit of being distorted by bookmakers that were in the portfolio in 2016, for example, but which have since been discarded as a featured bookmaker for whatever reason.

      In other words, I have found in the past that things get churned around to some small degree every year making it nigh on impossible to replicate the same results when scraping odds from Oddsportal. Of course, the first set of odds used for each table, 2011-12 (seven seasons back now), will probably be worse than the other seasons, and so on down the line in varying degrees.

      To be honest with you, I think you’re likely to be fighting a losing battle if you are trying to replicate a past portfolio.

      The newer home odds divided by away odds ratio approach to system building and match selection has shifted the emphasis away from purely looking at match odds to determine cluster groups. Indeed, the relationship between the home and away odds is a far more accurate benchmark, which doesn’t tend to change radically during the ante-post market.

      In answer to your second question, apart from Football-data.co.uk’s free Excel sheets, the only other source of odds that I am aware of is a paid service courtesy of Football-bet-data.com.

      Florian, I hope these answers help you in some small way and thanks once again for taking the time and trouble to contact us.

      All the best for now.

  5. 12 February 2018 at 4:11 pm #

    Dear all,

    I have seen so many of you experiencing different runs of fortune this season; many of you communicate with me via private mail and many of you post your experiences on the blog. Firstly, therefore, thank you for even bothering with our website. We are always very humbled by the support.

    Although I can’t share anyone’s individual paths, what I can say is that the raft of results vary from exceptional (several better than our own) all the way through to pretty disastrous.

    This range of results is of course down to the following facts:

    1) No two portfolios are exactly the same
    2) Bet selection criteria may differ from person to person during the ante post period
    3) Each person will certainly have different bookmakers at his/her disposal
    4) Bets will be placed at different times and/or at different odds

    In addition to these fundamental differences there are many more variables such as missed bet opportunities, lack of consistency with the timings of bets, and personal traits such as greed in waiting for higher prices to appear before committing to the bet, or even hesitancy in not being confident enough to place the bets because ‘common sense’ dictates otherwise.

    Whatever the differences between you all, whilst it is nice to encourage each other when things are going well and commiserate when things are failing, please all be aware that you are indeed all different. When you begin to compare results with each other, please, please always have in the back of your mind that your are effectively comparing apples with pears, and don’t draw too many conclusions from someone else’s experiences.

    Your results and, more importantly, how you come by them, will bear little resemblance to each other. This is important to remember, and appreciating this fact will go a long way to understanding that ‘herd mentality’ is exactly what the bookmakers thrive on.

    I do feel genuinely very sorry and remorseful for those who have bad weeks, and happy (and sometimes even justified!) when reports are received of roaring successes. And like a standard distribution curve, we receive equal numbers of both.

    Personally speaking, we have been using this systematic betting approach for several years in both full-term market and in-play trading scenarios.

    The three most important elements are:

    a) Size matters! The larger portfolio the better.
    b) Portfolio balance matters! A balanced range of bets from low-low/medium-medium-medium/high-high is essential.
    c) Bank roll management is crucial. protect what you have and speculate when you can.

    Perfecting the other necessary cosmetic details such as identifying bet placements, persevering through crises, monitoring results, checking everything, adjusting attitudes, and so on, is a very personal thing. I can tell you that what works for one will be unpalatable to another. You must find your own balances here.

    And lastly, there are two types of mistakes: good mistakes (lucky wins), and bad mistakes (uneducated losses). But you must always be in a position to recognise mistakes (whether good or bad) as mistakes whenever you make them. Write them down. Post them in front of your screen. And try very hard not to repeat them.

    I hope this helps.

  6. 12 February 2018 at 1:58 pm #

    Hi guys,

    Quick update on my paper testing of the remainder of my campaign. The 2nd half systems have had a few rounds to get going, and with the results in, to date the overall picture for the entire campaign is as follows:

    Total profit based on £100 stakes = £2414.90 (Which is 24.14 points of profit)
    Overall hit rate is 36.05%. Expected is 44%
    Yield = 2.74%. Expected is 26.43%

    So as it stands, even though the performance is below the average of the last 5 seasons, the whole thing is in profit.

    I regret not sticking with this and carrying on placing bets, as if I had done so, I would have recouped losses and got back in profit. Live and learn as they say.

    Still, a lot can happen, this season from now until the end. But I just wanted to report the period of success and to say that long term, this is working out as planned.

    Summer leagues start this weekend with Ireland, so I plan to begin a fresh campaign with real wagers then.

    Good luck guys.

  7. 1 February 2018 at 12:38 am #

    After a glimpse of hope at the end of 1st half that statistics finally settled in and recovering from losses well, I finished my 6th losing week in a row today. The hit rate was 16%. I sincerely hope I will stop chasing Simon’s “achievement” of 11 losing weeks in a row now. The campaign came back to its usual performance: 1, maximum 2 wins and then normally a losing streak of at least 4 bets, but just 4 is like a dream, normally it’s 5-12. When portfolio performs like this, no bank management will save your bank, it will just go bust later. When balance goes up, ratchet-stop loss mechanism should work well to get the most out of what you do, but when it goes down, I find it detrimental. You may bet 100 units, suffer losses, then reduce the stake to say 90, and if you win, you recover from losses by betting just 90 units, not 100. Then, if you’re lucky to win enough, you increase your stakes again to 95 or whatever and then you lose again at those higher stakes. It complicates recovery of a bank. I ran simulations and that’s exactly what is going on when portfolio fails to perform how it should for prolonged periods of time and the way losing weeks exchange with winning ones. It has 4 months to go, 5 months are gone, 785 or 60% bets placed out of 1307 estimated. I won just 224 or 28.54% of my bets. Expected hit rate is 40.93%. The hit rate is lower by 12.39%. With this kind of deviation against me, portfolio is going to fail and ratchet-stop loss mechanism would make it fail even worse. Even though it’s really unlikely all strategies will fail, it’s little consolation for us. It doesn’t matter if all systems fail and lose 10000, or 9 systems win 10000 and the 10th system lose 20000 units. It’s incredibly tough to cope with after successful summer season.

    • 1 February 2018 at 8:31 am #

      It’s weird because I’ve found the opposite has happened. Mine has actually started (I hope!) to settle in to normal performance. I’ve had a few strategy changes as we’ve moved into H2 of the season, but even some of the strategies which were catastrophic in H1 have now sorted their lives out and are making money.

      January brought 28.5 points worth of profit – a pretty crazy month! I’m prepared for more variance between now and the end of the season, but hopefully on a more measured basis than we saw in the first half of the season.

    • 1 February 2018 at 10:27 am #

      Jo,

      Please don’t replicate my run of 11 losing weeks in a row! That was most certainly a brutal run of bets.

      After the 11 week losing run, I stopped placing real bets and went into observation mode, but as my luck would have it, the entire portfolio recovered and ended the 1st half of the season in profit. Not a fortune, but 12 times the stake size, so it was something.

      As for now I’m just paper testing the remainder of the winter leagues and seeing what happens, and using it as a learning experience. I hope yours is profitable for you.

      You raised the point about the ratchet and stop loss mechanism. In my winter campaign I did eventually employ a stop loss, but not right away. Having said that, I kept 2 separate records: 1) Flat stakes for every bet, 2) Reduced stakes via stop loss.

      Interestingly there was not much difference at all in the bottom line when comparing both methods of staking. I’m basing that on losing less per losing bet, but winning less per winning went, so balancing out somewhat. Definitely the ratchet is great when on a long winning run as you really can make the most of winning bets with larger stakes. Its the long and protracted losing streaks that will be detrimental. Winnings will disappear fast with larger stakes.

      The effect of my losing streak on the bottom line of profit/loss was mitigated by the fact that the losing run occurred at the point when I had accrued 24 points of profit. After 11 weeks of losing I was at -30 points of profit. So that’s a 54 point swing, and in isolation, half of the bankroll. In real terms 30% of the bankroll.

      I mentioned it before in a post of mine, that my belief is that if the system or group of systems are all viable, then flat staking will produce a profit. My system’s showed that to be the case after judging at the end of the betting period. It’s a shame that 2 of the 13 systems running (Spain, Turkey) suffered “Heavy” losses and really dented the final profit figure.

      Certainly for the 1st half of the season, there were bigger than expected deviations in the hit rate of some systems – which most of us have reported.

      I’m hoping the summer campaigns show a little more consistency!

      • 4 February 2018 at 7:53 pm #

        I am almost pulling the plug after another DISATROUS week in which I lost more than 15 stakes! I have no more spare money to throw into this hopeless thing. Months of hard work flushed down the toilet in a matter of days is more than I can take! And SIMON, can you please mail me the exact odds ranges and possibly all the matches you have bet on the following systems:

        Ligue 1 (Favourite) +515
        Bundesliga (Underdog) +760
        Ekstraklasa (Underdog) +1293
        Ligue 2 (Draw) -223

        I also have these and they are all at pretty big loss. How can this be?

        • 4 February 2018 at 11:34 pm #

          Rado,

          Yes, no problem, I will get in touch with you on Monday.

        • 5 February 2018 at 5:11 pm #

          I noticed a while ago that if some of us make profit, then some of us suffer losses. With probably none of us achieving any gains in profits in the long run. This weekend I finally broke my 6 weeks losing run and had a good weekend. 10 bets won out of 24, 41.66% hit rate. Even if all estimated bets lose up to Thursday I will still be in profit. However, it seems even with the supposed advantage against bookies not all of us will avoid portfolio failure. Having endured so much, it’s pain to read about someone else having another disastrous weekend. Scott, let us know how this weekend went for you? And Simon?
          I suffered small loss in Ligue 1 favourite, 1st half, Ekstraklasa dog, 1st half was pretty much the same profit as Simon’s.
          Rado, it’s strange you suffered loss in Ekstraklasa since it was very good performer with dogs, maybe it’s because the way you decide if the bet is valid or not?
          Although my difference with Simon’s Ligue 1 favourite is very big – about 700 units. 99% of time I rely on pinnacle odds only and I check them on pinnacle site, not oddsportal. If the odds fall in the range, then I check other bookies for even higher odds and then place bets.

          • 5 February 2018 at 8:14 pm #

            Hi Jo – I had another good weekend. 8 points of profit. It started off poorly with Friday and Saturday both making a loss, but came storming back on Sunday.

            Belgian and Austrian draws both had a good weekend as did Italian favourites.

            Last minute drama in Monaco was a nice way to finish the weekend!

  8. 25 January 2018 at 6:00 pm #

    I am completely devastated! After accumulating a nice profit in the last 2 months, the last 2 weeks destroyed everything. Over 20 stake units loss! All my profit is gone and now I am below zero balance… NONE of my last 10 bets won, and these were not only high odds, but also short priced favourite games… I don’t understand how can this be possible. About 80% of all my systems are 10-15% below the projected hitrate!!! Why?

    • 25 January 2018 at 6:14 pm #

      Rado,

      As you can see below from my results posted, in the 1st half of the season, I had some systems performing well, and some that were catastrophic and really dented the potential profits.

      I only had one system that I would classify as an over achiever – where the hit rate was way over what was expected. From looking at the hit rates of the achievers and zero sum systems, they were well below the average of the last 5 seasons.

      I think the low hit rates has really been the consistent factor that everyone has reported on that is stunting our gains. Nothing we can do to affect the results on the pitch, and we can’t stop a poor patch of results all coming at the same time.

      As mentioned I stopped placing real wagers at the start of November, and carried on paper testing. Many of my systems that were losing – remember I had 11 losing weeks in a row! – recovered in the final 2 months of the 1st half season. So it seems we can either have consistent results or long periods of good and bad, which will result in a very topsy turvy season. Rado, I had multiple losing streaks of 8,9,10 losses in a row and it was very disheartening to see the bank depleted. Sometimes I would have an 8 game losing streak, 1 win, and then 8 or 9 losses again….it is tough to handle for sure.

      I would much rather prefer a consistent run of results over a longer period of time rather than the topsy turvy nature of things many of us have seen….but that is not something we can control.

      Observing results and paper testing is much easier on the nerves for me at present, as this was my first time getting involved with something more in depth. What I have learned is that things can only be judged at the end of the specified betting period and until that time, managing the bankroll is the key thing.

      I lost money by getting panicked around november – when in hindsight I should have stuck it out and persevered. That was a valuable lesson learned for me.

      • 26 January 2018 at 3:21 pm #

        I will post a complete hitrate report for all 17 of my systems when the season is over. Then we will be able to analyze everything.

Leave a Reply to Daniel

Notify me of followup comments via e-mail. You can also subscribe without commenting.