Sports Fixtures Generator

In this post we see how to use Excel VBA to generate fixtures for any sports competition. We use the round robin model and rotation algorithm to create either single or double robin schedules. As an example, we generate fixtures for a fictional schedule of the Spanish football premier league (La Liga). Note that professional leagues need to take into consideration additional factors to create the schedule. We will first start by learning how to obtain all possible combinations of two elements (two teams or players) from a list of n total elements. That´s achieved with a simple macro. Then we´ll implement the round robin method and rotation algorithm to create fixtures in Excel (for both single and double round robin schedules).

Betting Odds Calculator

In previous posts we saw how to predict the outcome of sports events such as football (Football Predictions Overview and Football Predictions with Poisson Distribution) or basketball (Basketball Predictions Overview). Sports betting is a fun option to test those models, and as long practiced in a “healthy” manner, is an additional form of entertainment for sports lovers. Bookmakers allow placing bets on sports events and pay out the winnings. They offer betting lines with agreed-upon odds figures that translate in both probability of the outcome and payout for a winning bet. In this article we will see what’s the relationship between odds and probability. Furthermore, we will explore the different formats bookmakers use to show odds and learn how to convert from one to another in Excel.