Excel LADZ

Master Sports Betting with Monte Carlo Simulations!

G'day lads, download the MLS Excel file featured in my latest video below! 🔥

Note: I've "frozen" the 10,000 simulations in the file so that it doesn't lag. To re-run the simulations for new odds in the "Analysis" worksheet, delete the existing simulations and run the 'Data Table' like I did in the video after pressing the "Refresh All" icon to refresh the data (scores and results).

Please let me know if you have any questions about it. A 'Legacy' file, for tho...

Excel LADZ - Euro & Copa América 2024 Model

G'day lads! Attached to this post is a model that runs simulations to forecast the winners of the Euro and Copa América 2024 competitions, starting from the Round of 16.

The model uses ELO Ratings to give each team a Win % in a matchup. To refresh the ELO Ratings, select the 'Refresh All' icon in the 'Data' tab. This will update the file's connection to: https://www.eloratings.net

To use the model, select your nat...

Master Sports Betting with Monte Carlo Simulations!

G'day lads! My next video on YouTube will be an explanation of how you can use Monte Carlo simulations in Excel to compute probabilities for betting markets in Excel 🔥 I'm hoping this video will be filmed and released on YouTube within the next week.

Meanwhile, attached is the script and a model projecting the winner of MLS. The file does not have the accompanying 10,000 simulations as it would lag WAY too much. I froze the simulations by copying and pasting over the top, so that th...

Excel LADZ - Live Event!

G'day lads! I'm considering hosting a live event that would cover the basics of sports modelling in Excel... Let me know if you'd be interested! 🔥

Excel LADZ - Summer Football Model (MLS, J1 & Série A)

G'day lads! In this post I've added the MLS (United States), J1 League (Japan) and Série A (Brazil) to the Excel LADZ Poisson Football Model. To add more leagues to this file, follow the steps above in the video!

Attached are the models below. If you do not have access to array formulas in Excel, please download the "Legacy" file. Let me know if you have any questions lads! 🔥

Note: These models currently use data from a single season - the current one. As a r...

How to Use Excel LADZ 2024 MLB Lineup Model!

G'day lads! Attached is a video explaining how to use the attached Excel LADZ 2024 MLB Lineup Model. Please download the files below to use.

More information to come about this model; especially on the statistics used to build it (as well as future updates).

Let me know if you have any questions lads 🔥

Excel LADZ | 2024 MLB Lineup Model

G'day, lads!

I've created an MLB Model that uses daily lineups to project a team's xRuns in a matchup. This includes calculating the influence a side's pitcher and batting lineup have on their expected performance. The model (using array formulas) is attached below!

An article & video explaining how I built this model will be released shortly 👍

HOW TO USE

Attached are 2 files: 'Pitcher Model xRuns' and 'xRuns Simulation Model'.

The first ...

Excel LADZ - May 2024 Update

G’day, lads!

Football Model

Thank you all for watching my most recent video, ‘ANALYSE Football Matches for Win %, Over/Under and Correct Score Using EXCEL! | Tutorial’. The video has reached over 2,000 views in its first two weeks; a new channel record! 

Download this model here: https://www.patreon.com/posts/analyse-football-1...

ANALYSE Football Matches for Win %, Over/Under and Correct Score using EXCEL! | Tutorial

G'day lads!

I've put together a model that uses the live stats and the Poisson distribution to predict EPL, LaLiga, Ligue 1, Bundesliga and Seria A games. All in one dashboard!

Note: The 'Normal' uses array functions that are only available to Excel 2019 users and later. However, the 'Legacy' file should work for ALL versions of Excel 💪

Simply select a league in cell A3, select the matchup from the dropdown list in G1 & G3, and the results will popula...

Excel LADZ - European Football Model

G'day, lads! In the next week I'm looking to publish a YouTube video explaining how I built the 'Excel LADZ - European Football Model'. This model uses the Poisson Distribution to forecast the results of matches from the EPL, LaLiga, Ligue 1, Bundesliga and Serie A 🔥

There are two versions of the file: one with more efficient array formulas (Excel 2019 and later) and a 'Legacy' version (all users have access to these functions, e.g. VLOOKUP). Which version should I do the tutorial on...

Excel LADZ - European Football Model

G'day, lads

I've put together a model that uses the live stats and the Poisson distribution to predict EPL, LaLiga, Ligue 1, Bundesliga and Seria A games. All in one dashboard!

UPDATE: Both 'Normal' and 'Legacy' files have been uploaded! The 'Legacy' file should work for ALL versions of Excel 💪

Simply select a league in cell A3, select the matchup from the dropdown list in G1 & G3, and the results will populate. To update the data, go into the 'Data'...

How I Updated the Excel LADZ 2023 MLB Model

G’day lads! An essential part of sports modelling is being able to update a model to reflect current data. In this article, I’ll run you through how I updated the ‘Excel LADZ - 2023 MLB Model’ to be ready for the 2024 season.

JOIN the best Excel Sports Modelling Community by becoming a member of the Excel LADZ Patreon! Receive downloadable access to every model (including the Excel LADZ MLB Model) as well as technical posts, like this, which will improve your un...

Excel LADZ - 2024 MLB Model

G'day, lads

Attached is the Excel LADZ - 2024 MLB Model 🔥

An article explaining the changes I made will be published shortly 💪

Note: To update the data, go into the 'Data' tab and select the "Refresh All" icon. Wait for the simulations to refresh and the file to load completely.

Please don't hesitate to ask any questions you may have lads!

Excel LADZ - March Madness Model (2024)

G’day lads,

In this explanation I’ll go through how I built the ‘Excel LADZ - March Madness Model’ using ELO Ratings.

ELO Ratings

In order to build a simulation model, you need to be able to define the strength of each team prior to the game starting. 

Usually this would involve measuring each team’s Attacking (ATT) and Defending (DEF) strength so that an xPoints/xGoals figure can be calculated. However, this can be diffic...

Excel LADZ - AFL Model 2024

G'day lads,

Attached is the Excel LADZ - AFL Model 2024. I'll create an article soon with an explanation of how I made the model 👍 

To factor in individual players into the model, go into the 'SuperCoach Squads' worksheet where you can select the players for each team.

If you have any questions lads, please let me know 🙏 

Excel LADZ - NHL Model

G'day, lads

UPDATE: Due to a change in the Hockey Reference Power Query within the file, I've made a small change to the model. Teams that have qualifies for the Finals will now have an asterisk, *, next to their name.

Attached to this post is the Excel LADZ - NHL Model. Navigate to the 'Result' worksheet, where you can select the two teams for the match.

To Refresh the Data, go into the 'Data' tab and select the "Refresh All" icon. This wil...

Accounting For Player Strength - Alternative Methods

G’day lads! In the best sports models, the lineup of a team is considered. How you factor in changes to a lineup within a model is very important, and in this article I’ll give you some strategies!

JOIN the best Excel Sports Modelling Community by becoming an Official Member of the Excel LADZ Patreon! Receive downloadable access to every model as well as technical posts, like this, which will improve your understanding of sports modelling. You also have the ability ...

Excel LADZ - NBA Player Rebound Model

G'day lads,

Attached is the Excel LADZ NBA Player Rebound Model (2023-24 Version) + Video Explanation.

Model Explanation: https://www.patreon.com/posts/98061524

If you have any questions, please ask below 💪 

Excel LADZ - NBA Rebound Model

G’day, lads

In this article I’ll explain how I built the Excel LADZ NBA Rebound Model. A video tutorial on how to use the model is above. If you have any questions, please leave a comment!

JOIN the best Excel Sports Modelling Community by becoming a member of the Excel LADZ Patreon! Receive downloadable access to every model (including the Excel LADZ NBA Rebound Model) as well as technical posts, like this, which will improve your understanding of sports model...

Excel LADZ - 2023-24 NBA Rebound Model

G'day lads,

Attached is the Excel LADZ 2023-24 NBA Rebound Model. 

To use, simply go to the 'Result' worksheet. Select the 'Player' from the dropdown list, their 'Opposition', the player's 'Expected Minutes Played' and whether the game is at 'Home'. To see Over/Under probabilities, use cell F11 to change the threshold.

To update the model, go into the 'Data' tab and select 'Refresh All'. This will refresh the data imported into Excel so it is up to date...

3 Excel Functions You Need To Know…

G’day lads! In my experience, there are three important Excel functions that are important to learn! I’ll explain each one below, with an example, and how it’s useful in sports modelling.

• XLOOKUP
• POISSON.DIST
• BINOM.INV

JOIN the best Excel Sports Modelling Community by becoming an Official Member of the Excel LADZ Patreon! Receive downloadable access to every model as well as technical posts, like this, which will improve your un...

Video Suggestions

G'day lads, let me know what type of videos you'd like me to publish 🔥  If you have a video idea, please leave a comment!

Excel LADZ UFC Model | 72% Accuracy

G’day lads,

In this article I’ll run through how I built the Excel LADZ UFC Model using a process called Logistic Regression. If you have any questions, be sure to comment on the post! The Excel file is attached to this post.

Collecting Data

I collected the UFC Fight Data from the following link: https...

Excel LADZ UFC Model | 72% Accuracy

G'day, lads

Attached is the Excel LADZ UFC Model. I've used a process called 'Logistic Regression' to use the UFC Stats website and predict the Win % of the 'Red Fighter' in a UFC bout. This will be the next video on the channel 🚨 

To use the model, go to each fighter's profile on UFC Stats. This is the link to Sean Strickland's: http://ufcstats.com/fighter-details/0d8011111be000b2...

Excel LADZ NBA Model | Overtime & Live Win Probability

G’day, lads

In this video I ran through 3 major changes to the NBA Model. I’ll summarise how I did them below.

JOIN the best Excel Sports Modelling Community by becoming a member of the Excel LADZ Patreon! Receive downloadable access to every model (including the Excel LADZ NBA Model) as well as technical posts, like this, which will improve your understanding of sports modelling. You also have the ability to directly message me lads, so I can help you with an...

Excel LADZ NBA Model | Live Win Probability

G'day, lads

Attached to this post is the Excel LADZ 2023-24 NBA Model with a live win probability feature. Simply enter in the matchup, the current score and the remaining time to get an end-of-game Expected Score as well as Win %'s for both teams. This will be my next video 🚨 

If you have any questions lads, let me know in the comments below! In the coming days, I'll publish an in-depth explanation of my approach 🤠 

Import ClubELO Data Automatically Using Power Query Editor

G'day, lads

In this short video above, I run through how to write some code in Power Query Editor in order to import the Club ELO Data automatically. In the YouTube video up on the channel (and in the model posted to Patreon), the user is required to copy and paste the data into the model everyday. To save time, I've created code in the video above to write a Blank Query. This code can update the power query once you press 'Refresh All' in the Data tab.

Note:   2023-12-20 01:57:28 +0000 UTC View Post