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!

2017-18 Winter League HDAFU Tables


Please note that this is an archived post. We decided not to remove it from the site because of the many questions and answers in the comments section. For those of you with curious minds it may also be quite interesting to see how our HDAFU Tables have developed over the years.

Here’s the link to the new sales page: HDAFU Inflection Points Tables


As you may already know from our 2017 Summer League tables, you now receive three separate tables for each league purchased. (Except Australia, see below).

Why? Well, we had an idea in early 2016 and experimented with it. Read about that brainwave here.

Why should I buy them?

Because they are the most effective and successful method we know of building a lucrative portfolio of bets targeting the sweet spots in the odds range. Read about our successful Summer League campaign here and our successful Winter League campaign here.

How do I use them?

Full instructions plus a free HDAFU table download is available here.

You can mix Winter and Summer League tables in your order, and don’t forget to apply the discount codes for multiple purchases. (See green box immediately below).

Buy Your Tables Here!

PRICE(*): £35.00 GBP Per League

The following discounts apply for multiple purchases:
Buy 5, 6, 7, 8 or 9 leagues = 20% Discount (coupon code: SW20)
Buy 10 leagues = 30% Discount (10 for the price of seven) (coupon code: SW30)
Buy 11 or more leagues = 35% Discount (coupon code: SW35)

Please contact us (sales[at]soccerwidow[dot]com) should you have any questions regarding checkout and payment. For further clarification about the HDAFU tables please use the comment function below.

Should any of the above codes not work for any reason (It’s Javascript and some browsers may prevent the lightbox opening) please use the basic version of the cart to purchase your HDAFU Simulation Tables

The tables for sale are in Excel .XLSX format. Should you require a different format,
please feel free to get in touch with us by email.

(*)Prices are net prices ex VAT (Value Added Tax).

EU VAT rates will be added on the checkout page according to your location if in Europe.
Customers from the United Kingdom currently are not charged any VAT

Read more: EU VAT Information


Help with the Checkout

Open the scroll down list and click a league to highlight it.

Click on the Add to Cart button to include the item in your shopping basket.

Click Continue Shopping to add more items to your cart.

When you are ready to checkout, add your discount code (coupon code) if applicable (see multiple purchase discounts below), and click on Update Cart to register your discount.

Enter your personal details before clicking Continue Checkout at the bottom of the window.

You will then be given a choice of paying with PayPal or your credit card (via Stripe).

Contact us if you wish to pay via Skrill, Neteller or bank transfer.

Upon payment, download links for the files you have purchased will be automatically sent to your email address.


What You Get for Your Money

Instead of the usual one HDAFU table per league, you now get three. (Except Australia A-League, which is a whole season analysis only due to its size and lack of any recognisable mid-season break. The price of this table is now reduced to £10.00 GBP).

The new style tables presented here are also optimised for easy filtering.

Our recommendation is for a set of systems in several leagues, enough to provide you with a portfolio of at least 500 bets in a season. You’ll then have a chance of emulating our 2016 campaign.

Frequently Asked Questions

Is there a time restriction on the usefulness of the HDAFU tables?

The tables simulate the profits and losses by betting type for the last five complete seasons if choosing the same bet type for every game of the season. Therefore, the ‘natural’ cut-off point is the end of the following season when the tables have to be re-calibrated.

Simulating the profit/losses when betting on the same outcome over the last five seasons, the tables show a picture of the likely (expected) distribution for the forthcoming season.

If the bettor chooses a distribution which is equally spread over the year (e.g. underdogs in the German Bundesliga with odds between 4.0 and 17.0), then it doesn’t really matter when the systematic betting starts.

The HDAFU tables are a great help at any time throughout the season to provide focus upon profitable areas within your chosen league and allow you to refine your final bet selections.

Further reading:
Probability, Expectation, Hit Rate, Value, Mathematical Advantage: Explained
Avoid Placing Bets at the Start of Season

What is the relationship between the HDAFU tables and the Value Bet Detector?

The HDAFU tables simulate profit/losses when betting systematically on one specific bet type, e.g. backing the home win, the draw, the away win, the favourite or the underdog. The Value Bet Detector is an odds and probability calculation tool for individual/particular matches of interest.

Both tools originate from the time Soccerwidow wrote match previews for Betfair and needed to identify games containing value bets for analysis. Here is a summary of those predictions.

The HDAFU tables were initially developed as a tool to recognise clusters of matches that were far more likely to contain value bets, and thus provide filtered sets of matches to preview.

We often receive questions such as, “Can the HDAFU tables and the Value Calculator support each other?” or, “What is the relevance of the HDAFU tables?” or, “Which methodology is better?”

Ultimately, both products are tools for odds calculation and understanding the betting market. The Value Bet detector is an analysis tool for individual matches; the HDAFU simulation tables is better for systematic betting in larger numbers.

Further reading:
How do Bookmakers Tick? How & Why do they Set Their Odds as they do?
How Bookmakers’ Odds Match Public Opinion

How do I structure a portfolio and what is the best size for it?

“A portfolio is a package of bets where extensive analysis has determined the choices (picks)… This is an essential part of the whole betting strategy in order to reduce the risks of losing by diversifying.”

Now focus on the main expressions: extensive analysis… determined choices… whole betting strategy… reduce risks… and lastly… diversifying.

Actually, there is nothing more to say. Just spend some quality thinking time on it.

It totally depends on personal preferences, on the availability of betting markets to you, on your risk awareness, your understanding of probabilities and statistics, and finally, using all of this combined knowledge to make your best personal judgement, never losing sight of the fact that the bottom line is making profits.

Further reading:
Calculating Odds for League Newcomers is Unpredictable
1×2 Football Betting – How to Compile a Winning Portfolio

Are the HDAFU tables for both, back betting and lay betting?

Yes. Although the HDAFU tables directly simulate what happened from a backing perspective over the last five seasons, they are obviously reversible and provide a sound benchmark for formulating lay betting strategies.

Large positive figures and rising curves within the tables indicate promising back betting opportunities, whilst large negative falling curves point to potential lay strategies.

The HDAFU tables come with an odds toggle as well as an exchange commission toggle so that the user can adjust the base figures where necessary – This is of great importance to those wishing to accurately analyse lay strategies.

Don’t forget that betting exchange odds are often ‘higher’ than the highest bookmaker odds and, of course, have a built-in commission surcharge levied by the exchange platform. The effects of these variables can be gauged using the toggle functions within each HDAFU table.

Further reading:
1×2 Betting System: Analysis of HDA Data and Strategy Development – LAY THE DRAW
1X2 Betting System – Staking the Underdog

Why is concentrating on bet types more profitable than betting on teams?

The answer to this question is simple psychology, which often defeats the average punter.

There are millions of people who follow one or another team. They read all the news available, discuss form, players and managers, and everything else there is to think about when a match involving “their” team is coming up.

There are plenty of “must win” situations, and even if the odds seem a little short, bets are still placed on the team they support to win the game. Both reliance on luck and a lot of hope goes into each game.

Unfortunately, gut feelings are very often a false friend and team news also has no relevance to the ‘true odds’ of a game; little wonder that there are more losing punters than winners.

The HDAFU tables help the gambler to disconnect all emotions from betting. The figures show very plainly where to concentrate when compiling a betting system portfolio for profit.

Further reading:
Finding Betting Odds Inflection Points
Half-time Results are more Predictable than Full-time

What do you recommend to read for better understanding of the HDAFU tables?

HDAFU Tables Knowledge Base

1X2 Betting System – Staking the Underdog
How to Compile a Winning Portfolio
Finding Betting Odds Inflection Points
Odds Toggle Function


HDA Betting: Profit/Loss Simulation Tables
PRODUCT SUMMARY

  • Format: Excel .XLSX (compatible with Excel 2007 and higher, LibreOffice, Google Sheets, OpenOffice, etc.)
  • File Size: between 623 KB and 2.85 MB each
  • Publisher: Hertis Services Ltd (former Soccerwidow Ltd); 5th revised edition
  • Simulations within each Workbook: Home Win, Draw, Away Win, Favourite & Underdog, plus a breakdown of individual teams’ performance in each bet type from both a home and away perspective.
  • Language: ENGLISH

By purchasing this product you agree to our Terms and Conditions and Privacy Policy.

After payment you will be redirected to download your purchased product(s). You will also receive an e-mail with a confirmation of your purchase and download link from DPD (our partner for storing and delivering of digital products) as well as from PayPal (our partner for secure payment processing).

PayPal is an online payment service that is world-wide used for processing secure payments on the Internet. Paypal supports all major payment methods such as direct debit, credit cards and deposits. Should you wish another payment option then we also offer Neteller, Skrill (Moneybookers) or bank transfer. Check here.

Customer Comment

The results of your 2016-17 campaign are fantastic. I’m going to go through your campaign in detail and learn what I can about how and why you put it together and then hopefully go some way toward achieving what you guys did in that season.

One other thing I wanted to say about what you offer at Soccerwidow….the material – free and paid for – is so valuable and really does teach people what they need to know in order to understand the betting market and what is profitable and what is not, the pitfalls and the best way forward.

I’m very much like you in that I don’t see the value in blindly following someone else picks, but when someone doesn’t know the betting market or how to go about it themselves, blind following is what a lot of people gravitate towards.

With your products they really do teach people and empower them to be able to make their own decisions and do things the right way. I feel I have learned a tremendous amount since I found your website and am very much looking forward to putting it into practice in this upcoming football season.

Great job on what you guys do at Soccerwidow!

Simon


Last Update: 31 July 2017

Categories:1x2 Betting Betting Systems



77 Responses to “2017-18 Winter League HDAFU Tables”

  1. 14 December 2015 at 12:44 pm #

    Hello,

    I’ve just purchased some HDAFU tables. However, in the “data” tab, where there are Bookmakers’ highest Odds.
    I wonder the web site that you took the data since i want the exact data to compare with the Betbrain (i often use to archive the highest odd before kick-off for calculating my odds toggle purpose).

    For instance, in your HDAFU for Bundesliga (backing home team to win), odds clusters 2.00 – 2.10 positive result and 1.92 – 2.00 negative. So if i i look for the highest odd before kick-off at Betbrain is 2.01 but your data source is 1.99. It’ll be a bias selection, am i right?

    Can you help to clarify ?

    Thank you

  2. 13 December 2015 at 3:39 pm #

    Hello again Manfred,

    It is likely that we will continue with Full-Time HDAFU tables only – no-one seems to want the Half-Time tables.

    The updated Summer League tables will be ready and available for sale in around 10-14 days’ time.

    Thanks for your question and no doubt we’ll talk with you again soon.

  3. 12 December 2015 at 7:27 pm #

    Hi Right Winger,

    in your comment from 25th of September you mentioned that you’re not sure if there will be new HDAFU tables in the future.

    Can you tell us more regarding the Summer Leauges ?

    Thanks

  4. 6 December 2015 at 4:42 pm #

    Hi Thien,

    Please check out the knowledge base articles that are linked towards the end of the following article:

    https://www.soccerwidow.com/football-gambling/betting-knowledge/systems/hda-1×2-betting-profit-loss-simulation-tables/

    Archived instructional videos are here:

    https://www.youtube.com/watch?v=03LGr5V5b3M

    https://www.youtube.com/watch?v=N-l52QV6pdo

    https://www.youtube.com/watch?v=N8uRxwn6TIE

    https://www.youtube.com/watch?v=8XRzNnQpTKU

    https://www.youtube.com/watch?v=nCVE7QVBMmo

    These will give you an idea how to sort the tables to find the sweet spots. Otherwise, another useful article is the Inflection Points tutorial here:

    https://www.soccerwidow.com/football-gambling/betting-knowledge/value-betting-academy/odds-calculation-en/inflection-points-football-betting-odds/

    Thanks for taking the trouble to write and best of luck!

  5. 4 December 2015 at 2:08 pm #

    Hi Soccerwidow / Right Winger,

    i would like your company to provide some tutorial to us for using Profit/Loss Simulation Tables that recently i had bought it.

    Thanks & Regards,
    Thien

  6. 21 November 2015 at 1:26 pm #

    Hi Jason,

    Now I understand. The 1.15 and 0.85 figures appear in the formulas for First Half Goals (over and under 1.5) in the Value Calculator Spreadsheet.

    These are purely manual calibrations based on observations of our collection of over 1,000 completed sheets.

    The 0.85 and 1.15 adjustments bring the calculations within an acceptable error rate of +/-3%.

    I certainly do not want to explain any further how these figures were arrived at or indeed wish to divulge our trade secrets, but once again this is evidence that mathematics is never an exact science – there will always be an error rate in any statistical calculations.

    Thanks again for taking the trouble to write!

  7. 21 November 2015 at 1:18 pm #

    I think you may have misunderstood me – the calculation is for the automatic back/lay column in the true value calculator spreadsheet. In the automatic back/lay formula, there is a >= 1.15 and a <= 0.85. I am struggling to understand how you guys came to that number and calculation? Please could you provide some clarification on it?

  8. 15 November 2015 at 8:59 pm #

    Hi Jason,

    Not quite sure what part of the HDAFU table spreadheet you are referring to as in the Odds Ratios clusters, the higher number will always be on the right hand side – using your figures, the cluster would be described as >0.85 <=1.15. If it is this area you are referring to then these cluster figures have been calculated by dividing the entire match list into roughly equal groups, and the 'greater than' and 'less than or equal to' parameters are purely the boundaries of each cluster group. It's a pretty sophisticated system for sorting the data that we employ to make these divisions, and I can't (in simple terms) explain how we do it. Just suffice to say that we sort and divide the data automatically and fine tune manually. Of course, if you want to play around with the cluster groups, simply over-write the figures with your own. So long as the bottom line P/L figure remains unlatered and the number of games Pld and Won still match those of the other ratios, then you can't go far wrong. Jason, I hope I've answered your question but let me know more specifically if I'm missing your point. Thanks again for your contribution.

  9. 31 October 2015 at 8:26 pm #

    Hi,

    I’m confused and I hope you can provide guidance.

    I use the HDAFU spreadsheets to determine a systematized bet for a particular league e.g. bet draw on ‘x’ league when draw odds are 3.5. For a particular round of matches, 3 bets are identified. I could straight bet on the three draws, however I then use the True Odds & value detector sheet to determine value bets for the 3 matches. None of the value bets identified are draws. I don’t bet on the draws, however 2 out of the 3 matches results in draws.

    Please can you assist me with this predicament? Its frustrating and not sure which spreadsheet to believe?

    Thanks

    P.s. love the quality of articles on the site – keep up the great work 🙂

    • 4 November 2015 at 5:03 pm #

      Hi Jason,

      the HDAFU tables and the Value Calculator are two completely different tools.

      The HDAFU table are for systematic betting – finding a strategy like you give as an example: Bet draw in ‘x’ league when draw odds are 3.5. The tables strength is finding the inflection points where systematic betting is possible.

      The Value Calculator, on the other hand, is for fans of odds calculation. It calculates the probabilities of an event happening for individual matches. This tool is, strongly speaking, not usable for systematic betting as each match has to calculated individually what is pretty time-consuming.

      Sorry for the confusion, and I promise that at some stage within the next 12 months I will write a comprehensive course on 1×2 betting. including the VC as well as the HDAFU tables.

      • 14 November 2015 at 7:49 pm #

        Thanks for the response Soccerwidow.

        Another question – in your back/lay formula, there is a calculation i’m not sure on and how you get to those numbers: column / column >= 1.15 and column/column <= 0.85. What is the significance of this portion of the calculation and how did you get to 1.15 and 0.85?

        Looking forward to that course in the future

  10. 21 October 2015 at 3:17 pm #

    Hello again Cobber,

    Yes, you are quite right and this highlights the necessity to find the inflection points in each bet type. Whether you do this with graphs or whether you look at the long list in each HDAFU table and sort the results manually is a matter of personal taste.

    What looks on the face of it like a losing system is sometimes totally transformed when you identify the sweet spot in the best performing bet type. Essentially, you will be discarding clusters of odds or odds ratios at either end of the list (or both; or even discarding a portion in the middle) until you reach a point where you can no longer improve on the bottom line. Check if the clusters you have chosen made a profit in each of the last five seasons and if they did, you have found an ideal candidate for including in a portfolio.

    Sometimes, a combination of sorting by odds clusters (e.g. home and then away) or by ratios (e.g. HxDxA and then Away/Home), or by a mixture of odds clusters and odds ratios will be needed to find the most lucrative combination. It’s trial and error to some degree.

    Try sorting the long list by home odds. Then look down the long list in each bet type or use a formula at the bottom of each column such as =max(range:range) to see the highest figure each bet type reached at a particular point during the five seasons. Then choose the bet type which shows the highest figure to analyse first. By chopping out unprofitable clusters, what you are left with is the real potential of that bet type.

    To summarise, the HDAFU tables exist to show you what is best to bet on in each league and once you have chosen which bet types to analyse, it is up to you to filter and achieve the optimum result possible. If you cut out all the unprofitable sectors you will be targeting games where historically betting profits have been made. If you then only bet within your filter parameters, then each bet you make will effectively be a ‘value’ bet.

    As mentioned frequently above, concentrate on Premier Leagues in each country only. Lack of demand for bets in lower leagues leads to bigger overrounds (basic supply and demand) and anyone betting perpetually in this situation is automatically handing the long term advantage of ‘value’ straight to the bookmaker.

    Thanks for you valued contribution and I hope this helps!

  11. 20 October 2015 at 12:02 pm #

    Thank Right Winger. Another question. When i adjust the toggle function even by -1% all the tables that are positive are now negative and the negative ones are even more negative. Given im not based in the UK (for EPL) and dont have access to all the bookies its not reasonable to expect me to get close to the odds and -1% probably isnt low enough. im surprised about the massive impact this is having making most of the strategies unsustainable…am i reading this right?

  12. 20 October 2015 at 11:18 am #

    Hi OCW,

    Yes, we phased out the calendar month analysis becuase it was an unreliable guide. The reason for this being that every two years various leagues begin earlier than usual and end earlier to accommodate the World Cup or the European Championship tournaments.

    Working on our prescribed five seasons’ data set (for statistically significant results) would mean we would need at least 20 years’ data to see any noticeable trends from these early league starts/finishes.

    I hope you’re not too disappointed. As an aside, we will probably add a day of the week analysis to any future HDAFU tables, which is a useful guide when combining several systems from different leagues.

    Best wishes and good luck.

  13. 20 October 2015 at 11:10 am #

    Hi there,

    Just wondering if its just me or the EPL FT HDAFU excel sheet doesn’t come with the Calendar Month Analysis?

    Useful information, thanks for providing this useful resource.

    Thanks!

  14. 20 October 2015 at 11:06 am #

    Hello Cobber,

    Yes, our attitude has changed down the years. We no longer ‘favour’ ante post lay betting as much as back betting. This is purely because in order to place an ante post lay bet in an exchange you usually forfeit any value in the bet because you are constantly buying a price which is above the backing odds – and then you have to take into account exchange commission.

    In the long run, ante post lay systems tend to be poor performers whether you use a fixed stake or a fixed win plan, although we previously favoured the latter to smooth out the huge profit/loss peaks and troughs that can occur.

    The real advantage of lay betting is ‘in-play’ and we would therefore advocate lay bets for traders rather than system bettors.

    We use fixed stakes in the HDAFU tables for two reasons:

    1) For back bets, fixed stakes definitely perform better than fixed win, especially with underdog betting.

    2) By simulating with fixed stakes, all negative totals for the bet types analysed indicate laying strategies – we therefore don’t need to duplicate the tables with lay odds. The exchange commission toggle is present in the tables to simulate the effects of backing (or laying) with exchanges. (Of course, you can always change the 100 units stake to whatever figure you wish to use).

    To summarise, we rarely touch ante post lay betting but if we were to return to it, then it would be on a fixed win basis. For ante post back betting, we always use fixed stakes.

    I hope this clarifies the situation and many thanks for your valuable question.

  15. 20 October 2015 at 8:01 am #

    Looking at articles on the site i notice you mention you advocate fixed win staking. i recently purchased a HDA table i was wondering why you calculate the numbers based on fixed stake of $100 yet advocate throughout the site fixed win staking. Looking at the back the underdogs numbers for example if i change it away from fixed stake to fixed win (which means im putting on less $ on long shots) it changes from making money to losing money.
    above you say you now do fixed stake. Which one are you using now for all of your systens?? cheers

Leave a Reply / Comment

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