MLB Betting Model | Sides, Totals, Exact Score | Using Google Sheets

MLB Betting Model | Sides, Totals, Exact Score | Using Google Sheets | How To

Рет қаралды 2,292

Benjamin Wagner

Ай бұрын

Пікірлер: 34

@matt-malyschko Ай бұрын

nice video

@Atoklk1284 10 күн бұрын

Hi, I am not the best at statistics so this may not be a very good question, but if you want projections for bets like over, under, and runline then why use an interquartile range to create a high and low? I understand that it is to keep the extremes from skewing data, but if you're eventually running 10,000 different outcomes to base the percent chance for different scores then the extremes are already accounted for as they are rare occurrences. I imagine you may have tried that or knew better, but I wanted to know if the specific reason. I suppose my follow up question would be what happens if you don't create a high and low but use another factor like starting pitcher and bullpen to keep extreme values from skewing results? In any case the model is very interesting, and I enjoyed the video!

@nestorgarcia3123 9 күн бұрын

which is the visitor and which is the local.......at the beginning of the video between col and chc.........gracias

@sooofred 25 күн бұрын

Great content, and well explained, thanks Benjamin . I'm not sure, but to update the sheet, is it done when we open it or do we have to do something else to activate the update on scraping the data? Update: sorry, I just understood (hopefully), it's when we select the game, that the data is collected, is it?

@TheBenjaminWagner 24 күн бұрын

It will update when you open the sheet as well as when you change the selected team.

@sawekmartyn1588 26 күн бұрын

Hi. Great job! Can you send me yours two MLB sheets?

@TheBenjaminWagner 25 күн бұрын

docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy docs.google.com/spreadsheets/d/1ke8c2T3qtGW9jNW9fFvPbcSeNbI2RshMIWGiexw6Z5o/copy

@jakekoeske7621 29 күн бұрын

First of all, love the model. I’ve been messing around with it for a couple days now. I was wondering if there is a way I could add statcast ballpark factor into the model to make the runs scored even more accurate. Im not very savvy with sheets but would love to learn more!

@coolkidj23 27 күн бұрын

so how does this work with pitching matchups? does it take that into consideration

@TheBenjaminWagner 25 күн бұрын

This particular sheet is using the team score regardless of lineup. In the other mlb video I did, you can select particular players.

@Amy-Ca Ай бұрын

Hello, I am following your work and I find it very interesting. I have a copy of your previous work and if it is not a bother, could you share the link to the finished sheet?

@TheBenjaminWagner Ай бұрын

docs.google.com/spreadsheets/d/1ke8c2T3qtGW9jNW9fFvPbcSeNbI2RshMIWGiexw6Z5o/copy

@thomasbargo4602 Ай бұрын

Thanks for the link to good going. I'm still going to attempt to follow along and do it myself on my days off

@randyreed1971 Ай бұрын

@@TheBenjaminWagner Great work. I'd be interested in looking at one that accounts for starting pitchers and lineups since that affects the outcome. I'd love to follow along because I'm sure you can figure it out!

@lachochavez2399 Ай бұрын

Thanks for everything, can you make a program for the NFL to find out who has a chance of winning in the game?

@TheBenjaminWagner Ай бұрын

Absolutely, I’ll make an NFL one when we get closer to the season.

@DPM2014 Ай бұрын

@@TheBenjaminWagner Thank you for everything, I also would love this! Your videos are great! Would you possibly be open to discussing custom models with particular advanced metrics as a service? I have a few I really like to incorporate with some ideas, however, I'm not great with the computer portion of the model

@TheBenjaminWagner Ай бұрын

@@DPM2014 What metrics in particular?

@DPM2014 Ай бұрын

@@TheBenjaminWagner There are some that are considered more “important” vs others such as DVOA (defense adjusted-valued over average), EPA (expected point average), success rate (success of QB passing vs def, success of WR vs defense, etc). Just to name a few… Most oddsmakers and professionals use these metrics, but My thought is to build a model similar to what you have while taking these advanced metrics, perhaps create a correlation (maybe R script?) through regression analysis to determine some type of weighted benefit of each metric for its impact on the game and final score. That’s where I think would differentiate things…. I would be happy and very grateful to connect with you to discuss more if interested.

@TheBenjaminWagner Ай бұрын

@@DPM2014 Sounds interesting. Sure, you can contact me at ben@bookiesmart.com

@lbeezi029 7 күн бұрын

That’s dope! ❤ can you please send me a copy?

@TheBenjaminWagner 4 күн бұрын

@@lbeezi029 docs.google.com/spreadsheets/d/1ke8c2T3qtGW9jNW9fFvPbcSeNbI2RshMIWGiexw6Z5o/copy

@lachochavez2399 Ай бұрын

Could you share the link please thanks

@TheBenjaminWagner Ай бұрын

docs.google.com/spreadsheets/d/1ke8c2T3qtGW9jNW9fFvPbcSeNbI2RshMIWGiexw6Z5o/copy

@lachochavez2399 Ай бұрын

@@TheBenjaminWagner THANK YOU VERY MUCH FOR SENDING ME THE LINK, THANK YOU SO MUCH

@JorgeDiaz-xs5ou Ай бұрын

Excelent work!!!....How could you add the information related to the starting pitchers.?....

@TheBenjaminWagner Ай бұрын

@@JorgeDiaz-xs5ou my prior video had pitchers as well. You could combine the two sheets and make a real nice model. Here’s the link to that one: kzfaq.info/get/bejne/lZ-DibGeyJfSeKM.htmlsi=aaQWC25AQo2hNv-T

@JorgeDiaz-xs5ou Ай бұрын

Thank you so much !