G’day lads, download the Excel LADZ MLB Model: www.patreon.com/ExcelLADZ
@basiliszag Жыл бұрын
Great video, thanks for sharing! Love to see more sports from you. 🎉
@briansacha51 Жыл бұрын
Been waiting for this!
@kirrillywaring613 Жыл бұрын
Great work, as always!
@bruceleroy7125 Жыл бұрын
Any way I could incorporate pitcher stats such as era into this to make it more accurate? Love the videos!!
@lasseaberg5267 Жыл бұрын
👌Very interesting. As always!
@kramerf14519 ай бұрын
Amazing - are you going to have a live excel sheet going for the 2024 season? And if so, can you please share link how to join. Thanks & great content
@excel_ladz9 ай бұрын
G'day lad, I suggest you become an Official Excel LAD here: www.patreon.com/ExcelLADZ 🔥
@sukalamink4024 Жыл бұрын
Great vid, would love to see a NRL model!
@excel_ladz Жыл бұрын
I'd love to make that lad, hopefully before the finals! 🔥
@bubba93519 ай бұрын
Hi Excel Ladz, great video just got a question on how do you do the alphabetical formula in the power query page for columns BB and BL, Thanks.
@gerardoadrianmagallanes2935 Жыл бұрын
Great Video Man! Any Plans in the future of releasing a NFL or UFC model?
@excel_ladz Жыл бұрын
Definitely NFL, but still need to do a bit more research for the UFC Model 👍
@calvinlai6966 ай бұрын
Much appreciated on the video. Is there any way you can adjust for pitching matchups?
@excel_ladz6 ай бұрын
That'll be the next update/video 🔥 Thanks for watching lad!
@calvinlai6966 ай бұрын
@@excel_ladz Thanks! Looking forward to it. Cheers
@louisDelavara-cd9ro Жыл бұрын
would you be able to explain the formula for r/innings? i can't seem to get it. Thanks in advance! This Part is throwing off the whole model!
@basiliszag Жыл бұрын
Any plans for making play by play simulation for mlb?
@excel_ladz Жыл бұрын
Definitely lad 👍I love play-by-play models, as they are grounded in real life. In my opinion (and I'm sure yours too), the more realistic the model, the better it is. It'll take some time before I release a play-by-play MLB model onto Excel LADZ, but I hope to be able to do this by the end of the 2023 MLB Season (in time for the finals) 💪
@jxhnvii3 ай бұрын
Doing research currently but do you know if it's possible to automate ESPN daily stats updates into an excel file? I go through every morning and out of the 50 or so batters, update their last 7 hit/hr stats, august hit/hr stats, if they got a hit last game and total games they got a hit out of games played that month. About a tedious hour thing everyday just seeing if you had any insight, thanks!
@jesuscuevas8706 Жыл бұрын
Thanks for this new tool, is not clear for me on Alphabetical data column, where come from these?
@excel_ladz Жыл бұрын
Hi lad, I've gotten these values using a Power Query on Excel. Basically, a Power Query allows me to import live data from the internet. In this MLB Excel Model, I've pulled live data from the Baseball Reference and TeamRankings websites (both links in the description). Then from this Power Query data, I've just copied the list of teams. Alternatively, you could just manually write the teams down 👍
@xtrm1n8tr997 ай бұрын
@@excel_ladz what is the alphabetical order for though what purpose does it serve and how do i do it like can i just follow yours for order and type the number in or do i have to use a special function
@joannewaring1004 Жыл бұрын
EXCELlent
@dammitmatt4694 Жыл бұрын
Can you build for football corner kicks🥺
@excel_ladz Жыл бұрын
G'day lad, I could perhaps release a video on this before the EPL season starts 🔥In saying that, a basic Football Corner Kicks model would be quite easy to build. It would just involve treating corners for like 'Goals For' and corners against like 'Goals Against', and then using the Poisson method to distribute each team's Expected Corners. Then, you could come up with accurate Corners Over/Under figures 👍
@TimTheMusicMan4 ай бұрын
What's a football corner kick??
@TimTheMusicMan4 ай бұрын
@@excel_ladz What's EPL ??
@davidjobe9876 Жыл бұрын
It's good tutorial but where can I find the values R/Innings and RA/Innings I don't see those numbers in those tables?
@excel_ladz Жыл бұрын
Thanks for watching lad 🔥In the Team Rankings website, select the 'MLB' header. Then, on the left sidebar, open up 'Stats'. Then select 'Team Stats'. Within 'Team Stats', open up the row 'Other'. Within 'Other', you'll find the link to "Extra Innings Runs Per Game" and "Opponent Extra Innings Runs Per Game". You can use these stats to find the R/Innings and RA/Innings. See if that helps lad, let me know if it works for you 👍
@davidjobe9876 Жыл бұрын
@@excel_ladz Thanks for the quick response have found it with your instructions ;)
@brighth8883 Жыл бұрын
@@davidjobe9876Hey were you able to figure out the formula for Runs/Per Inning and Runs/Allowed per inning??
@LoganFleck-ei8tj7 ай бұрын
@@excel_ladzI’m wondering how the “extra inning runs” from team rankings will help us to find the r/inning and the ra/inning I hope you answer and can help me out
@LoganFleck-ei8tj7 ай бұрын
Would really love to see the formula you put in to ensure it will be live and refreshable correct numbers
@Injustice360 Жыл бұрын
Do you have one for the NFL?
@excel_ladz Жыл бұрын
Not right now lad, but it’ll definitely be released before the season starts in September 💪
@andrewpearsall4896 Жыл бұрын
I simp for excel ladz
@mitchellwillard6471 Жыл бұрын
Bro same 😩
@shawnyc19933 ай бұрын
Is there a way to calculate the runs per inning that are simulated? I’d like to be able to see what % each each has for whether a run was scored or not
@nateklein73424 ай бұрын
Where do you find the source for the two tables of data at the 1:00 mark?
@thomasbargo46026 ай бұрын
Numerous people have asked about the runs /inning stats. He's hoping people will give up trying and buy it from his Patreon.
@LettyMMA7 ай бұрын
Can somebody explain why the formula for C doesn’t work on google sheets? I copied it exactly but I’m getting an error message that says #Value!- “A matching value could not be found. To get the values for the entire range use the arrayformula function” any feedback would be appreciated 👍🏽
@jozsef5688 Жыл бұрын
Thank you for this video. Can you tell me How do you create the numbers in the Alphabetical column?
@shaboiiiiiiiing7 ай бұрын
could I add 2023 data for r/g and ra/g to the model with the present 2024 data to make it more accurate?
@excel_ladz6 ай бұрын
Yes, absolutely lad 🔥 I would just copy and paste that into Excel and use a weighted percentage between 23 and 24 data. For example, 100/0 after 0 games in 24, 50/50 after 20 and 0/100 after 40 games. 👍
@ztaylor20366 ай бұрын
So ive managed to add pitching matchups and imported pitching data but i run into this problem where some pitchers have a 3rd name and therefore an extra column in their data and it completely breaks the model, as in the lookup returns no data for those guys and then the whole data table gets messed up. Anyone come up with a solution for this? Ive tried adding wildcards to the vlookup logic but nothing seems to work. Im running out of ideas. Maybe build an if/then into the lookup? Idk, if anyone has a fix for this please advise.
@thomasbargo46026 ай бұрын
I've come to a standstill using Google Sheets. I'm stuck on the WhatIf Analysis. Anybody have any ideas?
@nap1346 Жыл бұрын
hello great video but I have a question about how I can replace SEQUENCE(20) because in Excel2010 this formula does not exist. And as you use it to calculate the "probality distribution" I'm stuck on this part.thanks for advance
@excel_ladz Жыл бұрын
Hi lad, there’s only a slight change needed to be done to the spreadsheet 🔥 To replace the SEQUENCE Function, just type out the numbers 0-20 👍 If you also don’t have access to XLOOKUP, then the corresponding probability for 0 goals would have to start at 0%, then the 1 goal probability would be the previously 0 goal probability… This is because VLOOKUP return the lowest value instead of the highest one which XLOOKUP does. I hope that helps a bit lad 💪
@nap1346 Жыл бұрын
@@excel_ladz the VLOOKUP returns the 1st value in the table, of course if it is sorted in ascending order it will start with 0 but if it is sorted in descending order it will be the highest value 😉
@filiperodrigues72832 ай бұрын
It's possible to do for soccer/football
@tomkmb41207 ай бұрын
Can't seem to get the R/9 and RA/9 columns to populate anything other than an #N/A error at the moment - copied your setup on the data imports and formulas to the letter...
@tomkmb41207 ай бұрын
Which are those two tables you're pulling from the teamranking site please mate?
@tomkmb41207 ай бұрын
Nevermind, it must be runs per game and opponent runs per game right?
@xtrm1n8tr997 ай бұрын
@@tomkmb4120 yeah it is it took me awhile to find them until i realized they are in this comment section i dont understand the alphabetical numbers though
@kelaniefrazier7 ай бұрын
How did you import the stats?
@dudester817 ай бұрын
Can you do a MLB player props Excel spreadsheet
@excel_ladz7 ай бұрын
Hi lad, great idea 👍 I’ll look to do this in the short term 🔥
@vclkufxxbgfdfe7 ай бұрын
this is a great video. i don't have excel but i am building along in google sheets. when i go to enter the equation to solve for C, it returns "Error A matching value could not be found. To get the values for the entire range use the ARRAYFORMULA function." Anyone know how to troubleshoot this? also that long eqaution for C sequence (20)... part of this video is kinda confusing and i'd be curious to learn how that all works rather than just copy your work. might make for an interesting video, but cool video and i followed you.
@Cstanford037 ай бұрын
did you find a fix?
@vclkufxxbgfdfe7 ай бұрын
@@Cstanford03 yes sir, but thank you
@LettyMMA7 ай бұрын
@@vclkufxxbgfdfehow did u fix it? I’m getting the same error message on google sheets. Did u have to use the arrayformula?
@vclkufxxbgfdfe7 ай бұрын
@@LettyMMA yea but i don't remember how lol. i think i ended up using a poisson distribution formula i found online instead of the equation in the video. might not be as accurate but it seems to work out fairly well. i dont remember exactly how i did it but i think if found answers by watching youtube videos on "poisson distribution probabilities with google sheets." if you have any questions i might be able to help but its been a few weeks and i really dont remeber.
@LettyMMA7 ай бұрын
@@vclkufxxbgfdfe I appreciate ur reply bro. I’m gonna google that and see what I can come up with, as I am still stuck at that step 😂
@mr_octoman87957 ай бұрын
Does anyone know how he got the "R/Innings" and "RA/Innings" metrics?
@drewmorgan45147 ай бұрын
TeamRankings, "MLB Team Extra Inning Runs per Game" and the opposite for the other collum
@tomkmb41207 ай бұрын
When I'm trying to load more than the standard batting table from the powerquery - it's just saying they're 'loading' perpetually on the web view. They never show up in the excel Navigator box, only the team standard batting table does - is this the site trying to limit scraping?
@joshbull20647 ай бұрын
had the same error, if you scroll down to the bottom of baseball reference website, you will see a link to pitching and fielding url. click that and use that to import stats instead
@tomkmb41207 ай бұрын
@@joshbull2064 Thanks bro, good looking out - appreciate the help!
@tomkmb41207 ай бұрын
Also having an issue with the formula to grab the information from the teamrankings tables, because they're using diff naming conventions - I know he's tried to get around that with the sequence(30) but for some reason it just returns all 0's for me...all data types are correct in the imported tables. This is what I get - i.imgur.com/B56NML9.png My setup is identical to his in terms of cell placements etc.
@excel_ladz7 ай бұрын
G’day lad, SEQUENCE may not work on your version of Excel - it’s an array function. It doesn’t matter though, all you need are the numbers listed - doesn’t matter how you get them 😃
@tomkmb41207 ай бұрын
@@excel_ladz Cheers for the response - yeah look at my setup though, sequence should work fine as I've got the numbers there but for some reason it just returns all 0's - I've ensure the cells are formatted as numbers i.imgur.com/YB5Egwk.png i.imgur.com/gTikIkH.png
@alexxelar74396 ай бұрын
Good video. But estimating the probability in this way will not be accurate, since the starting lineup of the teams must be taken into account. The whole secret lies in estimating the expected runs for teams as accurately as possible.
@Nick23PACE Жыл бұрын
Great content, just commenting for the algorithm. Thanks Mate 🤝
@excel_ladz Жыл бұрын
Haha great idea lad 🔥 Glad you enjoyed it 👍
@Nyxruler4 ай бұрын
too much for me
@alivstyson18647 ай бұрын
why would anyone put anything that works on youtube ? it would be stupid to the max
@mrbeastness7 ай бұрын
because its not gonna be very accurate when pitcher data isnt incorporated, theres gonna be a big swing in runs scored vs someone like corbin burnes vs someones 5th starter, so its taking into account season long stats but for single game bets its not gonna show that variance