# 1×2 HDAFU Tables User Guide: 4 Easy Steps to Find the most Lucrative Betting Systems

## Step 3 – Adjusting the Filtered Five Season Analysis Box

As mentioned before, we have fixed most of the figures in the summary box at the bottom of the draw bet type. (The box entitled ‘Full Five-Season Analysis Backing Draw in Every Match). These will provide you with a benchmark for comparing with our filtered analysis.

HDAFU Table Data Tab: Adding Data Field Aide-Memoir

What we are going to do now is adjust the formulas in the box entitled ‘Filtered Five-Season Analysis’.

To make this easier, we type in the parameters of our new list as an aide-memoir.

All we need to remember is the start of the list on row 111 at 3.33, and the end on row 666 at 3.63.

The image on the left below shows where we have used a spare part of this box just to type in our parameters (where we have highlighted in orange).

The cells we now need to attend to are colour-coded, green and blue.

Firstly, the green cells: Total P/L; Longest Winning & Losing Streaks (LWS & LLS); # Times Recurring (for both); Pld (total number of bets); W (total number of winning bets).

Secondly, the blue cells showing the five season breakdown of matches played, bets won, and resulting profit.

We will do the green cells first.

Click on the first green cell, the Total P/L figure. In this example, cell AH1354, showing (835.00).

HDAFU Table Data Tab: Formula Field Location

Look at the formula bar above it. (In this case above columns AE, AF and AG). The formula looks like this:

=SUM(AG10:AG1329)

All you need to do is click inside this formula and change the numbers. Change the 10 to 111, and the 1329 to 666.

Check that all is okay before clicking on the tick to the left of the formula box.

Just change these two numbers in each formula every time.

Do these simple number substitutions in the remaining six green cells and repeat them for the blue cells.

Some of the blue cell formulas contain two sets of numbers. For example:

=SUMIFS(AG10:AG1329,H10:H1329,”2012″)

In these cases, you will need to change both 10’s to 111 and both 1329’s to 666.

For the more Excel experienced among you, the replace function may provide a small time saving (although you will have to unprotect the Data Tab before attempting this).

The very last step is to check each of the green and blue cells to ensure you have the correct numbers showing.

## Step 4 – The Final Analysis

Having successfully performed the first three steps, our spreadsheet summary boxes should now look like this:

Wow! What a difference!

Having filtered out the sweet spot in this league, we are left with a very promising system.

The profit/loss figure has improved by over 9,500 units (8,822 + 835) simply by concentrating on where the inflection points graph told us to look.

We have increased the hit-rate from 26.29% to 33.27%, which has improved the zero odds for the draw from 3.804 to just 3.006.

If we are targeting draws between 3.33 and 3.63, every bet we make in the new season will therefore be a value bet!

This is another vital contributory factor towards the synergy of our portfolio.

The longest losing streak has been cut in half, whilst the winning streak is now two sets of four (eight) rather than one set of five (five).

Yield looks pretty good too. With betting in general, anything around 5-6% is a good yield. With the HDAFU systems we employ, our minimum yield requirement is 10%. 15.87% is therefore very tasty indeed.

Some of the analyses we have carried out in the past have produced yield values in excess of 100%.

But despite all of this, does this analysis prove that this system is worthwhile pursuing?

### Checklist for Betting System Acceptance

These are our personal criteria for making a betting system selection decision:

• Before accepting any system into our portfolio, we require that it has been in profit in at least four of the previous five seasons.
• The number of betting opportunities and the hit-rate should both show fairly consistent figures throughout the five seasons.
• Zero odds must preferably be below the filtered system’s first inflection point value. (This is of more importance to medium and high risk systems such as backing the draw, the away win, or the underdog).
• Yield must be 10% or more.
• The maximum expected losing streak should be less than 20 matches, preferably smaller.
• Average Profit/Loss Per Season should preferably be in four figures (when analysing with a 100 unit flat stake).

Last Update: 8 August 2017

### 76 Responses to “1×2 HDAFU Tables User Guide: 4 Easy Steps to Find the most Lucrative Betting Systems”

1. zinphyosein
24 February 2017 at 5:46 pm #

hi,
i think there may be typing error .
backing home sweet spot is between 1.90 and 2.10 in inflection points graph and in article is between 1.90 and 3.10 for home backing.

• Right Winger
24 February 2017 at 6:04 pm #

Thanks for that Zin,

Duly corrected!

2. zinphyosein
25 February 2017 at 6:26 pm #

hi ,
in this example, we will back the draw between 3.33 and 3.63 odds range and i found the match in draw odds of 3.33 before one day kick-off. i place the bet and in kick-off day for example the odd change and become 3.32 may be 3.31. how can i do now?thanks

• Right Winger
28 February 2017 at 2:35 am #

Hello again Zinphyosein,

We place our bets within the hour before kick-off. If a bookmaker is offering odds within our range, we place the bet regardless of whether the price then drops outside the threshold.

If a bookie is willing to offer a price we need within the final hour of the ante post market then that is good enough for us.

What is more of an issue is seeing a price just below our minimum requirement, which never rises. In these cases, we sometimes use an exchange like Smarkets or a multi-bookie platform such as Vodds to request a higher price.

If it gets matched then all good and well, but if not, we cancel the bet as the match goes in-play.

Hope this helps!

3. MB
26 February 2017 at 10:45 pm #

Hello

Ive seen that you are using the highest closer odds at the market to look for the inflection points. Since i switched over to use the asian bookmakers – should it be possible to only use the pinnacle odds from football.data?
Which leads to my second question. You are using the CLOSER odds. So wouldnt it be necessary to only bet the closer while doing this system? Especially the summer leagues would be a problem since a alot of matches start while europe is asleep.

So i would take the pinnacle (not pinnacle closer odds) and since theire collected on fridays for weekend matches and on tuesdays for midweek matches i would only place my bets at these days. Unfortunately football.data only provides us with winter leagues.

PS: What would you do if only bookmakers you dont have an account with offer an odd which is within your inflection points and all the others you use are over/under the needed odd? Would you still bet on it? Of course, this problem wouldnt occure only using pinnacle odds

• Right Winger
28 February 2017 at 2:49 am #

MB,

By CLOSER odds I guess you mean the odds just as the ante post market closes? (and not closer as in ‘nearer’?).

I suppose it really depends on your commitments but we certainly have no problem with the kick-off times of games. This is a full-time occupation for us, so we adjust our working hours to suit.

If you want to use Pinnacle odds, then you will have to use them in your analysis and re-program the HDAFU tables (good luck there!).

BUT, we no longer use football-data.co.uk odds for the tables because of the irregularities of when they are recorded. It is impossible to be consistent with any analysis when odds are taken at two separate times per week, with these ‘frozen’ figures sometimes three days old before the match even kicks off.

It would be a huge juggling act to get the analysis correct and then bet on the games around the same times the odds are taken. There is too much time in-between for odds to fluctuate wildly.

With betting in the final hour before kick-off, we get the advantage of seeing odds change with the team news as it is released, which is always a major factor in swaying public opinion and influencing the weight of money placed on certain outcomes.

Whatever you choose to do, just make sure you are totally consistent with both your analysis and then your follow-through.

4. jo
27 February 2017 at 1:10 pm #

Hi Right Winger,

in Summer league Inflection points simulation table of MLS 2016 season you bet at odds of 1.84-3.71 Home win. After reading this article, I understand that zero odds must have been below 1.84 after sorting, filtering etc. of 11-15 MLS seasons data. When I do my own sorting, filtering etc. of 11-15 MLS seasons I end up with 2.105 zero odds. Since it’s above first inflection point value of 1.84, that would suggest this system is not going to work. Am I missing something? Can you tell what was your zero odds after you sorted, filtered and etc. 11-15 seasons of MLS?

• Right Winger
28 February 2017 at 3:19 am #

Jo,

Thanks for your important comment. I have amended the article as a result.

Zero odds should ‘preferably’ be below the first inflection point. It’s more important to get close with this criteria on your medium and higher risk systems such as the draw, away win or underdog.

With home wins and favourites where the hit-rate is higher, it is not so vital as you will usually have many more bets to contend with and the weight of numbers should be good enough to give you the hypothetical value from concentrating on the sweet spot.

Yes, USA was 2.10 zero odds as you mentioned, but achieved a nice profit regardless. Again, the 100 lower priced (i.e. below 2.11), higher probability bets (50 won) provided the synergy we needed to get into profit with the 142 higher priced, lower probability bets (65 won) in this league.

Nice profit in this league during 2016 season, but look at the low yield of only 5.59% – below our expectations partly because we surrendered some of our value by having the zero odds point for this league in the middle of our two inflection points. But, the hit-rate was higher than expected suggesting that the odds we achieved were worse than expectations.

Every league will be different – all we hope for is to be there or thereabouts with the majority of our systems at the end of the season. The chances of all the systems failing was less than 0.01% (i.e. no chance at all). The chance of all the systems being in profit was also relatively small. But, like the standard distribution bell curve, we will end up somewhere in the middle (if the analysis is sound to begin with!).

Thanks again for you work Jo!

5. VB
28 February 2017 at 3:31 am #

As usual, I make some progress with my excel tables to accelerate the filtering process. 🙂

Glad to see your new articles in soccerwidow site and congrat with the 2016 summer leagues campaign.

With your new free excel sheet’s datas, I investigate the Paraguay league and found far greater profit amount in the underdog market than in the draw market. What’s your opinion about that?

But my main question: Over the years have you found an automatic odds scraper process to download the odds form oddsportal?

Sadly, I just use the odds from betexplorer, but the odds from this site (also higher odds) are smaller than yours from oddsportal.

• Right Winger
28 February 2017 at 3:34 am #

Hi VB,

Glad to see you understand what you are doing.

Yes, underdogs look good in Paraguay too, but it’s a high risk scheme with potentially large losing streaks. Just be careful of including something like this in your portfolio – there are an awfully large number of bets, which could see your longest expected losing streak occur more than once.

Personally with underdog systems, we prefer shorter runs of potential bets, with not so many needed to be correct!

Regarding odds, we still scrape from Oddsportal. Getting a whole season’s data for one league such as the EPL (380 matches), takes approximately 12-15 minutes.

Betexplorer odds should be similar to Oddsportal as they are (or were) run by the same company, although I have noticed some differences since Betexplorer recently changed the theme and appearance of their website…

6. Timmyp
2 March 2017 at 10:53 am #

Hi
Very interested in your tables but I have a question.
You use the odds and place the bet one hour before the match starts, but which bookmaker do you use? There can be a difference in odds between bookmakers that could either make an unwanted selection part of the system or take a desirable bet out.

Kind regards

Timmyp

• Right Winger
2 March 2017 at 1:05 pm #

Hi Tim,

With such a small starting bank, we had to keep our initial number of accounts low to ensure there was enough money in them without unnecessary transfers between accounts.

As the bankroll grew, we were able to spread the money around more accounts. Right now, we use just one betting exchange, Smarkets, but I would say that they account for less than 10% of our bets.

The multi-bookmaker platform, Vodds, definitely comes in handy (includes access to Pinnacle), whilst the rest of our portfolio of accounts includes Marathonbet, Bet365, BetVictor and 5Dimes. We will undoubtedly add others as bankroll grows further.

Regarding unwanted selections, this really isn’t a concern. If we can get a price that sits within our two inflection points then that’s job done. It doesn’t matter if it then drifts out of one end the scale.

The important thing is that a bookmaker was prepared to offer odds within our threshold at a time which was close to our analysis point (i.e. within the final hour of the ante post market). Of course, it’s of even less concern if the odds we buy are above our zero odds for that system (i.e. a value bet).

As mentioned in the 2016 Campaign article comments section, we are scrutinising whether a wholesale approach to picking odds within our inflection points threshold as and when they become available is viable (rather than limiting ourselves to the final hour of the market).

We will let you know when our exercise on this question is finished at the end of 2016-17, but for the time being we are still telling everyone to do their best as close to the end of the ante post market as possible.

• jo
2 March 2017 at 4:55 pm #

Hi Right Winger,

Matchbook has complicated commission charge – 1.5% for accepted and 0.75% for posted odds regardless you win or loose. If you win you pay 1.5% or 0.75% from your profit, if you loose, you pay 1.5% or 0.75% from your stake or potential winnings whichever is lesser. How do you calculate real odds for Matchbook after complicated commission fee is deducted? Formula would be very helpful. I didn’t find it anywhere.

Also, have you had any problems with Marathonbet, their odds are probably the best in the market, but I read a lot of reviews how dodgy this bookie can be. You wrote somewhere in the comments that you withdraw winnings through betting exchanges using matched betting technique. But with dodgy bookmaker you might win just a few times and they won’t give you the chance to show loosing pattern. I would like to have an account there, but after reading reviews online I don’t know is it worth the risk to get money frozen for I don’t know how long or even confiscated for some hypothetical “problem”.

7. Right Winger
2 March 2017 at 6:17 pm #

Hello again Jo,

Thanks for your comment regarding Matchbook.

Soccerwidow has just informed me that she is aware of their problematic commission rate structure (I have to admit it was news to me), and that Smarkets is currently the only exchange that we use. I’ve therefore amended my comment above to reflect this. Thanks again.

Regarding Marathonbet, we have also read a few negative stories but with stakes as small as ours we haven’t encountered any problems yet.

But bear in mind that negative comments are usually the only ones you read about, and never the plaudits of the 99.9% of satisfied customers.

I think it also helps that the 2016 portfolio hit-rate overall was less than 50% and substantially less than this with Marathonbet (as they are underdog specialists).

For definitive opinions on bookmakers we use: Sportsbookreview

Historically, we have used exchanges to withdraw bookmaker winnings and we may do so again in the future, but following the 2016 campaign, we had money spread around various accounts and had not withdrawn anything.

The overlapping 2016-17 Winter League programme of course utilises these funds too.

Of course, if we encounter problems we will let our readers know but, for the relatively small amounts we have been betting and winning, things have been pretty plain sailing so far.

However, I am sure that as our portfolios grow larger and larger we will experience choppier waters, but the thing is we don’t necessarily need to increase the stake amounts to ridiculous levels: We can instead achieve enhanced results with a greater number of bets.

• jo
2 March 2017 at 9:57 pm #

Hi Right Winger,

Today I learned some news about MLS – it has expanded to 22 teams. And there plans to expand it to 28 teams in the future. It’s definitely not the first time when you deal with situation like this. I checked more previous seasons of MLS and it looks like it gets expanded every 2 seasons in the recent years. How leagues expansions affect betting results and HDAFU tables reliability?

8. Right Winger
2 March 2017 at 10:44 pm #

Jo,

Yes, the two new teams are mentioned in the MLS table (Backing by Teams tab).

I really don’t think it will make much difference. The MLS is definitely an unique league from the perspective that the distances between teams equate to many long trips for the away teams.

I truly believe this is a huge contributory factor to the percentage of home wins in this league. It’s always high compared to other leagues, and I expect it to be high again in 2017.

We will see if there is any noticeable change at the end of 2017, but I am really not expecting any surprises.

With other leagues, I don’t think it makes much difference, but we do have a tendency to rely more on the whole season analyses for leagues that experience expansion or contraction, rather than splitting their data into first and second halves of the seasons.

9. jo
5 March 2017 at 12:59 pm #

Hi Right Winger,

what do you do if offered price in the last hour before kick off time is a little bit out of your desired inflection points range? For example, inflection points are 1.5-2.5, price 1 hour before kick off is 2.55. Do you come back later to check again if the price moved in your inflection points range, or do you check the price only once?

• Right Winger
6 March 2017 at 3:03 pm #

Jo,

The last hour before kick-off, when the large majority of our bets are placed, can be a very hectic time depending upon the number of bets to be considered for inclusion.

At the other end of your question, if a price is a point or two below our first inflection point, then we will use an exchange to request a higher price (taking commission into consideration). If it gets matched then fine, if not, then it usually remains outside our spectrum.

With prices that are slightly higher than our second inflection point, we have to keep an eye on any movement. We check the prices constantly during the final hour. If you adopt this habit you will quickly see which ones are active (and more likely to move) and which ones remain stable.

But we are not talking about huge numbers of bets to monitor. It might be one or two in a league. The rest will already have been placed (as well within our range) or discarded (as well outside our range).

It’s a valid question and, with time, you will develop enough of a sense to make these kinds of judgements. For us, it was like being in a maze, exploring avenue after avenue until finding the shortest path to our goal. Our sense of direction has therefore been honed over several years.

Hopefully, we have saved others a lot of this time already by outlining exactly what our current processes are.

10. Daniele
6 March 2017 at 6:29 am #

Hello Right Winger,

how do you deal with championships that uses a playoff format in their season? Do you analyze only the regular season, or maybe you analyze every playoff separate from the rest of the season?

• Right Winger
6 March 2017 at 2:49 pm #

Hello again Daniele,

We don’t include play-offs or any other non-regular league matches.

Play-offs are akin to cup matches and are far more volatile than the regular rounds of a league season.

We also prefer to deal with the premier leagues in each country only. In lower leagues, there is too much statistical noise created by having promotion at one of the table and relegation at the other.

The content of lower leagues therefore becomes far more diluted by the fact that there are many more teams competing over a five season period than in the top leagues where only relegation is a factor in altering the statistical composition.

Hope this is self-explanatory, and thanks for your question.

11. Sellig
16 March 2017 at 12:48 pm #

Hello,

Great Job Right Winger !
How many bookmakers do you select on Oddsportal to find the best odds:
only premimum bookmakers automatically selected by Oddsportal;
Every bookmaker;
Another selection?

Thanks a lot.

• Right Winger
16 March 2017 at 1:55 pm #

Hi Sellig,

Good question.

We have no choice with those automatically selected by Oddsportal as they do not allow you to deselect them.

We add a selection of the more reliable bookmakers to this list, but not all of them.

We scrape our odds from a selection of around 30 bookmakers in total (including the compulsory ones).

There is a problem with Oddsportal where odds do not update from certain bookies, or sometimes they update after the match has started with in-play odds, which have to be discounted.

Our odds are therefore carefully checked and compiled – it takes hours to scrape the odds we want and to check that they are viable.

I hope this helps!

12. Sellig
16 March 2017 at 1:35 pm #

“The number of betting opportunities and the hit-rate should both show fairly consistent figures throughout the five seasons.”

How do we know that it’s consistent ? Minimum number of bets for a season ?

• Right Winger
16 March 2017 at 1:58 pm #

Hello again Sellig,

By consistent we mean that the numbers of bets in each of the five seasons should be more or less equal.

This also applies to the hit rate, which should be fairly even over the five seasons, with no huge anomalies.

13. jo
25 March 2017 at 10:59 am #

Hi Right Winger,

how do you determine if betting opportunities or hit rate has too big deviations?

• Right Winger
3 April 2017 at 4:10 pm #

Hello again Jo,

I’ve been trying to backtrack for the answer to your question as, after many years of analysis and betting, identifying deviations almost becomes second nature.

Firstly, I think that ‘anomalies’ is probably a more useful word to use than deviations.

The number of potential bets covered by a system and the expected hit rate from it are usually pretty uniform when looking at a filtered set of data from five seasons.

Anything that stands out from the pack should be looked at more closely. Was it an anomalous season that caused the deviation? Is there a history of anomalous seasons in that particular league? Are there any other reasons for the anomaly?

Certainly, if the betting opportunities are anomalous in one of the seasons analysed this can point to a change in odds setting for that season, perhaps due to the composition of the league (i.e. an historically strong team is relegated and replaced by a far weaker team, which has a knock-on effect in the odds compilation).

Filter the results in your chosen system by team, and see if there any anomalies there. You may even be able to filter out certain teams from your analysis – ones that continually let the system down, for example. See if this makes any difference to the deviations you can see.

I hope this helps!

14. JVR
27 April 2017 at 10:25 am #

I have a few questions regarding the HDAFU tables:

– Would it help to add in more seasons to the analysis?
– Would it help to weight the seasons?
– Do you backtest your picks? For example, omit betting on the first 25% of the season, use these matches to validate, and then start betting on them. And if so, how about splitting the season in half?

Thanks!

• Right Winger
27 April 2017 at 10:29 am #

Thanks for the good questions, JVR,

Yes, we performed literally years of analysis before settling on five full seasons of data. It doesn’t seem to make a significant difference adding any more. In fact, adding further seasons tends to dilute the data pool with information that becomes more irrelevant the older it is.

So, five seasons is enough to provide a data pool which carries statistical significance, and that’s all we need when analysing any snapshot of past performance. You can add more seasons if you want (and create more work for yourself), but the fringe benefits of the extra stats become more and more negligible the further back in time you go.

And don’t forget, maths is not an exact science. Our aim is to get as close to the answer as we can, knowing that there is never an absolutely correct one.

My feet are different sizes for example. Most peoples’ are. Almost all people buy their shoes from a shop. We buy shoes that fit as best they can but they are never a ‘perfect’ fit for both feet. But they do the job they are intended to do. This end result metaphor is all we can ever hope to achieve with a statistical analysis – it will never be pinpoint accurate is what I am trying to say.

Weighting the seasons again doesn’t make much sense as we want to compare ‘apples with apples’ and see how they stack up against each other on their own merits. By doing this, we get a more rounded picture of what is likely to happen in the future, without any bias being placed on past performance.

For example, there is no point identifying an anomalous season and compensating for it. We want to see the effects of that season in all its ugliness as such a season could quite easily repeat itself in the new season we are analysing for.

I could write a book longer than the Bible with the amount of back-testing we have performed over the years, and the benefits of this are that we now split the seasons at their natural mid-season interval. The 2017 Summer League HDAFU tables started this trend and in a few weeks, when the Winter Leagues end in Europe, we will again be providing three tables for each league (the whole season analysis, first half split, and second half split).

Hope this helps and thanks again for contacting us!

15. JVR
6 May 2017 at 11:46 am #

One question though. How can I obtain Betfair ‘s odds from the data?

16. Right Winger
6 May 2017 at 11:49 am #

Hi JVR,

We can work out roughly how an exchange would operate by increasing all the bookmaker odds by one tick.

This is fairly simple, and involves entering figures in the Odds Toggle and Commission Rate fields in the Data Tab.

Procedure:

Calculate the harmonic mean of each column of odds.

For example, the home odds are in column S beginning at row 10 and ending at row 484 (I’m using a random choice, Finland 1st Half season, as my example – of course, the last number will be different according to which table you’re looking at).

The harmonic mean formula for this range is =harmean(S10:S484)

Whatever result you get, in this case 2.27, you need to increase by one tick (or whatever you prefer). In this case to 2.28.

The percentage difference between 2.27 and 2.28 is 0.4405%. (2.28 minus 2.27 = 0.01, divided by 2.27, multiplied by 100).

Enter the outcome of your calculation in the Odds Toggle field for the bet type you are analysing.

Enter your usual Betfair commission rate in the Commission Rate field below the Odds Toggle figure.

Once you’ve done this, all figures in the spreadsheet for the home win will change automatically.

It’s not an exact science but it will give you an idea of the effects on the likely results of using an exchange.

Hope this helps!

17. Daniele
7 May 2017 at 12:34 pm #

Hello Right Winger,

i will quote a fragment of this article to formulate my question.

“As is typical of an underdog backing profile, the high risk/high return nature of this bet type produces a noisy curve, one full of jagged peaks and troughs. There are only small rising areas to analyse. Anything you can analyse into promising profits will contain few betting opportunities in a season, with long runs of losing bets to cope with.”

Looking at the underdog graph, i notice two particular areas that looks interesting. The first is from 4.59 to 5.40, with a potential profit of above 7000 units and 25 average bets to place. The second is from 6.50 to 8.50, with a potential profit of around 9000 units and 29 average bets to place. This particular points are rising with little to none statistical noise. But you mentioned that this segments carried only few betting opportunities and a risk of long losing streaks. Looking at your summer HDAFU campaign summary i see that you included 5 underdog systems with as little as 10 bets to place (and 20 on average). The maximum losing streak though is 10, and the only time you picked a high odds range was on the second half of the brazilian Serie A (odds from 6.50 to 8.22), with a losing streak of just 9 bets (i noticed that usually at these high odds the losing streaks are much higher, around 15 or so). So the reason why you didn’t consider the aforementioned systems in this article is because of the longer losing streaks? Did you analyzed it first and then realized the risk was not worth it? Is it safe to assume that when choosing higher odds system (higher risk and fewer bets) you try to keep the losing streak lower than you would usually do (for example here you chose the draws system with a maximum losing streak of 16, but lower odds/risk and more bets to place)? Let’s say i find a system with odds from 6.30 to 7.80, 20 games expected and 14 losing streak. Would you try to find something better and less risky?

Sorry for the long long question, but if you feel as much excited as i do when talking about betting (and i’m sure you do), i know you will not mind.

Thanks!

18. Daniele
7 May 2017 at 1:28 pm #

Right Winger,

the first system i mentioned in the Paraguayan League, after filtering it, shows a potential profit of 1515 units, maximum losing streak of 7, 5 seasons in profit, and every other value is excellent as well. 23 games expected. Can you explain why you didn’t consider it?

• Right Winger
7 May 2017 at 3:16 pm #

Hello again Daniele,

We chose the Paraguay league as our example, and as the free download table, because we thought that it would not be so popular when customers considered buying our HDAFU Tables. (In other words, we thought not many people would buy it anyway, so it would do as a ‘loss leader’).

To be honest, the time it took to write an article explaining how to use the tables to find systems was enormous.

Not only did we have to explain in minute detail every step of a process that has become second nature to us, we also had to include all the additional things to think about when analysing the tables rationally to find reasonable systems.

Paraguay is therefore a catch-all example. It does the job in illustrating the entire process. If there are other systems you have found that seem more appealing to you, then great – we’ve done our job to put you in a position to understand and find them.

Our primary intention was therefore to explain things as clearly as possible.

Every individual has his or her own level of risk aversion or acceptance. Personally speaking, I must admit that I am certainly not in a position to discuss how I decide what level of risk is acceptable to me. There are so many factors that are involved in this decision: time available to deal with the risk; starting bank size; revenue targets; staking plan; stop loss and ratchet mechanisms; when to bet; what to bet on…etc., etc…

I think what I am trying to say is that we’ve given you all the tools to make those decisions for yourself. I can’t give you my clothes to wear as you’re probably a different size and they won’t fit you as well as they do me. Hopefully this analogy is clear.

This is the reason why we don’t offer picks or sell definitive systems. It is impossible for us to know the individual needs of each and every customer. All we can do is supply everything on a plate for you to decide what is palatable to you personally.

I am at a loss to understand why people would ever subscribe to a picks service and play it blindly, not knowing how the picks are made, or what the likely long-term prospects are.

In contrast, our approach enables you, the customer, to stay in control at all times, which is one of the key foundation stones for successful gambling – staying in control.

Advocating this mindset is why Soccerwidow is so unique. 🙂

I hope this helps!

19. Tony
8 May 2017 at 7:57 pm #

Hello Right Winger,

do you use every bookmaker available on Oddsportal when compiling the odds for the HDAFU tables? What should i do if i don’t have access to this bookmakers and my selection would be much more limited (with considerably lower odds)? Let’s say on a particular match the higher odd on Oddsportal for an outcome is 7.50. My highest odd available is 7.20 and my system tells me to play odds from 7.40. Should i use the Oddsportal reference (the same used for my analysis) and place the bet anyway, or should i skip this match? Wouldn’t the last option make me miss many betting opportunities, sabotaging completely the analysis and the system predictions? Should i just bet an odd even if it’s not in the range, if it is in the range on Oddsportal? Maybe using the odds toggle function to check my expected profits before choosing the system, to see if it is still profitable at lower and more realistic odds?

• Right Winger
10 May 2017 at 12:35 am #

Hi Tony,

I think I’ve understood your various points.

Firstly, our Oddsportal bookmakers comprise the compulsory list of 16 (although these do tend to change regularly at the whim of Oddsportal), plus 16 of our own choosing:

188bet; 888Sport; Betclic; Betfred; BetVictor; Betway; BoyleSports; Comeon; Coral; Expekt; Island Casino; Ladbrokes; SBOBET; Sportingbet; Tipico; Titanbet

The historical odds we use are set in stone, so it really doesn’t matter if some of Oddsportal’s compulsory list interchange with others during the season we are betting on. Just set your optional pool of bookies to resemble ours.

You should always go with what Oddsportal tells you is the benchmark for that game. If your system says play odds from 7.40 to say 8.50, and Oddsportal’s highest odds show as 7.50, then this game is ripe for selection.

If you can only get 7.20 from your list of personal accounts, then you should still place the bet, but you’ll need to reassess as you go along whether you can get good enough odds all round to make your system worthwhile.

Check out our article on the Odds Toggle function of the HDAFU Tables, and also see my reply dated 6 May 2017 to JVR above.

If you are consistently experiencing such gulfs between best odds available in the market as a whole versus your own personal bookmaker portfolio, then keep tabs on the situation and measure its effects to save yourself from pursuing a no-win strategy.

Try out Vodds (featured halfway down the Eastbridge article) if you are struggling to get near best odds. You get access to Pinnacle there, so you should be near the top of the pile when it comes to obtaining best price…

Hope this helps!

20. Tony
12 May 2017 at 2:43 pm #

This question is just for personal curiosity, but would it be possible to base the HDAFU tables only on Pinnacle odds, for example? Would the analysis be reliable using only one bookmaker as benchmark? I’m not talking about the difficulty of isolating Pinnacle odds and inserting them in the tables, but just about the validity of the tables using only one bookmaker as a benchmark. If i understand correctly, since only the higher odds are used for each system this should not be a problem since is not a matter of averages. Also, i noticed that the oldest seasons tend to have less odds on oddsportal then the newest ones. So (i guess) this can alter the balance between each season, even slightly. Using only one bookmaker can fix this problem, even if maybe is not relevant like i think. I am very curious to hear your thoughts about the matter.

21. Right Winger
12 May 2017 at 3:23 pm #

Hello again Tony,

I understand your questions and believe me, it is something we have pondered about ourselves before deciding to use a spread of bookmakers.

Ultimately, the answers lie in many hundreds of hours of looking at Oddsportal odds and identifying trends, the various ways bookmakers set their odds, and seeing how the market moves throughout the ante post period. Also, looking at bookmaker sites and watching how their odds move, sometimes from minute to minute.

Although I can’t expand upon all of these things in a short answer (indeed, such a discussion is worthy of a whole series of articles), I can say that there are definite and separate approaches bookmakers use when they enter a market with their opening odds, and then go about garnering market share whilst keeping their books balanced.

The basic laws of supply and demand dictate that if they all did the same thing, there wouldn’t be any competition in the market. As there are several hundred bookmakers all vying for as much market share as they can get, then you can understand that they will certainly compete with each other as strongly as possible using many different tactics in order to survive and grow.

To use one solitary bookmaker for any analysis would be misleading, especially when it came to deciding upon which team is truly posted as the favourite and which is the underdog. For example, if you scan a page of Oddsportal odds for a particular game, in the majority of cases where teams of “similar strength” play each other, you will see some bookies set (and/or finish with) the home team as favourite, whilst others the away team. Some will start with one team as favourite with opening odds, and change to the other by the end of the ante post market.

Add to this the fact that some bookies deliberately reverse their odds for the favourite based on where they believe the weight of money will come from – in other words, on public perception of who is favourite, rather than the statistical favourite.

All of these factors add up to a need for a wider data set to provide a better view of what has happened with historical games, which is why we use a spread of bookmakers when compiling the tables.

Your second question about using, say, Pinnacle as the benchmark for identifying games to fit your chosen system is, I’m afraid, beset by the same problems. Pinnacle does not have one approach to its odds setting. Like all bookies, it uses several different methods depending on the popularity of the league in question, the popularity of each individual game, public opinion, and so on.

Even finding odds from one bookmaker all representative of the same moment in time is problematic as all you will really achieve is a cross section of its various (and perhaps individual) approaches to odds setting.

Whichever way you look at it, getting a more rounded view of the situation is better, which is why we use a range of bookies for both setting the HDAFU tables and for implementing them in the betting arena.

As for the number of bookmaker odds on Oddsportal reducing the further back in time you go, I agree, but this is only due to the fact that they continually drop bookies from their list – ones they don’t succeed to connect with in terms of lucrative affiliate programmes. These bookies then disappear from the list of providers of historical odds too. It is therefore important to ensure you obtain odds from a league no later than as soon as each season finishes to ensure they are as fresh as possible.

Of course, you then have to go through every individual game to iron out the many errors created by Oddsportal’s API’s. As I have mentioned before, getting reliable, timed, historical odds’ data is the single most important factor to any successful betting enterprise – the bookies understandably don’t want this data published, and the very few sites who provide or sell their data probably aren’t even aware that most of it is unreliable or unusable.

Tony, I hope this is detailed enough to answer your questions, and thanks again for bringing these topics to our readers’ attention. It takes a lot of time and understanding of how the market operates before you can take advantage of it…

22. Tony
12 May 2017 at 4:56 pm #

I was reading in a previous comment that you use over-round calculations to determine which odds needs to be manually corrected. As far as i understand, if a set of odds presents a negative over-round, you check it manually to see if the odds displayed on Oddsportal were updated? And if they looks outdated and considerably higher than the rest you change it accordingly. Is that correct? How can you be sure that a particular odd displayed is not updated to the closing value? Sometimes i see that they display only the opening time, other times they display a change several hours before kick off. Does that mean that they are outdated, or maybe they remained the same until kick off time?

• Right Winger
12 May 2017 at 6:05 pm #

Hi Tony,

We use over-round calculations as a final check to ensure a set of odds we have recorded is in order. Also, when you’ve looked at tens of thousands of separate matches (I’ve personally inspected probably more) and reviewed their odds, you develop a feel for what is right and what is wrong.

Oddsportal are the only provider of historical odds including time stamps confirming exactly when they were recorded by each API. (Just hover over any of the odds of a particular bookie for any match).

To get a set of odds timed as close to the end of the ante post market as is possible means looking at each match individually, and correcting most of the odds according to their time stamps.

I conservatively estimate we have to correct more than 95% of Oddsportal’s odds in this fashion to get a more realistic picture of what the odds were at the close of the ante post.

Oddsportal’s highest odds are supposed to mean the highest odds reached at the end of the ante post period. We are not even sure what their average odds mean, as they are neither the mathematical average nor the harmonic mean.

Yes, sometimes, the opening odds for a bookie are recorded as the highest – purely because this was the peak figure reached for that outcome throughout the ante post market.

But they are certainly not the closing odds, otherwise they would stick out like a sore thumb and everyone would buy them (as punters seek best price) – the book of that particular bookmaker would then be grossly unbalanced.

Bookmakers dip in and out of the market all of the time to continually ensure they have enough money to pay to winning customers, and hopefully retain a small percentage of the deal as their own profit.

Spend an hour or so just watching Pinnacle’s odds. The best time is the final hour before kick-off. They move all the time depending upon the weight of money being proferred by their customers. The odds have to move because Pinnacle is one of the lowest margin bookmakers – their over-round is perhaps just 2% in most cases. To defend their position they have to continually juggle their odds to maintain a balance. They have to work hard to earn their money – they offer higher odds than most but take a smaller percentage out of each match in an attempt to ramp up volume.

Once you’ve spent years watching odds move you begin to see the different strategies (sometimes several) each bookmaker employs.

Insurance is exactly the same, but in reverse. For example, there are hundreds of motor insurers all competing with each other for the same piece of business where usually the cheapest price wins the deal. But no insurer will stay the cheapest all the time for certain risks – all insurers need a balance of risk in their portfolios.

Bookmakers lay-off certain liabilities they need to cover by placing bets with each other. Insurers lay-off the top end of their liabilities by buying reinsurance. Both run very similar business models, and usually the majority of profits come from investing monies held at any one time, rather than the front-end business itself.

If you want to understand bookmaker maths and how they operate, then an insurance career is a viable alternative. Thankfully, I’ve had 25 years in top-end corporate insurance, and thankfully, I no longer work in insurance! 🙂

23. Lauri
14 May 2017 at 4:22 pm #

Hey,

First of all – great blog and awesome spreadsheets.

I went a bit further and removed odds 3,57 – 3,6 (where the big dip came). Results were pretty good, Profit growed only 252 units, but all seasons were in profit now (first one still a lot less than others). Also zero odds decreased to 2,5, yield up to 19,73%, hit rate to 40% and ROI to nearly 33%. Longest losing streak from 28 to 14.
Games played from 556 to 460, so nearly 100 useless bets less and a little bit more profit.

24. Gabriel
6 June 2017 at 1:04 am #

Hi, Would you mind explaining how do you correct the odds from Oddsportal using over-round? For example, if the converted odds to probabilities show more than 100%, it the data correction as simple as taking this, for instance, 102% and distributing them proportionally between 1×2 possible outcomes? Or it is another thing completely different?

Thanks!

• Right Winger
6 June 2017 at 6:56 pm #

Hello again Gabriel,

The time stamps of every set of 1×2 odds are checked and the odds are then adjusted individually in order to get a market snapshot as near to the close of the ante post market as possible.

The overround calculations then provide a benchmark for accuracy.

I can’t explain the process in a few lines, but suffice to say that each bet type is different, and the levels of overround differ from game to game depending on the liquidity/popularity of that particular match.

Therefore, what you have suggested in your comment is not the case – I am not even sure what proportional distribution of the overround would achieve.

I hope this helps!

25. Jamie
6 June 2017 at 6:00 pm #

When you have settled on your odds and systems, when would you recommend placing your bets?

• Right Winger
6 June 2017 at 6:18 pm #

Hello Jamie,
The bets are placed on the day of the events in question, and usually within the last hour before kick-off.

26. Simon
9 June 2017 at 3:19 pm #

Hi,

I’ve downloaded the example spreadsheet and followed through with the guide. You have done a top notch job explaining the general method to go through to find a profitable system in a given league. When all the steps are broken down, and things pointed out to look for, it all is nice and easy to follow.

I’m very much looking forward to the release of the 2017-18 winter league tables in order to analyse and find good systems to take into the portfolio.

In order to get to the point where you have 500 bets in total for a season, how many leagues would you need to be looking at realistically?

Also, just planning ahead here, when would you be in a position to make these tables available for sale?

27. Right Winger
9 June 2017 at 3:49 pm #

Hello Simon,

The Winter Leagues (20 in total this year) will be ready and available to buy sometime during this weekend.

To achieve a portfolio of 500 bets is easier to do with the Winter Leagues as many more of them tend to be larger in terms of numbers of games than most of the Summer Leagues. This means perhaps greater numbers of betting opportunities per system chosen. (But this of course relies on your attitude towards risk).

It is difficult to answer the question of how many leagues to buy. We use all of them – the larger the portfolio the better as far as we are concerned. But each user’s decision-making process regarding losing streaks and acceptable risk differs.

I would say purchasing a minimum of five leagues is a start, and then add-on additional systems until you have a portfolio with a nice balance of risk and acceptable losing streaks.

Simon, more than that I cannot say – everyone is different. Everyone will balance their portfolios differently. Some will choose low risk systems with greater numbers of bets; others will opt for higher risk systems with fewer bets; others still will blend low, medium and high risk systems into optimum numbers of bets to suit their own personal tastes.

I hope this helps! All the best.

28. Gabriel
16 June 2017 at 2:41 pm #

Hi.

When you say, in the Checklist that “Average Profit/Loss Per Season should preferably be in four figures (when analysing with a 100 unit flat stake).”, I understand that it means for a full season analysis, right? So, in other word, it means for 1st half analysis, four figures divided by two, right? Or, 500, in the case of half season.

Thanks!

• Right Winger
16 June 2017 at 3:58 pm #

Hello Gabriel,

No, we like to see our average profit/loss per season figure in four figures (with 100 unit stakes) for any of the three types of analysis, whether it be on the whole season, 1st half, or 2nd half table.

It’s not a rule that is set in stone but, for us, it is a personal benchmark for deciding whether to include a system.

29. Gabriel
16 June 2017 at 11:00 pm #

Hi. I’m very excited to start using the knowledge kindly posted in soccerwidow. My approach towards soccerbetting changed dramatically after reading the many posts here.

Here are my questions: is it worthy to add, in addition to HDAFU, lay bets? I added 3 more bet types to my analysis: lay home, lay away and lay the draw. Sometimes, it is the best way to go and since it covers 2 results instead of 1, the noise is reduced drastically. The downside is that one has to place so many bets sometimes and also, one has to calculate these odds manually, since oddsportal do not place these odds directly like 1×2 odds. What do you think about this?

Another related question: sometimes, the curves look alike each other. In other words, they show high linear correlation between each other. Back away and underdog look alike a lot when we analyse though leagues, such as Brazil or South Korea. Is that part of the job or is there a way to eliminate these sometimes unnecessary steps?

Thanks a lot and congrats!

30. Right Winger
17 June 2017 at 1:24 pm #

Hello Gabriel,

We are not fans of ante post lay betting for a number of reasons. Firstly, you have to use a betting exchange, which charges commission, and therefore robs you of a good chunk of your profits. Add the fact that the lay prices have to be above the backing odds, which surrenders even more of the value. Lastly, the psychology is different because each losing lay bet sends your betting bank backwards perhaps two or three steps at a time, whilst each winning bet provides smaller increases as it is effectively the same as backing on the double chance market. (where odds are typically less than 1.35).

At least with backing, the losses are manageable and known (fixed stakes), whilst the wins can advance the bank further than the losses can erode it. There is less stress on the bank, especially if you hit a streak of losing bets.

In our opinion, lay betting is best in an in-play environment, but if you’re still keen on ante post lay betting, just remember that this is effectively what the bookmakers do themselves when offering any bet for sale. And their profit margins are typically 5% or less. Bear in mind also that they don’t have commission to pay on their winnings or need to take a price over and above the price of backing.

We have tried so many lay betting systems in the past, but they are time-consuming (more bets to place as you have mentioned), produce more jagged profit curves (exaggerated peaks and troughs – more statistical noise, not less), and are particularly disheartening when the losing streaks arrive, knowing how many winning bets you then need to climb back to where you were before and begin building again.

It’s just a personal choice for us, but straightforward-backing-only does provide a much more controllable position and a more stress-free ride.

Have a look at my answer to JVR dated 6 May 2017 in the comments above. This will give you a rough guide on how to simulate exchange odds using the HDAFU tables.

In answer to your second point, yes, in some leagues the home win curves can resemble the favourite curves (as the home team is more often the favourite), whilst the away win curves can resemble the underdog curves (as the away team is more often the underdog).

However, some leagues are different, and splitting the analysis into season halves can also produce stark differences in these curves – the curves are therefore not always similar. I am constantly surprised with how much detail this sort of analysis can reveal.

31. Gabriel
17 June 2017 at 8:48 pm #

Hi, Right Winger! I have a question which sound the same one I’ve read here, but it is not.

Let’s say my range to bet is 2.40 to 3.00 and the majority of bookmakers show 2.90 odds before kick off, except one, Marathon, for example, that shows 3.05. In your answer before, you say in this particular case to trust the majority of bookmakers and place the bet, and if possible, at 3.05 odds.

First question: if you used historical highest odds (including Marathon), then that must have included these situations in the data to create the systems and therefore, in the analysis, this bet should not have been placed. Why did you say the bet should have been placed? Is that because you corrected all situations like these, excluding outliers one by one, like marathon or 5Dimes?

Second question: what if the situation is a little bit different, let’s say the majority of bookmakers are showing 2.30, but Marathon shows 2.45. Should I place the bet?

Thanks a lot!

• Right Winger
21 June 2017 at 5:39 pm #

Hi Gabriel,

Sorry for the delay in replying to you.

Yes, you make a good point about Marathonbet, and this also applies to the other Russian based bookmaker, 1xBet.

Because they are both low margin, high volume bookies, their odds tend to move faster than most other bookmakers, but what you see on comparison sites is not always the case when it comes to trying to place a bet at the odds you have seen elsewhere.

We use Marathonbet but do experience occasions where we wish to place a bet at odds advertised on comparison sites only to find that when logging-in to our account, the odds on offer are drastically different.

Our general rule for these two bookies is that if you can place the bet with them at higher odds than the rest of the market, then do so. But exclude their odds when making the judgment to place the bet in the first place – rely on what the rest of the market tells you instead.

This should answer part two of your question. In the case you described, I would not place the bet with Marathonbet if the rest of the market tells me their odds are outside the parameters of the system.

Hope this is useful, and thanks for you questions.

32. Gabriel
18 June 2017 at 10:58 am #

Hi. I saw myself in the following situation: my range for betting the draw is 3.5 and 3.7. One hour before the match begins most bookmakers showed 3.4 average and Pinnacle (yes, Pinnacle – not one of the bookies with errors) showed 3.75.

What to do? Thanks.

• Right Winger
21 June 2017 at 5:46 pm #

Hello again Gabriel,

The answer is to ensure you can get the odds with Pinnacle before committing to placing the bet.

They are usually very accurate (rarely out of kilter with their advertised prices), so if Pinnacle say 3.75 and your cut-off point is 3.7, then don’t place the bet.

I hope this is self-explanatory.

33. Gabriel
22 June 2017 at 5:03 am #

RW, thanks for the answers. No problem about the delay. I’ve been studying a lot and finding so many more questions. 😉

Ok. I understood everything that was said. But just one thing wasn’t clear. You said:

“We use Marathonbet but do experience occasions where we wish to place a bet at odds advertised on comparison sites only to find that when logging-in to our account, the odds on offer are drastically different.”

My point is: you did consider Marathon in the HDAFU historic tables, right? And because of that, your range for a certain strategy would be 2.20 to 2.50, for example. When applying the strategy in the following season in a certain game, Marathon shows 2.25, and you say we should not place the bet because most bookies show 2.05, for example, or because these odds aren’t true when you login to Marathon and check the odds. Alright, understood!

But, when this new season ends and goes to HDAFU table for building the new strategy for next year, this match will show the highest odds as being 2.25 and not 2.05. Isn’t that a flaw of this system?

Couldn’t we use odds toggle and reduce the highest odds to correct that? In my strategies a see marathon as highest odds many times and I keep asking myself if I am doing the right thing.

34. Right Winger
23 June 2017 at 12:59 pm #

Hi Gabriel,

Just to iron out the whole Marathonbet issue once and for all.

When collecting and correcting odds at the end of each season, almost all of the Marathonbet and 1xBet odds are downgraded or discarded in our search for odds which are more realistic and/or closest to those at the end of the ante post market.

In your example, the historical odds would have been recorded by us at 2.05 and not 2.25.

This is why we tell you to rely on the majority of bookmakers rather than using Marathonbet’s prices as a guideline.

Use Marathonbet to place a bet only when the rest of the market indicates the match in question is inside your inflection points.

I hope this is clear! 🙂

35. jo
26 June 2017 at 3:58 pm #

hi Right Winger,

if the last hour before kick off times with matches in question is not overloaded with potential matches to bet on and everything can be done with no hurry during last 15 minutes or less before kick off time is it better to wait for those last 15 minutes, maybe odds during last 15 minutes or even less would have less statistical noise, than odds for instance 60-50 minutes before k.o.? Since HDAFU simulations are based on odds at k.o. times. And there are some matches that are just in or out of inflection points 60-50min before the match and vice versa 15 minutes or less.

• Right Winger
26 June 2017 at 4:35 pm #

Hello again Jo,

I can understand your concerns in wanting to be as exact as possible regarding the placement of bets, and what the rules are.

Yes, many of our bets are placed during the last 30 minutes before kick-off. There are days which are more hectic than others, but we do ease any anticipated congestion by placing some bets hours or days before kick-off (for bets comfortably in the middle of our inflection points), because we understand how the market odds move throughout the ante post market in many of the leagues.

It is therefore possible to achieve much greater prices for a bet than the eventual odds at kick-off, AND still maintain that bet within the inflection points. (Especially with home wins and favourites). These bets not only increase the bottom line, they also make up for any bets that go wrong within your margin of error (i.e. bets drifting outside the inflection points).

If you put things into perspective, even if you place a bet at odds within your inflection points, and those odds move to an area slightly outside your calculated parameters by the end of the ante post market, some of those ‘rogue’ bets will still win and some will lose. It should not affect your overall performance to any significant extent, so long as the vast majority of your bets (say a minimum of 95%) fall within the desired inflection points.

The inflection points are not a rigid science. As we have written many times throughout the blog, statistical analysis is an estimate of the future based on what has happened in the past. It can never be expressed in exact terms.

Acceptable error is therefore part and parcel of any exercise such as this. If your analysis is sound in the first instance, you will find results at both ends of your target odds (i.e. those bets placed slightly outside your two inflection points), will have a tendency to balance themselves out across your portfolio.

I hope this helps.

36. Gabriel
5 July 2017 at 2:50 am #

Hi, Rw.

“Yes, many of our bets are placed during the last 30 minutes before kick-off. There are days which are more hectic than others, but we do ease any anticipated congestion by placing some bets hours or days before kick-off (for bets comfortably in the middle of our inflection points), because we understand how the market odds move throughout the ante post market in many of the leagues.”

My question: if odds movement is known, why not place bets like in-play betting, but during the ante-post period. For example: if backing home is 1.9 and by experience, it is known that during ante post period it will lower to 1.7, why not place bets only then to secure a nice profit using odds movement?

Wouldn’t that also be a winner?

37. Right Winger
5 July 2017 at 1:02 pm #

Hi Gabriel,

Yes and no is the answer.

The more bets you place further in advance, the more chance there is of those closer to the outliers eventually falling outside the inflection points.

This is no problem with dropping favourite prices, as we can lay the bets off with an exchange and make arbitrage. With the underdogs, we either have to let them run or lay them off at a loss.

Laying off rising underdog prices does mean that the losses can be greater than the profits we can make with laying off the favourites (larger price fluctuations possible).

The other problem of early betting is that you have to tie-up more of your money for longer periods in advance of the final hour before kick-off.

For some of us, this is okay because the bank is large enough to withstand this, but if you are on a smaller budget, you could encounter problems with money tied-up in games that won’t take place for a few days, when the money is required more immediately for games that are taking place now.

Taking advantage of odds movements is all good and well, but the profits from arbitrage are small. It’s a lot harder work to make anything like the money we can make by placing the value bets and letting them run.

I hope this explains!

38. Gabriel
5 July 2017 at 6:20 pm #

Just curious: why not inclued South Korea and China in the summer leagues for sale?

🙂

• Right Winger
5 July 2017 at 6:51 pm #

Gabriel,

You’re the second to ask that question on the blog – same answer I’m afraid – pure demand and supply as no-one has been interested in those leagues in the past.

We may however bend to include them in the Summer League portfolio next time around…

…Watch this space!

39. timmyp
16 July 2017 at 11:05 pm #

not sure about the LWS and LLS stats. When the tables are amended to show system stats, the LWS and LLS show the streaks in relation to the odds sequence. Would it be better to show the streaks in a chronological sequence?

40. timmyp
16 July 2017 at 11:12 pm #

ignore my last comment, I have missed a step…..

apologies

41. Amy
9 August 2017 at 7:37 pm #

Is there anywhere where it describes what the R-total is ? that’s really throwing me off.

Thanks

• Right Winger
9 August 2017 at 8:23 pm #

Hi Amy,

R-Total is just an abbreviation for running-total.

In other words, whatever the total profit/loss is up to and including the result of the previous/last bet.

I hope this helps.

6 September 2017 at 10:24 am #

Hi again, I’ve finally decided to purchase 12 tables and I have some final questions before I start betting this Friday. I am very proficient with maths and Excel and have completely understood your formulae and betting mechanics, so they are not an issue. However, I am not so proficient with the market mechanics themselves, so there are my final qustions:

1. I am pretty busy and dont have the time to follow all the matches, especially on weekdays, so if I always bet all matches on the evening before kickoff, will that impact my results so much and will it be okay with the HDAFU tables statistics.

2. I have missed 3-4 rounds from the seasons already, hope this will also not be so bad?

3. So 12 bought tables mean 12 systems, right? I have chosen to stick only with full-season systems and have found 5 favorite/home systems, 3 draws and 3 underdogs. Do you think this is a well balanced portfolio and will it have issues with covering the losses? My three underdog systems are with max odds of around 7.00, as I prefer not to venture into the highest odds teritory.

4. As said, I will bet in Pinnacle only, with a starting bank 20 times larger than my flatbet. What’s your opinion on this?

6 September 2017 at 3:54 pm #

And one more:
5. How accurate/recent are the odds in oddsportal. I mean, how often are they refreshed? If I decide to try and place bets on the last hour before kickoff and enter oddsportal, will the odds be accurate enough to just read them and place the bet immediately?

• Right Winger
6 September 2017 at 5:06 pm #

1. It should be possible to place bets the evening before kick-off so long as you understand how the market moves. As per my reply to you of 2 September 2017 at 12:49 pm (comments section of the Winter League Tables Sales’ Page), home wins and favourites are easier to place longer term.

However, as the HDAFU Tables are all configured based on highest odds at/near the close of the ante post market, you will experience more consistent results the nearer to kick-off you can place your bets.

2. Missing the beginning of a season should not affect you in any way. I have written about the ‘conveyor belt’ analogy in my comment dated 21 August 2017 at 3:58 pm (comments section of the Winter League Campaign article).

3. If you are firm about full-season analyses only, then yes, you will have 12 systems. Please refer to pages 1 and 4 of the Winter League Campaign article for full information on how you can assess the risk composition of your chosen portfolio of systems and why a healthy balance of risk is essential.

4. 5% of your starting bank is a fair stake size – I have no problem with this suggestion. And do not forget to use the stop loss and ratchet mechanisms for intelligent use of your bank, both from the perspective of protecting it (stop loss) and speculating to accumulate (ratchet).

5. Oddsportal is unfortunately a can of worms and relies on API scrapers with each individual bookmaker. These scrapers should be updating on a minute-by-minute basis, but reliability is a huge issue.

Some bookmakers’ odds are never updated from their opening offerings, whilst some stall further down the line. In order to tell if the highest bookmaker odds are still relevant at the time you are looking to place the bet, you will need to hover your mouse cursor over the odds figures of the best bookmakers to reveal the time stamps and list of recent updates.

Any results showing within the previous 30 minutes should be okay to facilitate your betting decision, but the nearer to the real time the better, is the best advice I can offer. As mentioned before, we tend to remove Tempobet, Marathonbet and 1Xbet from the equation and base decisions on the remainder.

8 September 2017 at 10:31 am #

It’s me again. I have found myself in a very interesting situation. A system of mine has a range of 2.95 to 3.15. In oddsportal, nearly all the bookies show odds between 3.05 and 3.10, which is well inside my range. HOWEVER, only my bookie Pinnacle has odds of 3.25! What should I do now? The market as a whole shows that the best must be made, but only because of one or two bookmakers, the bet doesnt fit in the system, because the highest odds are outside the range. And its not Marathon or Tempo, its my bookie of choosing. Should I bet?

• Right Winger
8 September 2017 at 12:19 pm #

In general, you will need to make a decision if you are using just one bookmaker to place bets if and when you encounter the situation you have described above.

Either place all bets where the criteria you have described is apparent, or decline all bets. Don’t place some and not others.

Pinnacle’s historical odds are utilised in the data set for each HDAFU Table. Therefore, if Pinnacle’s odds are outside of your inflection points odds range, then technically the bet should not be placed.

However, if the rest of the market says the bet is inside your inflection points and just Pinnacle are offering odds slightly above the market benchmark, then the extra value you will gain from taking the higher odds will probably mean you will make a profit from these bets in the long run. The lower implied probability of entertaining higher odds should not make too much of a difference as some of these bets will win and some of them will lose.

I suggest if you are going to place these bets then set yourself a margin of error either side of the two inflection points – say no more than 5% difference between the benefit on offer of the higher odds (or -5% difference on the lower inflection point odds). The example you mentioned comparing the odds of your upper inflection point of 3.15 with Pinnacle’s 3.25 produces an increment of 4.65%. (225 divided by 215). Stick with whatever you decide to do and follow it through consistently.

Rado, I hope this is self-explanatory and helps in some small way.

45. Daniel
9 September 2017 at 2:01 pm #

Hi Right Winger,

did you notice the inclusion of Asian Odds website in the list of compulsory bookmakers on Oddsportal? What do you think about that? Is kinda strange because Asian Odds is not a bookmaker but more like a odds comparison website like Oddsportal.

• Right Winger
10 September 2017 at 1:13 pm #

Hi Daniel,

Yes, I saw Asian Odds appear on Oddsportal’s compulsory list of bookmakers around a week ago.

They are a multi-bookmaker platform like Vodds, Premium Tradings or Sport Market and, like the others, provide access to Pinnacle for customers living in territories where Pinnacle does not have a trading licence.

I am not sure of the legalities involved, but I would imagine that as access to Pinnacle is via a surrogate, so long as the surrogate has a licence to trade in your geographical zone, then all should be good and well.

They also include access to five other sharp Asian books, with bets being accepted on an aggregate basis. In other words, you place one bet, but the odds you buy are split into perhaps several lines, with the possibility of all six bookmakers accepting a portion of the risk.

In other words, your stake is divided between the bookmakers willing to match the odds you require but, to all intents and purposes, your bet is settled as just one transaction via the Asian Odds platform. Asian Odds probably operates on a commission basis, taking miniscule percentages of turnover sent to the bookmakers on its panel. (But no commission is charged to the punter).

This type of arrangment is how insurance portfolios are mainly arranged for complex risks in the Lloyd’s of London market, with multiple insurance companies underwriting proportions of the risk until it is 100% filled (covered). In this way, we see once again that insurance and gambling are intrinsically linked.

For the sake of the HDAFU Tables, ignore Asian Odds for the time being as the time stamps of their odds seem to be unreliable at present. Besides, their odds should be no better than Pinnacle’s own.

Let me know if you have any further observations on Asian Odds. The prevalence of multi-bookmaker platforms is something that I believe will become more common.

Essentially operating as a cooperative, they undoubtedly offer greater liquidity and, as they are low margin, high turnover businesses, your account with any multi-bookmaker platform should never be limited, compromised or banned: That’s good news for us all!

14 September 2017 at 2:11 pm #

Time to report the results after my first week of betting 😀

It was an exceptionally good run of winning bets, probably it’s beginner’s luck, I don’t know, but the fact is that in only a week, I increased my starting bank by more than 50%! Let’s hope it continues like this from now on.

Probably I’m getting annoying, but can you please give me a piece of advice about betting times. All right, I now agree that placing ALL the bets on the previous evening is probably not a good idea, so I do my best to track the odds and place the bets in the last hour before kickoff (usually 40-50 mins before match start time).

Is it okay if I do that for all matches, because sometimes in the last hour before kickoff the odds are a true rollercoaster and can jump up or down by more than 10 hundreths in a matter of minutes? Well, I guess the effects will cancel each other out – sometimes I will bet and then the odds will become higher the next minute, but other times I will have luck and the odds will fall after I bet. So that’s probably not a problem. My worry is if the bet gets outside the inflection points. Then I guess I will simply leave it be.

Besides, the intro to your tables says something like “the odds in the HDAFU tables are based on the odds on the evening before kickoff of all matches”. So why then must we wait until the last hour before the game to place our bet, when all our data and inflection points are based on odds 24 hours earlier?

47. Right Winger
14 September 2017 at 3:27 pm #

I am glad you seem to have hit a rich vein of results at the very beginning of your campaign.

In contrary to your last paragraph, the HDAFU Tables are based on odds as near to the close of the ante post market as possible. In other words, within the last hour before kick-off, but mostly within the last five minutes before kick-off.

The optimum betting time is therefore within the last hour before the commencement of any match. Try and get it closer if you can (preferably within the last 15 minutes).

If you read the comments sections in all the HDAFU Tables’ articles, you will see that we do advocate the placement of some bets far longer in advance of the kick-off time, but only on games where we have a good idea of how the market is likely to move.

This is particularly the case with odds that are buried in the middle of the two inflection points, and are likely to remain so for the duration of the ante post period.

We can also take a chance with home teams/favourites that are likely to drift in (i.e. reduce in price). If they drift too far and outside the lower inflection point, we can always lay these situations with an exchange and achieve a second revenue stream in the form of arbitrage.

Attaining these special skills is all about knowing how and why the market prices move. To teach yourself this, you will need to observe price fluctuations in games over the whole of the ante post period.

With time, you will begin to see patterns – each league is slightly different according to its popularity and the weight of money placed by punters. Each bookmaker will follow one of three basic strategies in order to achieve its desired market share, and so on.

What I am saying is that it is possible to anticipate price movements in the market, and this is true of any ‘enclosed’ market with indentifiable boundaries such as football betting. It’s a small pond affected purely by supply and demand based around either two (e.g. yes or no) or three (e.g. 1-X-2) outcomes.

With bookmakers controlling the prices based on demand and their ability to supply, things are far easier to predict than something like the stock market where prices are determined by what people are prepared to pay for something at any given point in time.

Another big difference that makes bookmakers more predictable is the fact that the market is time limited (unlike stocks and shares, where only the IPO, the initial public offering of shares, has a limit – i.e. the length of time taken to fill the IPO).

The bookmaking industry is therefore more similar to the way insurance is transacted than to the vast ocean of unpredictable stocks and shares trading, which, I would also say, carries far greater risks and uncertainties.

Regarding your comment about odds jumping in extreme amounts, I would say that things tend to settle down more in the last 15 minutes before kick-off. Any bookmaker jumping around by 10 ticks or more (using your example), is likely to be desperate for market share in an attempt to address an imbalance in its book. Ignore these outliers as they are usually not representative of the market opinion at the time.

Whatever you decide to do, make sure you enforce the decision entirely. In other words, make a plan and stick to it. You are more likely to succeed doing this than treating every situation on its own merits.

The word ‘luck’ only comes into the equation when the end result turns out better (or worse!) than that to be expected from our own extensive set of skills.

When this happens, we can say that in spite of our skills-set and all the hard work and time that went into creating our understanding of the job, the end-result was better than expected – this is definitely ‘good luck’ in operation. However, you still need the cake in place before you can receive any icing that is likely to come your way…

Successful betting is all about hard work. It’s an evolutionary process, and if you are prepared never to give up learning, then you will become better and better at it. Learning is the key to life on earth. Once you give up learning and adpating to your situation, you become extinct.

Rado, I hope all of this helps in some small way! Thanks for your time and trouble in commenting again.

48. Mark
6 October 2017 at 5:50 am #

Hi I’ve finally been able to go through your new table and explanation on Paraguay but I have 2 questions and I can’t seem to find the answers above. Firstly you mentioned that you should only choose the best option in each league. i.e. Away win has 2 odds clusters and you mentioned you should only choose one and not both. What about if say you had Draw and Underdog both meeting all parameters, would you include both or choose the best of the 2 so you’re only following one option per league?

Secondly, you have many tables available now. If you purchase all the leagues, what bank would you recommend? Above I noticed some people mention they’re betting 5% which converts to a 20-unit bank while you mentioned your study was with 2500 euros and betting 100 euro fixed bets (or a 25-unit bank). However you mentioned that you should look for an ELS of less than 20 in the historical results. That means you would blow your bank if you had a run of 20 losses and were betting 5% of your bank. I recall reading somewhere on your blog some time back that you should bet ELS x 5 which means in this case you should have a 100-unit bank. I think you actually showed it in a formula.