Excel LADZ - 2024-25 European Football Model!
Added 2024-08-18 11:49:25 +0000 UTCG'day lads! Attached to this post is the 'Excel LADZ - 2024-25 European Football Model'. This model covers the EPL, LaLiga, Serie A, Ligue 1 and the Bundesliga! The model calculates an xG figure for a potential matchup, and then uses the Poisson Probability Distribution to find probabilities for the:
Moneyline
Over/Under Goals
Exact Goals
Double Chance
Win/Draw/Win
How-to-Use
As soon as you open the file lads, go to the 'Data' tab and select the "Refresh All" icon. This will update the spreadsheet's connection with Football Reference and bring in the newest stats ๐ฅ
To select a matchup, first select the league from the dropdown list in the cell A3 of the "Dashboard" worksheet. Then, select your two teams in cells G1 & G3 ๐
Please let me know if you have anymore questions lads! I'll drop an article detailing the slight changes I've made to this model to make it better in the next week or so ๐
Comments
Hello boy, a question why you use the value of 10% for the house
Julio R.L
2024-10-27 13:53:29 +0000 UTCHI, Can you add Liga BBVA (Liga MX)?
Victor Saul Parra Rodriguez
2024-10-07 01:19:35 +0000 UTCGood question. I've been asking this for several months now.
Iain Moran
2024-09-05 15:15:53 +0000 UTCWhen are you going to post it?
Alvin Lundqvist
2024-09-05 14:54:53 +0000 UTCHi Will, welcome ๐ฅ That's most unusual, however there are some steps to try to get to the bottom of the problem. Firstly, you may see there are two files attached to the post. I recommend trying to Download the 'Legacy' version and refreshing that data. There also may be a horizontal, yellow bar across the top of the spreadsheet when you first open the model warning that 'External Data Connections have been disabled'. If that occurs, you must select the "Enable All" beside it. This will allow Excel to grab data from the website Football Reference - where this model pulls its data from. If those two things don't work, please send me a screenshot of your problem ๐ You can message me via the discord group or email at: ladz.excel@gmail.com. Of course, if we still can't get to the bottom of your problem, I can offer you a full refund ๐ Please let me know if any of this helped lad!
Excel LADZ
2024-09-02 10:24:20 +0000 UTCI get a message saying unable to open stats website and cannot download the information you requested.
Will
2024-09-02 09:33:25 +0000 UTCDo you have any videos how we can create this type of model from scratch?
Matthew Moscatello
2024-08-27 01:09:44 +0000 UTCHi mate, Borussia Mรถnchengladbach are known as 'Gladbach' by the model. As all the data comes from the website Football Reference, whatever they label the teams is what they appear as in the model ๐ I've just fixed a tiny formula error relating to something else in the model, so I suggest re-downloading the model lad ๐
Excel LADZ
2024-08-27 00:37:09 +0000 UTCHi mate, thanks for the comment! I'll look into that problem, and fix it tomorrow if I can find anything wrong ๐
Excel LADZ
2024-08-24 11:51:51 +0000 UTChi lad, I dont find some tems in bundesliga, example borussia mรถnchengladbach
Victor Saul Parra Rodriguez
2024-08-23 14:43:21 +0000 UTCAwesome. I'll record when I find some time in the next few days mate.
Excel LADZ
2024-08-19 12:05:12 +0000 UTCThanks Lad, yes, an uncut video showing you adding a league. No need for it to be polished. I think that would be clearer than a written explanation.
Iain Moran
2024-08-19 12:03:36 +0000 UTCHi lad, I'm glad you like it ๐ฅ Yes, apologies for that. Perhaps in the next week I can do an "uncut" video of me adding a league like the Championship to this file. Although my explanations might not be as polished as in a YouTube video, it may provide a better insight into the 'workings' of the model and my thoughts behind it. Would you prefer that, or a rigorous written explanation instead lad? Let me know what you think ๐
Excel LADZ
2024-08-19 11:57:28 +0000 UTCThis is great, Lad, thank you. Though I hope you'll be showing us how we can add our own leagues to this too. I have been asking for this for quite some time....
Iain Moran
2024-08-18 12:24:09 +0000 UTC
