PREDICT MLB Matches With Excel | Tutorial

  Рет қаралды 11,642

Excel LADZ

Excel LADZ

Күн бұрын

Пікірлер: 84
@excel_ladz
@excel_ladz Жыл бұрын
G’day lads, download the Excel LADZ MLB Model: www.patreon.com/ExcelLADZ
@basiliszag
@basiliszag Жыл бұрын
Great video, thanks for sharing! Love to see more sports from you. 🎉
@briansacha51
@briansacha51 Жыл бұрын
Been waiting for this!
@kirrillywaring613
@kirrillywaring613 Жыл бұрын
Great work, as always!
@bruceleroy7125
@bruceleroy7125 Жыл бұрын
Any way I could incorporate pitcher stats such as era into this to make it more accurate? Love the videos!!
@lasseaberg5267
@lasseaberg5267 Жыл бұрын
👌Very interesting. As always!
@kramerf1451
@kramerf1451 9 ай бұрын
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_ladz
@excel_ladz 9 ай бұрын
G'day lad, I suggest you become an Official Excel LAD here: www.patreon.com/ExcelLADZ 🔥
@sukalamink4024
@sukalamink4024 Жыл бұрын
Great vid, would love to see a NRL model!
@excel_ladz
@excel_ladz Жыл бұрын
I'd love to make that lad, hopefully before the finals! 🔥
@bubba9351
@bubba9351 9 ай бұрын
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
@gerardoadrianmagallanes2935 Жыл бұрын
Great Video Man! Any Plans in the future of releasing a NFL or UFC model?
@excel_ladz
@excel_ladz Жыл бұрын
Definitely NFL, but still need to do a bit more research for the UFC Model 👍
@calvinlai696
@calvinlai696 6 ай бұрын
Much appreciated on the video. Is there any way you can adjust for pitching matchups?
@excel_ladz
@excel_ladz 6 ай бұрын
That'll be the next update/video 🔥 Thanks for watching lad!
@calvinlai696
@calvinlai696 6 ай бұрын
@@excel_ladz Thanks! Looking forward to it. Cheers
@louisDelavara-cd9ro
@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
@basiliszag Жыл бұрын
Any plans for making play by play simulation for mlb?
@excel_ladz
@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) 💪
@jxhnvii
@jxhnvii 3 ай бұрын
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
@jesuscuevas8706 Жыл бұрын
Thanks for this new tool, is not clear for me on Alphabetical data column, where come from these?
@excel_ladz
@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 👍
@xtrm1n8tr99
@xtrm1n8tr99 7 ай бұрын
@@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
@joannewaring1004 Жыл бұрын
EXCELlent
@dammitmatt4694
@dammitmatt4694 Жыл бұрын
Can you build for football corner kicks🥺
@excel_ladz
@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 👍
@TimTheMusicMan
@TimTheMusicMan 4 ай бұрын
What's a football corner kick??
@TimTheMusicMan
@TimTheMusicMan 4 ай бұрын
@@excel_ladz What's EPL ??
@davidjobe9876
@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
@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
@davidjobe9876 Жыл бұрын
@@excel_ladz Thanks for the quick response have found it with your instructions ;)
@brighth8883
@brighth8883 Жыл бұрын
@@davidjobe9876Hey were you able to figure out the formula for Runs/Per Inning and Runs/Allowed per inning??
@LoganFleck-ei8tj
@LoganFleck-ei8tj 7 ай бұрын
⁠​⁠@@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-ei8tj
@LoganFleck-ei8tj 7 ай бұрын
Would really love to see the formula you put in to ensure it will be live and refreshable correct numbers
@Injustice360
@Injustice360 Жыл бұрын
Do you have one for the NFL?
@excel_ladz
@excel_ladz Жыл бұрын
Not right now lad, but it’ll definitely be released before the season starts in September 💪
@andrewpearsall4896
@andrewpearsall4896 Жыл бұрын
I simp for excel ladz
@mitchellwillard6471
@mitchellwillard6471 Жыл бұрын
Bro same 😩
@shawnyc1993
@shawnyc1993 3 ай бұрын
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
@nateklein7342
@nateklein7342 4 ай бұрын
Where do you find the source for the two tables of data at the 1:00 mark?
@thomasbargo4602
@thomasbargo4602 6 ай бұрын
Numerous people have asked about the runs /inning stats. He's hoping people will give up trying and buy it from his Patreon.
@LettyMMA
@LettyMMA 7 ай бұрын
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
@jozsef5688 Жыл бұрын
Thank you for this video. Can you tell me How do you create the numbers in the Alphabetical column?
@shaboiiiiiiiing
@shaboiiiiiiiing 7 ай бұрын
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_ladz
@excel_ladz 6 ай бұрын
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. 👍
@ztaylor2036
@ztaylor2036 6 ай бұрын
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.
@thomasbargo4602
@thomasbargo4602 6 ай бұрын
I've come to a standstill using Google Sheets. I'm stuck on the WhatIf Analysis. Anybody have any ideas?
@nap1346
@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
@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
@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 😉
@filiperodrigues7283
@filiperodrigues7283 2 ай бұрын
It's possible to do for soccer/football
@tomkmb4120
@tomkmb4120 7 ай бұрын
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...
@tomkmb4120
@tomkmb4120 7 ай бұрын
Which are those two tables you're pulling from the teamranking site please mate?
@tomkmb4120
@tomkmb4120 7 ай бұрын
Nevermind, it must be runs per game and opponent runs per game right?
@xtrm1n8tr99
@xtrm1n8tr99 7 ай бұрын
@@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
@kelaniefrazier
@kelaniefrazier 7 ай бұрын
How did you import the stats?
@dudester81
@dudester81 7 ай бұрын
Can you do a MLB player props Excel spreadsheet
@excel_ladz
@excel_ladz 7 ай бұрын
Hi lad, great idea 👍 I’ll look to do this in the short term 🔥
@vclkufxxbgfdfe
@vclkufxxbgfdfe 7 ай бұрын
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.
@Cstanford03
@Cstanford03 7 ай бұрын
did you find a fix?
@vclkufxxbgfdfe
@vclkufxxbgfdfe 7 ай бұрын
@@Cstanford03 yes sir, but thank you
@LettyMMA
@LettyMMA 7 ай бұрын
@@vclkufxxbgfdfehow did u fix it? I’m getting the same error message on google sheets. Did u have to use the arrayformula?
@vclkufxxbgfdfe
@vclkufxxbgfdfe 7 ай бұрын
@@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.
@LettyMMA
@LettyMMA 7 ай бұрын
@@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_octoman8795
@mr_octoman8795 7 ай бұрын
Does anyone know how he got the "R/Innings" and "RA/Innings" metrics?
@drewmorgan4514
@drewmorgan4514 7 ай бұрын
TeamRankings, "MLB Team Extra Inning Runs per Game" and the opposite for the other collum
@tomkmb4120
@tomkmb4120 7 ай бұрын
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?
@joshbull2064
@joshbull2064 7 ай бұрын
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
@tomkmb4120
@tomkmb4120 7 ай бұрын
@@joshbull2064 Thanks bro, good looking out - appreciate the help!
@tomkmb4120
@tomkmb4120 7 ай бұрын
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_ladz
@excel_ladz 7 ай бұрын
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 😃
@tomkmb4120
@tomkmb4120 7 ай бұрын
@@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
@alexxelar7439
@alexxelar7439 6 ай бұрын
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
@Nick23PACE Жыл бұрын
Great content, just commenting for the algorithm. Thanks Mate 🤝
@excel_ladz
@excel_ladz Жыл бұрын
Haha great idea lad 🔥 Glad you enjoyed it 👍
@Nyxruler
@Nyxruler 4 ай бұрын
too much for me
@alivstyson1864
@alivstyson1864 7 ай бұрын
why would anyone put anything that works on youtube ? it would be stupid to the max
@mrbeastness
@mrbeastness 7 ай бұрын
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
@lachochavez2399
@lachochavez2399 6 ай бұрын
👎
PREDICT NBA Games With Probability | Excel Tutorial
51:08
Excel LADZ
Рет қаралды 43 М.
PREDICT NHL Matches With Excel | Tutorial
29:20
Excel LADZ
Рет қаралды 3 М.
А я думаю что за звук такой знакомый? 😂😂😂
00:15
Денис Кукояка
Рет қаралды 4,6 МЛН
Симбу закрыли дома?! 🔒 #симба #симбочка #арти
00:41
Симбочка Пимпочка
Рет қаралды 5 МЛН
How Many Balloons To Make A Store Fly?
00:22
MrBeast
Рет қаралды 147 МЛН
Baseball Advanced Stats Explained (Sort Of): Hitting
21:33
Smartr Baseball
Рет қаралды 12 М.
Predict the Outcome of Football Matches Using this Model
21:02
Kie Millett
Рет қаралды 189 М.
I Used Excel to PREDICT UFC Fights | 72% Accuracy!
26:25
Excel LADZ
Рет қаралды 3,4 М.
А я думаю что за звук такой знакомый? 😂😂😂
00:15
Денис Кукояка
Рет қаралды 4,6 МЛН