ende

How to Calculate Average Odds in Football Betting


Sometimes it is necessary to figure out the average odds from a set of betting odds which can then be used as the basis for further calculations. For example, computing deviation and variance.

When using odds in European format (decimal) you can be forgiven for thinking that average betting odds are simply computed by building the arithmetic mean of the data to be analysed. Unfortunately, this is the wrong approach and leads to a deceptive result.

Man with calculator sunk into a heap of paperImage: Elnur (Shutterstock)

As a reminder, European odds are calculated as the reciprocal of the statistical probabilities of each event:

probabilities to odds

and vice versa … The implied probabilities are the reciprocals of the odds:

odds to probabilities

In effect, European odds are ratios/relations representing the likelihood of an event happening in comparison to each other event (e.g. a bet priced at odds of 4.0 is half as likely to win as a bet with odds of 2.0).

If these ratios are averaged using arithmetic mean (a common error), high data points are given greater weights than low data points. (e.g. working out the arithmetic mean of a set of 20 odds, 19 of them between 2.0 and 2.4, would be skewed if the 20th figure was, say, 15.0).

The correct approach is to calculate average odds by forming the harmonic mean!

The harmonic mean is defined as the reciprocal of the arithmetic mean of the reciprocals of x1, x2, …, xn (the odds):

harmonic mean resiprocals

As the reciprocals of betting odds are the implied probabilities of the events, one can calculate the harmonic mean as a reciprocal of the average probability of the respective bets:

harmonic mean reciprocals of probabilities

The above equations rearranged facilitates the harmonic mean calculation by dividing n (the number of matches) by the sum of the reciprocals of the odds:

Harmonic Mean equation

Or alternatively… dividing n (the number of matches) by the sum of their individual probabilities:

Harmonic Mean equation with probabilities

The Result (Harmonic Mean) is the Accurate Average of the Betting Odds.

Excel users employ the following formula: =HARMEAN(number1,number2,…)


learn to think like a bookmaker!
deciphering bookmaker mathematics

Last Update: 30 January 2014

Categories:Odds Calculation Value Betting Academy



13 Responses to “How to Calculate Average Odds in Football Betting”

  1. Bob
    9 March 2013 at 8:02 pm #

    Very interesting. Could one also use a geometric mean? My school maths is rusty but doesn’t a geometric mean provide a “typical value”, while a harmonic mean leans towards smaller figures in the set at the expense of larger ones?

    • Soccerwidow
      10 March 2013 at 6:36 am #

      The geometric mean is used for describing proportional growth, e.g. in business the geometric mean of growth rates is known as the compound annual growth rate (CAGR). In betting, the geometric means calculates the growth rate of success (profits/losses).

      I’m in the process of writing an educational paper on this so keep looking…

  2. Goran
    12 March 2013 at 1:13 pm #

    Hi there,

    Anyone that know where to find the following Calculator:

    1) giving input in the form of odd for Over / under 2,5 & the odd for 1,X,2 outcome.

    Giving estimated fair odd for ALL result from 0-0 to 9-9,

    Thanks in the advance

    • Soccerwidow
      12 March 2013 at 7:27 pm #

      Hi Goran,

      it’s unfortunately not that easy.

      However, here is a link to a calculator which will give you some probabilities if you put in the goal averages home & away: http://www.winnergambling.com/sports-betting-bingo/correct-score-betting-alculator/

      • Froment
        25 April 2013 at 7:24 am #

        Thanks for the link, Soccerwidow; unfortunatelly, it seems to be just simple Poisson distribution, that could be easily done in Excel as well, and is known as not really accurate, so nothing special…

  3. Betevo
    18 April 2013 at 11:09 am #

    Hi Soccerwidow,

    Do you have any idea of how the over/under of a soccer match is priced please?

    I do not think that it is automatically extracted from the 1×2 right ?

    Thanks in advance.

  4. Will
    23 April 2013 at 9:43 pm #

    Very interesting article indeed. Would you use harmonic mean average if you we’re say calculating the average shots or corners taken by a given team over the season ?

    • Soccerwidow
      24 April 2013 at 6:04 am #

      Shots and corners are countable variables; they can be sorted into a natural order and possess a zero point. Therefore, these variables belong to the ratio scale, and for calculating of the average the ‘normal’ average mean is being used. Harmonic and geometric mean are pretty meaningless for this kind of variables.

      You may find this article useful: Correct Assignment of Football Data to Levels of Measurement

  5. Aussiebettor
    26 April 2013 at 5:36 am #

    Hi,

    When averaging the two zero odds for a home and away team in your over/under course, you use the arithmetic mean rather than the harmonic mean. In your example of U4.5 in the Wolfsburg v Bayern match the numbers are 1.16 & 1.24 so both averages come out quite close to 1.2

    However, looking at U 2.5 in the same tables, using odds of 2 & 3 you get a arithmetic avg of 2.5 and harmonic of 2.4 which could potentially alter a decision as to value in the bet.

    Could you please confirm which is correct and why?

    Many thanks!

    • Soccerwidow
      26 April 2013 at 7:05 am #

      Hi Aussiebettor, I think you found an error in the course which needs to be amended. Using the harmonic mean for building average odds is correct.

      Anyway, the course is due for review, and I will attend to it.

  6. sarkec
    30 September 2016 at 3:54 pm #

    Hello Soccerwidow!

    Can you tell me please, how are the Asian Handicap markets calculated?

    Thanks,

    • Soccerwidow
      1 October 2016 at 2:09 pm #

      Hi sarkec, ASH calculation is going to be a whole course, much more massive than the OU course. It’s a very tricky calculation. Cannot be explained in few words. Sorry.

Leave a Reply / Comment