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

Hello, lad! Yes, all the models are able to be downloaded, including this one, by becoming a member of the Excel LADZ Patreon here: www.patreon.com/ExcelLADZ The data in these models are connected to the internet via a Power Query, so the data updates automatically once selecting the "Refresh All" icon in the 'Data' tab. I hope to see you in there, lad 😃

@excel_ladz ok, thanks for your reply

Oh my goodness, you’re right! I can’t believe I overlooked this 😢 I’ll look to edit this in the model 👍 Maybe I might re-upload the video. Thanks for letting me know lad, I appreciate it.

I doubt that the profit is very high unless there is huge luck involved. The biggest problem with these models is that they use league average, not accounting for home/away splits. Also not accounting for whoever plays in the game (some players have a lot more impact on the score than others) and as mentioned in the comments, some games have more value for a team than others. Think about already relegated teams or teams that use bench players as they have more games because of cup duties. These are great to help you get started in excel and to understand averages and numbers but to actually put money on these outcomes is real gambling imo.

Thanks for watching lad 💪 Yes, that definitely can be done! The only problem is that the number of simulations required to get that result (simulating every remaining game of the year, for 1,000 plus season to get an idea of the distribution) would slow the file down and greatly decrease its functionality. To get this result, it’s best creating a dedicated file for just that. I’ve actually done this for the EPL, check that video out lad!

@@excel_ladz Yeah I’ve already watched that video. It was great. To not slow the file down isn’t there a different way to do the simulations without having to do the 1.000 simulations under each other? I mean like a formula or a mathematical equation or something like that that could make it smoother?

G'day, lad! If your total home advantage was 10%, then you would multiply the Home xG by SQRT(1+10%), and the Away xG by 1/SQRT(1+10%). This would ensure you get a total xG advantage of 10% (or whatever your advantage figure is) for your home team 🔥

G’day lad! By becoming a member of the Excel LADZ Patreon, you’ll be able to download the Excel file exactly as I’ve built here 👍 This has a Power Query connected to it, so the stats update automatically whenever the data is refreshed 😃

@luxuryway6227 He has never tested any of his model with upcoming fixtures. Wont waste money any of his models

Hi lad, there definitely is! You would just simulate every game in a season, then simulate that season 1,000 or so times to see how every team did. I did this in the following video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0tzP_joPkIo.html

​@@excel_ladzThank you!

Good idea lad! Thanks for watching 💪

Yep! Once the season starts, the data will be replaced with the 24/25 connections and the model will run like normal 👍

@@excel_ladz so, once we have the sheet it will work automatically?

@@seychelles44 That's right 👍 As soon as I build the 2024/25 season sheet, it will work automatically for the rest of the season. You can also download the finished 23/24 version, and replace the stats yourself 😃