Sunday, 14 February 2016

Cricket teams and the efficient frontier

Cricket and financial markets have a rich, intertwined history, from Vincent back to Waugh/Warne, Lillee/Marsh and Keith Miller. So, I don't think we necessarily need a new cricket market, but let's make one anyway, and refresh my financial maths and linear algebra at the same time.

Cricket, especially its shortened forms, is seemingly becoming a batsman's game. Bats are bigger, fields are smaller, fielding and bowling restrictions make it difficult to pressure the batsmen, players are fitter and the game is more professional than it has ever been. The trend towards bigger scores is shown clearly in men's One-day International (ODI) cricket. The following chart shows the yearly average score each team scored when batting first in an ODI*, with the black line (ODIAll) being the average of all games in that year. The "Associate" line refers to Associate cricket teams that played games the International Cricket Council (ICC) deemed worthy enough to have ODI status, and also those World XI, Asia XI and Africa XI matches that were in vogue about 10 years ago and were also given ODI status. Individual Associate nations did not play enough games to create enough meaningful data for this analysis.

*Only innings that went for 50-overs, or where the team was bowled out, were counted so as to take out the influence of rain.

In our financial market, each of the series above is a stock, whose value is that team's average ODI score batting first in that year. The ODIAll series is the index for this particular stock market (like the S&P 500 or All Ordinaries). The upward trend in ODIAll is clear, and the following shows ODIAll data with an exponential fit. An exponential fit is what you would expect if the stock was growing with continuously compounding interest. The fit is pretty good (R2 = 0.8). The other dots are the country data and show the scatter (and noise) in the data set. I've gone back to 1980, as before then there were few games played annually.

Such trends are evident in other sports, but not all sports are as focused on increasing scores. Premier League football shows no such scoring trend, total home runs in Major League Baseball ebbs and flows depending on a number of factors including the amount of steroids being taken, but there has been a steady increase in strike outs over the last 20 years.

Let's do some maths. What we want to do is determine in which teams we should invest. We don't necessarily want to invest in the teams that regularly produce the highest scores. We want to pick the teams that are improving - that is, their stock prices are going up so we'll get a good return. For instance, Australia has been dominant in ODI cricket for some time; it may not be a good investment if it can not continue to grow its already large yearly average. On the other hand, Associate teams are playing more ODI cricket and Bangladesh is ever improving, perhaps they would be better investments, although likely to be more risky than an established team. Maybe we'd be better off just buying the ODIAll Index.

Inline with Modern Portfolio Theory, I used the methods in these two articles:
Yes, I did it in Excel, and yes I realise that if I was any sort of data analyst I would have done it in R, but if you can't go 80% of the way towards solving the problem in Excel, it's not a problem worth solving.

The following chart shows the average percentage return and standard deviation of each country's yearly stock price. On average, Australia increases its price by ~1%, with a standard deviation (risk) of 8%. Interestingly, South Africa, for a similar risk, has a ~2% return. Bangladesh is the BRIC of this market, rapidly improving over the last few years, but with a relatively high risk. The Associates are far too risky to invest in just yet. 
To determine your portfolio, you don't just need the risk/return values, but we also need to know whether an increase in one country's stock will cause an increase (or decrease) in another. This is measured by covariance. In our case, the prices of all countries are generally moving upwards over time, however there are some interesting pairs of countries that move together in the same direction (Sri Lanka and New Zealand) and in the opposite direction (Zimbabwe and Bangladesh). I suspect a lot of this is noise. In any case, by knowing that an increase in one stock price will likely see a decrease in another, you can minimise the overall risk of your portfolio by hedging.

To determine which teams we should include in our portfolio, we need to determine the Efficient Frontier. This is the line on which you can not get a higher return from any combination of assets in your portfolio for your choice of risk. For example, if you are happy to take on a risk of 20%, you can't expect a return more than 8% from these assets - yes, it's not exactly the sort of market I'd want to buy into, but let's keep going...

The next thing we need is the Capital Market Line (CML). In any market, there may be what is known as a "risk-free asset" - an asset which gives a guaranteed return with no risk. In financial modelling, government bonds assume the role of risk-free asset, as they have a known return and as the government has almost zero chance of default, are assumed risk-free. The CML is the line drawn from the point of the risk-free asset (on the y-axis) such that it is tangent to the efficient frontier. The intercept point is known as the market portfolio. Along the CML, your portfolio contains various amounts of the risk-free asset and the market portfolio (the risky asset).

There is no real equivalent to a risk-free asset in this market, so I've assumed it to be 0.5%, which is, at time of writing, about the price of a German 10-year government bond (this market is based in Germany, for no particularly good reason. Perhaps a German financier, tired of his team being ranked between Gibraltar and the Isle of Man, wanted some fun).

The market portfolio allows you to short sell; that is, sell stock you don't currently own. Perhaps you've borrowed it and sold it on. But you have to buy it back to give it back to the person from whom you borrowed it. You'd do this if you were expecting the price to drop so you would be buying it back at a lower price than you sold it, or as in our scenario, as a hedge. You can also determine the optimal portfolio if short-selling is not allowed, and the minimum risk portfolio. The weightings are below. Essentially, if you don't mind a bit of risk, buy Bangladesh and South Africa. If you want a bit more safety, replace Bangladesh with Australia.

Market Portfolio No short selling Minimum Risk Portfolio
Australia -0.09 0.01 0.26
England -0.18 0.00 0.00
New Zealand 0.10 0.06 0.00
India 0.03 0.00 0.10
Pakistan 0.11 0.05 0.07
West Indies 0.00 0.00 0.09
South Africa 0.44 0.35 0.23
Sri Lanka -0.04 0.00 0.07
Zimbabwe 0.20 0.16 0.09
Bangladesh 0.42 0.36 0.09
Associate 0.00 0.01 0.00

How are these portfolios going in 2016 (at Feb 14)? Well, noting that some of the teams have yet to play this year (so I have assumed they have a 0% return), if you'd bought the ODIAll index, you'd be up 7%, the minimum risk portfolio is down 0.9%, the no-short-selling portfolio is down 7.6% and the market portfolio is down 13.1%. This is inline with the amount of risk in each portfolio, but not a good result. Still, the year is young.

Would I ever use this technique to develop a portfolio for such a market? I don't think so. This method weights a team's return from 1981 to 1982 the same as the 2009 to 2010 return. In cricket, I suspect you need to look recent form as opposed to historic, and be more specific with regards who each team is playing, and where. There's probably not enough data for the correlations and covariances to really mean anything either.

Can the ODIAll Index continue to increase? This market is much like a real financial market - you can not expand forever in a world of limited resources. It has to come to an end at some point. There are ways, however, that teams could attempt to increase their own prices in the short-term. Australia, which has traditionally been very poor at playing nations it doesn't deem good enough to take the field with, could actually start to play some games against Bangladesh, Zimbabwe and the Associates; the financial markets analogy would be a company outsourcing its manufacturing to countries where they don't pay their workers well. This approach would not necessarily work for teams like India and Sri Lanka, who have been plundering week bowling attacks and bolstering their averages for some time. But at least they are attempting to grow the game, perhaps cognisant of the fact that for long periods of time they were also not particularly good (some Australia, as a foundation Test nation, never really had to think about). It will be interesting to see if India continues to do this as they take over the ICC. The Big 3 would do well to remember that they are big because of the international market and that it should be nurtured. To the (previous)-ICC's credit, the international ODI market has liberalised since around 2005, with more countries playing games with ODI status. However, it remains to be seen whether you'll ever be able to buy stock in individual Associate nations in our market.

Many things could influence this market in the future. How regulated is it going to become? Will the number of nations playing ODIs grow or shrink? Where will technology trend, what rule changes are going to come in? Or will ODI cricket die in the face of T20 cricket?


  1. Why was 2004 such a bad year for Associate ODI scores? Was their an influx of teams granted status and/or an increase in the number of Associates playing Full Members?

    1. It was a really dud year - in only 2 games did Associates bat first. Kenya got 94 vs Pakistan, and USA got 65 vs Australia - Champions Trophy games.

      There were a few other games where Associates played but they batted second - lost all - not a good year for Associates. There were also no games amoung themselves, which would normally be higher scoring.

      It shows 2 limitations of this method - not much data in this year, and who you play really matters.

    2. I am able to tell them I am aware of what they're doing agen bola bonus 100. I would absolutely suggest them on your next upkeep!


  2. As I website possessor I think the articles here is very good, thanks for your efforts.

    Random Email Generator
    Black light app

  3. Thanks a lot for the kind of perfect topic I have not a lot of information about it but I have got an extra unique info in your unique post. Perfect description you have provided thanks for sharing. Latest eu4 console commands and gta san andreas cheats pc .

  4. The way everything is presented through the graph is great. Sure enough, after 4 years, changes is inevitable.

    URL: Our company

  5. Democrats are hoping Obama’s appeal, especially among Black and younger voters, can help boost energy for Joe Biden 2020 Shirts.

  6. For the NFC West, the player of the decade was none other than defensive tackle Aaron Donald. He was joined by 49ers vs Cardinals Live Free

  7. Golf officials on both sides of the Atlantic are expected to make an official statement on the plan for the Watch Ryder Cup 2020 Live at some point this week.

  8. The Bears–Lions rivalry is a National Football League (NFL) rivalry between the Chicago Bears and Lions vs Bears Live Stream Detroit Lions. The franchises first met in 1930 when the Lions were known as the Portsmouth Spartans and based in Portsmouth, Ohio. They moved to Detroit for the 1934 season.

  9. So far, a decision on where the Watch NRL Grand Final Online will be played is yet to be reached and could all depend on whether crowd restrictions would be lifted in time.


  10. How To Watch UFC 253 Live Stream Online | You can Watch UFC 253 Khabib vs Gaethje Live free 253 UFC Live Stream Free worldwide online TV The UFC 253 Live Stream have no affirmed they go to profit to the 253 UFC Ireland for Saturday Presumption . UFC Senior bad habit director , Global …

  11. Official page of the Zwift Virtual Tour de France 2020. Watch live streams of the men's and women's race and view team standings and information.Alaphilippe recons Tour de France climbs in French Alps ... The route of the 2020 Tour looks well suited to Alaphilippe's characteristics as a Tour de France 2020 Live Stream ...The 2020 Tour de France route will suit the pure climbers of the peloton. Team Ineos are expected to line up with three main contenders in defending champion ...

  12. The Los Angeles Chargers host the Cincinnati Bengals on Sunday for a Week 14 matchup Chargers vs Bengals Game Live Stream Online as they try to keep pace with the Kansas City Chiefs and New ... Los Angeles Chargers vs Cincinnati Bengals: Score updates, TV channel, how ... Watch online: You can watch the live stream of the game on ...

  13. CBS is a popular channel and you can get the channel if you have cables or satellite in your home or in your office. It is one of the most popular channels and you are going to like it because of the fact that the channel is very clear and you can have access to them from many parts of the country.The most popular of the streaming options are Sling television. Sling is great because Watch Dolphins vs Patriots 2020 Live Stream Online they offer a lot of sports channels and one of the sports channels that you can receive from them is CBS. The

  14. The Tour has some interviews already done ahead of time, so these will be woven into the story of the race – just like they do for real regarder Tour de France 2020 en direct races.

  15. Jonathan Brown says Queensland deserves to host the Watch AFL Grand Final 2020 Live due to the significant role they’ve played in keeping the current season alive.

  16. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon. Today I found a great article on the internet ( windows 7 ultimate 64 bit product key )

  17. The starting point to the Bears’ offense in 2020 is, certainly, figuring out who’s playing quarterback. Lions vs Bears Football Game Live Streaming But the Bears need Jimmy Graham, Cole Kmet and Demetrius Harris to be the fixes their tight end room sorely needs. Just average play from those guys will help the Bears’ offense be closer to what it was in 2018 (which, again, was merely good enough), if not better.

  18. Those who argue that the Ravens are going to win because they are well prepared and this means that Cleveland Browns vs Baltimore Ravens 2020 Live Stream Free they assembled the best players. It does not mean that the Baltimore boys are not prepared.

  19. Carolina Panthers-Oakland Raiders Tickets. Fans of the National Las Vegas Raiders vs Carolina Panthers Live Stream Free Football League know that seeing a game in person is the only way to catch the best games.

  20. Kodak Presidents Cup T20 Live Score, Kodak Presidents Cup Live Scorecard, Kodak Presidents Cup T20 Live Streaming, Kodak Presidents Cup T20 Match Results, Kodak Presidents Cup T20 Points Table - Kerala Cricket Association (KCA) Regional Domestic Cricket Live Cricket Score & Kodak Presidents Cup T20 Live Match Prediction Live Streaming and Match Highlight with myfinal11 – Total of fours teams participating in this league and start from 06 - 23 March 2021 as per Cricket schedule and here we will provide you live cricket score of Kodak Presidents Cup T20 Live matches with daily match prediction Dream11 Fantasy Cricket Team

  21. To know more about Chief Dr Lucky you can visit his website (
     A friend that suffered from Herpes and was cure with the help of this great herbal doctor Chief Lucky so i decided to contact him for help in getting rid of my families genital herpes virus 1/2 which i did and all i was told to provide was just some useful information and some materials used in preparation of the natural cure and that i did and now i am the happiest person on earth because i am writing this testimony of mine with joy and happiness in my heart to the whole world to know that natural remedy is real because i am a living testimony of Chief Lucky traditional herbal cure and i want you all to contact Chief Lucky via his email: or WhatsApp him +2348132777335 am sure he will help you too.

  22. Thanks for sharing this knowledgeable post. What an excellent post and outstanding article. Thanks for your awesome topic . Really I got very valuable information here. If you want to Change Roadrunner Email Password then please contact with our award-winning team of Technical Services.

  23. No matter where you are, you will be having fun with your hordes enjoying the Ryder Cup right from your favorite screens. What you need to prepare are only your compatible device and a decent internet connection. There have been a significant number of viewers around the world who enjoy this ryder cup live stream free. Because of the high demand, it is fair to see that there are a lot of options that you can consider to watch ryder cup live stream. Just like any other big event, the viewers come from many countries around the world. Although the event will take place in United States, it is an international event, which is fair that the viewers are not only coming from the specific countries.

  24. Wow, it was really a great news about the world of Cricket. I use to watch Cricket on my YouTube TV Discounted, Thanks a lot for sharing it!

  25. Put more information on your website like this one, I really like these types of blogs. I am really very happy to visit your blog. Now I am found which I actually want.
    geophysical service
    seismic equipment for sale