AFL Prediction & Analysis

All I Want for Christmas is an AFL API

If you want to do your own football analysis today – write an article, create a chart, build a neat online tool – you can’t legitimately acquire the most basic stats about AFL matches, not even the scores.

You can manually browse to a website and eyeball the scores. But these pages have Terms of Use that prohibit any downloading or reuse of content, like this one linked from AFL.com.au:

The Copyright Act 1968 (Cth) protects materials such as films, music, books and computer programs. You can break the law if you download, copy, share or distribute this material, unless you’re allowed to do so by the Copyright Act or you have the copyright owner’s permission. Please don’t use our services to do any of these things, because if you do, we might have to cancel your services (including your email count) and the copyright owner could take legal action against you.

In practice, small operators – armchair analysts and independent sites – either laboriously compile these stats themselves, or else ignore the Terms of Use and write programs to download them from somewhere else anyway. Not everyone can do this, though, and for those who can, it can be tedious and time-consuming, as whenever the website updates its format, the scraper stops working or begins pulling corrupt data. And sometimes the source just plain disappears.

The AFL could and should create an API: a simple online interface that publicly serves up very basic football data such as match scores in a computer-readable format. It could do this simply, cheaply, and without exposing any advanced stats that Champion Data rightly consider to be proprietary and valuable.

This would:

  1. Dramatically lower the barrier to entry for anyone with an interest in building something on top of football stats, allowing them to get started with a bunch of basic, legal data.
  2. Signal an interest in and acknowledgment of the growing amateur/semi-pro analytics community and its audience.
  3. Grant the AFL some control over what’s happening. At the moment, it has a fence around every single piece of data, a bunch of tunnels going underneath, and no idea who’s digging them or why. If it added a gate to the fence, many people would use it, because gates are easier.

Today there are excellent free APIs for practically all major world sports, except AFL. There are dozens for cricket and rugby, and hundreds for soccer. In the US, you can’t move for tripping over a baseball, basketball, or football API. But for AFL: nothing.

Regardless of where you land in the wider debate over exactly which stats should or shouldn’t be kept secret, surely no-one is being served when basic match scores are kept under legal lock and key. Fixing this could create a platform for analytics innovation, discussion, and expansion.

Please, Santa?

The Squigglies 2019: Home & Away

With the home & away season tucked away, it’s time to look back and see whether all those preseason predictions that were floating around earlier in the year turned out to be prescient… or putrid.

It’s time for the Squigglies 2019! (Home & Away edition)

Every Expert Preseason Ladder Rated

Best Ladder Prediction: AFL Lab

Head and shoulders above the rest, AFL Lab correctly tipped Geelong for the minor premiership and Sydney to finish bottom 4. It was one of few ladders to resist the temptation to fit Adelaide into the Top 8. While, like every ladder, it had Melbourne much too high (3rd) and Brisbane much too low (12th), it is otherwise excellent, with no fewer than 13 teams tipped within 1 rung of their actual position. Score: 71.5

Runner-up: HPN Footy (68.3)

Best Ladder by a Human: Paul Bastin

In March, AFL.com.au gushed forth ladder predictions from no fewer than 15 journos. One of them was the only prediction to squeeze a computer model out of the top 5: Paul Bastin’s. Paul was bullish on Brisbane (8th) and bearish on Sydney (14th), but done in by his faith in Adelaide (3rd) and lack thereof in the Bulldogs (15th). Score: 67.7

Runner-up: Nat Edwards (65.5)

Best Ladder by a Crowd: AFL.com.au readers

A few media outlets ran preseason fan surveys, drawing on the wisdom of the crowd to compile ladder predictions. Some crowds were more prescient than others. The best was from AFL.com.au, which finished 6th overall, beating out every single expert from the media but Paul Bastin. Score: 66.7

Of other crowd-sourced predictions, The Roar and The Age were also better than most pundits. Reddit r/AFL’s attempt, however, was only marginally better than taking the 2018 ladder and guessing it would be the same again.

Runner-up: The Roar readers (63.3)

Worst Ladder: Damien Barrett

Look, predicting the ladder is hard. It makes fools of us all. Unfortunately, someone has to be last, and this year it’s Damien Barrett, who tipped Adelaide for the minor premiership and Fremantle to storm into finals, alongside Sydney and Melbourne. Damien didn’t have enough faith in Brisbane (15th) or the Bulldogs (14th), and expected Geelong to slide out of finals contention. With only one of the top four correct (Richmond), half of the top eight missing, and ten teams wrong by three or more rungs, it’s a shocker. Score: 50.4

Every Expert Preseason Ladder Rated

How to Predict the Ladder in Nine Stupid Steps

You’re an intelligent person, probably, with opinions about football teams. Occasionally you might want to employ those qualities to predict what the ladder will look like at the end of the year.

So how, exactly, does someone do that? What is the ideal process?

The answer, my friend, is a journey through madness and despair. The first step is stupid, yet with each successive step, it somehow gets worse.

Let me walk you through it.

Step 1: Eyeball the teams and guess

Sure. Anyone can do that. Your ladder looks reasonable, but you’re not even properly considering the fixture. What about teams that have an easy or hard run home?

Step 2: Go through the fixture and manually tip all the games

There we go. You have now accounted for fixture bias. And you have a ladder with… wait, Geelong on 20 wins. They’re good, but that seems ambitious. How did that happen?

Oh, of course! You didn’t tip upsets. In reality, favourites lose about 30% of the time.

Step 3: Throw in a few upsets

Now things look more realistic. Geelong have 16.5 wins. You threw in a draw because you couldn’t bring yourself to say they’d lose to Sydney. You don’t actually expect that game to be a draw, of course. In fact, you don’t really expect most of your upsets to come true. That’s why they’re upsets: they’re unlikely by definition.

So… now your ladder is based on results even you don’t believe in. Uh.

Step 4: Calculate expected wins

All right. Time to piss off the ladder predictor and get serious. What you’re doing now is going through each game and awarding a percentage of a win to each team based on how likely it is. Collingwood are a 60% chance to beat North Melbourne, so that’s 0.6 wins to the Pies and 0.4 wins to North.

This is better. You’ve successfully accounted for the likelihood of upsets, without having to guess exactly when they will occur. You just averaged the possibility of them over the course of the season. Smart.

So let’s see. You now have Collingwood on 14.2 wins total, and right behind them, GWS on 14.1 with a much healthier percentage. Hmm. So you’re basically forecasting each team to win 14 games, and for GWS to have a better percentage, but for the Pies to finish above them.

Shit.

Step 5: Round those fuckers off

No-one wins 14.2 games! You can’t win a fraction of a game! What your number really means is that Collingwood will win about 14 games while leaning toward more rather than fewer. So if you round everything off, it works. Collingwood: 14 wins. GWS: 14 wins. Percentage comes into play. GWS go higher. Done.

Except… further down there’s North Melbourne on 10.5 wins and Essendon on 10.4. They’re almost identical, but you have to round them in different directions. That puts North one whole win ahead of Essendon. Well, that’s probably still okay. I mean, they’re still in the right order. And your numbers really do have North closer to 11 and Essendon closer to 10. So they’re rounded. Moving on.

Next is Fremantle on 9.5 wins with a better percentage than Essendon. So… the Dockers… also… round to… 10 wins… and move above the Bombers.

Now the rounding is messing with the order. You originally calculated that Essendon and North are in close competition with Fremantle a game behind, but after rounding, you’re putting North clearly ahead with Essendon third of the bunch. That’s not great.

And that’s not all! Look at the shit that transpires when there are two rounds to go! At that point, it’s logically impossible for certain teams to finish in certain spots, because of who plays whom, but your fractional wins are putting them in those spots anyway! What the fuck!

Step 6: Simulate games

You know what you need? A FUCKING COMPUTER. You can’t do all this shit on paper and spreadsheets. You need to write a GOD DAMN PROGRAM to run through every single game and roll a die or whatever a computer does to pick a random number. Then, because it can calculate footy stats all day and not get asked to take the dog for a walk or fix the wobbly chair, it can do that TENS OF THOUSANDS OF TIMES.

All right. All right. You now have a simulation that can figure out the likelihood that percentage comes into play when deciding ladder positions. You still have to average out finish placings, so have the same issue with occasionally tipping logically impossible placings. Is mode better than mean here? Who knows. It’s an improvement. Moving on.

Wait. Some numbers seem a bit wacky. There might be a bug or two in those hundreds of lines of code you just wrote. Yep. Go fix those.

And while you’re poking around, ask yourself: Does the language you used employ a half-arsed random number generator that prioritizes speed over correctness, which completely falls apart when you call it forty thousand times per minute? Well shit! Yes it does! Now you’re reading the documentation, you see that for actual randomness, you need to use a special module with an interface written in Russian! And don’t forget to ensure your machine has an adequate source of entropy! What the hell is entropy? Where do I get that from? The entropy shop?

Step 7: Fix bugs and supply adequate entropy

This simulator seems pretty damn sure of itself, you have to say. You fixed its bugs and gave it all the entropy it could desire, but this thing insists there’s no way a low-ranked team could ever make a late run for the finals. It’s guaranteeing Geelong top spot even though they’re only two games ahead with half a season to play.

It’s overconfident. It’s treating each match as an independent random event, but you know that if Fyfe’s knee blows out, Fremantle’s results will start looking pretty goddamn dependent. You need to simulate the chance that each team can get fundamentally better or worse as the season progresses. How do you do that? Oh, the experts disagree. Super, super.

Step 8: Simulate seasonal changes in fundamental team ratings

You did it. You created a full-bore simulator made from belted-together hunks of stolen code and occasionally you discover a horrifyingly fundamental bug but god damn it, it works. It mostly works.

Of course, you had to make a lot of design decisions along the way. You’re maybe not a hundred percent confident in all of those choices. To test them, you need to run this thing against real-world results, a lot of them. Like decades’ worth. And that requires a method of scoring your ladders’ accuracy. Hmm. There are several different ways of doing that. They’re all complicated.

Step 9: Revise model based on score against large data sample

I’m not sure what happens after this. I’m sure it’s something. This is as far as I’ve made it.

At this point, you can pause, reflect on your efforts, and observe that your ladder predictions are often outperformed by random BigFooty posters employing the eyeball-and-guess method.

God damn it.

Squiggle Ladder Predictor: Predict the final ladder!

Rate My Ladder: Score your prediction!

When You Should Bet

I have an AFL analytics site, and since football and betting have become so intertwined it can be hard to tell where one stops and the other begins, people sometimes ask me whether they should bet.

I’ve found it hard to give a short answer, so instead I prepared this handy guide.

Photo: Michael Coghlan

Here are circumstances in which I think it’s a good idea to bet:

  • You have a terminal disease and nothing better to do with your money. The Great Beyond looms; you have no energy for rock-climbing or international travel; you hate your children; so maybe you can, even for a few moments, feel a connection to the spark at the heart of the universe by plonking down some cash on Martin to kick the first goal. If you lose, well, you were in a bad mood anyway. Because of the terminal disease.
  • You have inside information. I think it’s definitely easier to have inside information than be consistently smarter than everyone else in the market, so this strikes me as a good way to go. You do have to be careful not to, you know, get mixed up in organized crime. I’m not saying it’s completely risk-free. But if you can get yourself a steady source of exclusive information that’s timely, relevant and reliable, you should be able to beat the market more often than not. So if that’s your situation, I say go for it.
  • You enjoy losing money. I’m not sure this is a common scenario. But I want this to be a comprehensive document. You are normally guaranteed to lose money if you bet long enough, so this would be a good strategy for you.
  • You have located a stupid bookmaker. You shouldn’t expect this to last long, because other market players will also locate this stupid bookmaker and begin to exploit their stupid practices, thus sending the stupid bookmaker a strong signal to cease being stupid, e.g. by bankrupting them. But it certainly is possible to be profitable through information arbitrage, where you may know nothing about the actual sport but are able to efficiently exploit asymmetries in how different bookmakers engage with the market.
  • You are extremely smart, highly informed, equipped with an objective, evidence-based strategy that you intelligently supplement with personal insight, capable of dealing with extended periods of losses both financially and emotionally, and equipped with a thorough understanding of the myriad ways in which your human psyche will attempt to trick you into making bad decisions at the worst possible time. Congratulations, by the way. That’s really impressive. I do kind of wonder why you don’t apply yourself to something with a better risk/reward ratio, like, why are you gambling with your mortgage instead of pulling down high six figures from Citibank? But that’s your call. If you tick all these boxes, you should probably bet. You do have to tick them all, though. If you miss one, it will eat you.
Photo: Simon Yeo

On the flip side, here are some circumstances in which I think it’s a bad idea to bet:

  • You believe life is more predictable than it really is. This is everyone, by the way. It is something like 99% of people. If this surprises you, you are definitely one of those people. The human brain is excellent at detecting patterns in random noise, which used to be super helpful back when we were being stalked by jaguars, but today means we tend to wildly overrate the significance of Sydney losing their last three games at home. The universe is full of randomness that humans are bad at identifying. We don’t even like to acknowledge it’s there; we gravitate to stories with logical cause and effect. Those are illusions. It’s chaos out there.
  • Your emotional state depends on whether you win or lose bets. Holy shit, man. Get out of there. You know what you’re doing to yourself.
  • You struggle for status and respect in a heartless world and earn some by bragging about betting wins. I considered putting this in the “good reasons to bet” section, since at least you’re getting something out of it. Not money, obviously. But something of value to you. But it’s here because it’s still ultimately self-destructive and more costly than it first appears, like gambling in general.
  • You hear people talking up wins but not mentioning serious losses and think this means betting is a generally profitable pastime. It is not. You’re competing in one of the most ruthlessly efficient markets on Earth against people and companies who have been doing it for longer than you, with more capital, resources and information. The playing field is also tilted so that to be profitable you must outperform the average waged dollar — not the average bettor, mind you, the average dollar, bearing in mind that the market effectively strips out stupid dollars and inflates smart ones—and must also outperform it by a wide enough margin to beat the vig.
  • Similarly, you hear a lot of talk about betting and get the idea that everyone is doing it, at least occasionally. This is an illusion created by betting companies who wedge sponsorship dollars into every visible crevice — dollars they have because they take them from bettors. I’ve been approached three times in two years about putting betting material on this site, including one who offered to pay me only if I didn’t reveal I was being paid. Betting is not common; the vast majority of it is done by a minority of people.

So that’s my view. It mostly stems from respect for two powerful systems: the free market, which can be extraordinarily efficient, and human psychology, which is impressively terrible at discerning objective reality.

That’s a high bar to clear in order for you to be good at betting—as good as you are at, say, driving a garbage collection truck, for which you can reliably generate $26 per hour.

So I don’t bet. I don’t like the feeling of losing money (or even risking it); I don’t receive much emotional gratification from winning it, since I’m very aware of how big a factor luck is; I suspect I would lose my nerve after a period of heavy losses; I’m primarily interested in learning how football works, not beating bookmakers; and, most of all, I don’t think it can be done reliably over the long-term without an oversized investment of time and energy. And maybe not even then.

You may be different, in which case, I wish you all the best! You go live your life your way. But I’ll be buying index funds.

Who Won the Round?

When you come off a good win, you don’t just want to analyze how great you were compared to the other team; you want to see how great you were compared to ALL the other teams.

Sadly, it’s hard to establish objectively how much better (or worse) Richmond’s defeat of Hawthorn was to Collingwood’s thumping of St Kilda, for example, or any of the round’s other games.

Until now! Squiggle now offers an algorithmic ranking of who had the best round. Using data from the aggregate Projected Ladder, which brings together the predictions of many different excellent AFL prediction models, this determines how the weekend’s results impacted each team, by comparing how their predicted ladder finishes changed.

This is all based on pre-round expectations, so an upset win can be hugely meaningful for a team, radically improving its prospects of finishing higher on the ladder. Equally, a shock loss can be catastrophic, as the cold-hearted computer models begin shaving down its finals chances.

The importance of “eight-point games” is clearly visible, too, where teams that defeat an opponent competing for the same ladder spots are recognized both for advancing their own position and damaging their competitor’s.

To have an outstanding weekend outside of “eight-point games,” teams need to rely on other results falling fortuitously, so that teams around them lose, while teams too far above or below to matter win.

The current algorithm is a bit experimental, since it applies a weighting to decide the relative importance of changes in predicted ranks vs wins vs percentage. It also applies its own ideas in determining how much to scale these based on the predicted “closeness” of teams, and therefore who is competing with whom for which spots. So it’s currently in beta.

But I think it offers a pretty good map of the round, allowing a peek into the changing fortunes of each team, as prognosticated by the internet’s finest models.

The Aggregate Projected Ladder

In the same way that Squiggle Dials aggregate predictions from the internet’s best AFL computer models, so does the new auto-updating aggregate Projected Ladder!

As I write (post-Round 6), it looks like this:

There are some funny quirks to projected ladders, which are quite a bit weirder than they first appear. You can read some discussion of that at the bottom of that page, but the fundamental question is: What are we trying to predict? It’s not at all clear how we should rate the accuracy of a ladder prediction — for example, is it more valuable to correctly tip who finishes 1st than who finishes 12th? How much better? How do you score a ladder that gets the ranks right but had the number of wins all wrong, compared to one that was very close on wins but had some incorrect ranks?

It’s worth noting also that a ladder prediction is not the best way to answer questions like, “What are the chances that my team makes finals?” You can find those kinds of estimates from many Squiggle-friendly models, including FMI‘s Swarms, Graft‘s Projection Boxes and PlusSixOne‘s Finishing Positions. They aren’t aggregated here, but are better targeted to those kinds of questions.

In the background, the Projected Ladder is recording the ladder predictions of each contributing model, so in the future it should be possible to go back and see how they evolved. We could even score them on how accurate they were — once we establish what it is, exactly, that we want to score.

Speaking for myself, I’m pretty sure that my Live Squiggle ladder predictions are quite a lot less intelligent than my game tips, simply because there isn’t a clear way to rate it, which makes it more difficult to refine and improve. A standard metric of some kind would help.

If you’d like to play around with this data, it’s available in a machine-readable format via the Squiggle API!

Podcast: Chilling With Charlie

There’s a terrific new podcast on sports analytics available from Robert Nguyen, author of the site Analysis of AFL and co-creator of the very popular R data package fitzRoy.

All the episodes are worth your time, but this one features me talking about the torment of Richmond fans and the genesis of Squiggle:

You can find it on iTunes Podcasts by searching for “Chilling With Charlie,” or via this link.