Mastering Sports Betting: Step-by-Step Guide to Building Your Own Sports Betting Model
ฝัง
- เผยแพร่เมื่อ 1 ต.ค. 2024
- In this highly informative video, I'll walk you through the process of creating your very own sports betting model specifically designed for Major League Baseball (MLB).
By the end of this video, you'll have a fully functional MLB sports betting model that can help you make informed decisions, identify valuable betting opportunities, and potentially boost your chances of long-term success in the sports betting arena.
LINKS:
Model: docs.google.co...
Team Rankings: www.teamrankin...
RazzBall: razzball.com/m...
Covers: www.covers.com...
#mlbpicks #mlbpredictions #mlbbestbets
------------------------------------------------------------
🔴 Subscribe for more DAILY sports content: www.youtube.co...
🔵 Become a BALLER and further support the channel! / @guybostonsports
Check out the Guy Boston Store: guybostonsport...
Follow Guy Boston Sports on Twitter: / guybostonsports
Follow Guy Boston Sports on Instagram: / gbossports
Follow Guy Boston Sports on Facebook: / guybostonsports
Store: fademe.store
You are the man. You have no idea how long I have been waiting for someone to make a video just like this! AWESOME JOB!!
Would love a player prop tutorial
Does the information in data dump update everyday automatically?
Anything with the Import function will
@@GuyBostonSports thank you
What website do you use to update game lines daily on sheets? Like what to put with the importhtml?
This is the content that got me here. Thank you amigo 💯
appreciate it!
Loving this model. Have you come across an issue where a pitcher that is in the table (razz) but will not populate in the drop-down pitchers list? Specifically, I am trying to bring in Dakota Hudson and he will not show up. Odd. Keep up the great work.
In what ways would an NFL model be different? Much appreciated
Adios mio tu esta muy intelligente hombre
Definitely need a player props model; enjoying your content!
Quick question... i keep putting data in and outta 15 games(mlb) 7 of them say N/A did i do something wrong?
I created one for upcoming game for example Mets vs Cubs and pitchers are Severino and Assad. Messup my entire work bcs result came back N/A.
So I watched the video and created my own model off of it. Thank you! First model! However, there seems to be a glitch with mine and I can’t figure it out. It was all fine until last night, presumably when covers started updating its stats from the night. Now, I can’t pull the stats from covers. I keep getting an error message. Any thoughts? I retype the formula and it works. And then it glitches again the next time I open it.
this was great thank you! a couple questions.
Will the data automatically refresh when the 2024 season starts or would we have to manually update the links daily? Also will you be doing one for player props? Thank You!
Thank you so much for the video it is wonderful I can't wait to use it with the other model. I appreciate the time you put into this!
When I enter different teams I ge #N/A ALL across the row. No info. I entered manually again starting with away runs/game and still no info.
hello to you
I was able to watch your videos where you explained how to build the model on Excel. I would like to know if we could do it for football and make a video for us. Thank you for your attention.
I followed along and some teams pulls an Error saying “did not find value ‘Milwaukee’ in vlookup evaluation
Absolute life saver with this thing man!
Thanks for showing how to weigh in the pitchers into the run projections that was actually nice thing to learn.
For anybody reading create a dropdown list for the pitchers & sort them by there team for easier fill out.
You could also create a dropdown list for the teams. Made it easier to swap & change teams around.
how exaclty do you go about doing this
@@ethanschwab9670
So I found it in this guys video
th-cam.com/video/FzX8UwpvTk0/w-d-xo.html
Pretty much do what he does for importing pitchers but in your model. I did his pitcher method on this model because I was a better approach and was easier for me import others.
I've learned how to import ML and O/U odds too. Its fairly easily making a 2nd table and vlookup everything.
I am currently working on my advanced prediction method right now. Which is vlookup a bunch of stats into a formula/algorithm to predict the winner outside of just who scored more. I did it in my other model but need to do it on this one made this one cleaner.
razzball and covers now have different initials for arizona and washington so now the model is all thrown off and getting N/A everywhere, how to fix?
Curious for the home and away teams, why you chose not to use the specific runs scored stats when the team was playing at home vs on the road instead of just full season regardless of where they played.
I have learned a lot with a couple of your videos in mlb modeling,...can you make a video with soccer model? i'm seeing that many websites don't allow importhtml, i want something not to complicated, only add win, lose, over .5, over 1, over 2, corners and that's it...
Please help us common folks with your expertise in building the best model possible
why do I sometimes get an N/A when I change the team name or the pitcher?
MY MISTAKE, I RE-CHECKED THE FORMULAS, THEY ARE CORRECT. I JUST DIDN’T UNDERSTAND. AWESOME VIDEO AND BEGINNING MODEL GUY BOSTON. SORRY ABOUT THE PREVIOUS POST.
All good!
You are a true legend and saint for this. I really hope the people watching take advantage of this. This stuff took me months to figure out on my own, where were you 2 years ago 😂. Still one thing I can’t figure out.. how would you use decimal average like batting average to affect the true outcome of runs? Using the decimal in a regular average formula would have an inaccurate outcome, right? Since the others factors are whole numbers? Keep up gods work!
Appreciate that!
In terms of average, I always try to related a percentage (aka a batting average) to some form of a run total. So example if a team is batting .025 better than the opposing team, maybe we'd lend them an extra .3 runs in the final projection or something like that
@@GuyBostonSports that will definitely work. Thanks man!
Has anyone tried adding in win percentage or any other stats ? I want to try to add in other stats and have multiple systems being used to calculate outcomes.
How do you get this to work on an IPad ? It won’t allow fetch data
have you used this recently? Under new team for bull pen stats it now shows #n/a for all of them and was wondering if any of the formulas would be messed up if i Just manually entered the names of the teams. thanks
Very Helpful video, thank you.
Team rankings isn’t importing the stats anymore. Is there another site to use for all sports or is there a way to get team rankings to work?
Im pretty sure they are still updating?
Yea i see that too, any other website? Thanks for video!
Is it okay for me to just use yours in the description? For some reason I'm having issues I followed your steps exactly and when I add certain teams I get N/A in some of the columns .
I’m having the same issue some teams work other teams don’t work. Did you ever fix this issue in your model ?
Just watch and made this, thank you so much! Only question I have is how does it work with updating the stats? Does it do it automatically, or manually you have to do it? If so how often did you do it manually.
Just finished mine ❤❤❤please do one for upcoming NFL. GREAT JOB
Hot Damn ! no one mean no one othe rthan you my guy, keep thsi up i will defintly fux with cha, you earned my respect , and my time for all ur videos on a daily. i will create this and still watch!!
Thank you very much you are the only person who explains how to do everything thank you very much a good video
tyring to go through this process with you step by step and im literally stuck on this vlookup part i keep getting error or N/A
How is this free? thank you so much dude!
Thank you sir! I'll probably just automate the team names and starting pitchers based on the days' matchups as well.
Amazing! Can you create a similar one for the NBA or NFL
Why am I getting a “Formula parse error when I’m inserting the html on google sheets?
Thank you brother, you are feeding the streets with free game! You are a G! Side note not sure if you touched up on it, But is there a way you can see Pitcher Projections of the current matchups?
Please do a player prop model
That would be like probably doing the opposite of this. Just enter player data I suppose
People I know would pay extreme cash for this information
nba player props tutorial would be aces
why did everything just break????
Followup from my post yesterday - I plugged in all the matches yesterday (9th May) and got what I consider very good projections. Results of all the predictions were 12 wins, 8 losses and 1 push. I selected 3 of what I thought were the strongest - all at least +110 or higher. Two winners, one loss. As all plus odds I was up for the night!
How do you get the Html Urls to update for all the data for this tutorial? Is there a way to do it manually and/or automatically?
@@randyreed1971 same here. It doesn’t update and says #N/A for the whole row. No info. Did you figure jt out?
Hey @Guy Boston Sports, do you have NFL and college sports models currently out with the beginning of the football season?
Working on the NFL currently. Hoping to have it for week 2
Don't worry about what people comment, your Great at what you do, i appreciate you! "I seen the hater one" haha,, been rocking with you for a while now, and I'm UP, so keep doing what ur doin , We pick and choose, and by the way, I don't lose too many with you, js
Appreciate that!
Thank you for this Bro, very easy to follow. Doing it today…. Only realized that at the time of your video Arizona was considered ARI and now it’s AZ….. once I pasted after the sort I was seeing AZ below ATL …… easy fix. Copy the correct abbreviation next to the correct team ……😂
Anyone else having issues with the vlookup coming back with and error for certain team names ? Should I try and redo one of the formulas?
I was missing some ,0 in my formulas. In case anyone has the same problem.
Having trouble when I copy and try to move over so it updates the next cell but I’m literally just copying and pasting. It’s not a new number just the same. On mac
Thanks... Best video on bestball...
You’re a legend for this. Appreciate the great info! One question I have that maybe you mentioned in the video is do the stats get live updated to the model as the website updates the stats? Thanks!
yes it should be live updated! you dont need to touch it
@@GuyBostonSports With the data updating live, I assume that in the tables where the data is dynamic and the teams move up and down the table based on performance. For example, the bullpen stats table is arranged in order of highest ERA to lowest ERA, so as a team's ERA rises and falls relative to other teams in the league, then they will rise and fall in the table. The way you got around the names not matching issue, will that move up and down with the teams as well? or will you have to edit that every time there is movement in the table?
I keep getting an error when I use Google sheets to import. Anyone else having this issue? I have tried multiple URL same error.
any tips on using the model for bets?
Looks great! Have you thought about applying ballpark factors for your totals? It’s kind of an important thing I think
Do you plan on creating one for NHL. If you do have a video on that, can you guide me in the right direction? Thank you, much appreciated!!
my data dump isnt updating, i followed the video, what could be the reason please? did it on excel
This is Google sheets
So for the run line when there is a home dog the formula will always just pick the away team, any ideas on how to tell it when the away team is the one that should be -1.5.
Just by adding 1.5 as the “home runline”
If the home is 1.5, that means the away is -1.5. Hope that helps
Amazing detailed video. Looking forward to trying it out. Greetings from the UK. Thanks very much.
Thank you brother great info
fantastic intro to mlb modeling, thank you!
@guy boston sports im trying to do jthis table for an nhl model. im running into a problem with my goals per game isnt the next coloum next to the teams. its like the b-f. do you know any formulas to work for this? would love for an NHL one
Great video. Quick question, may have missed it. Does the model update every day based on previous days games? Or is this something the user will have to manually do? Thanks
it will auto update
@@GuyBostonSports you’re the fu*>ing MAN!
Does anyone know if there’s a way to do a web query for the schedule? I don’t want to have to import it every day. Is there a way I can load it in and just refresh it daily so that it it updates? Can’t figure it out. Someone please help
The formulas here should auto import whenever the site changes
@@GuyBostonSports what site has the schedule of games?
Quick question on the average weighting. Should the weighting numbers be symmetrical for the Away vs Home in the same category? For example, if I'm weighing more on the last 3 games for a team and I weigh the away team's runs scored over the last 3 games at 30%, should I weight the home team's runs allowed over the last 3 games as well? Thanks for the insight!
I would love a player props model
I had to comment for you. This is great stuff. I appreciate everything u do ev
Appreciate that
Thanks for the video. I have learned so much about this model. Much appreciated.
awesome video man! Have you done it on soccer games or could you do the same thing but with soccer, that would be awesome and I think many people would enjoy it!
When I hit f4 to lock in the formula the dollar signs do not come up
you are able to add them in manually as well!
its telling me input phrase error when im trying to input the data from opponent runs per game part, i typed =importhtml then i paste the link then coma parenthesis table parenthesis coma 1 and its saying input phrase error... im so frustrated lol
Did you figure it out ?
What do I do if Vlookup keeps pulling era stats instead of others?
Also say I wanted to have data for LHP or RHP. How would I do it into excel if the pitcher is RH or LH, same thing for weather conditions.
Thank you so so much. It would be cool to see how to do player props if you get to that sometime
outstanding vid...keep up the good work
I am getting an #REF error when pasting the formula for the data dump what am I doing wrong?
That means it is not recognizing what you are looking up to. Aka the first part of the vlookup before selecting the entire table
Hello I am going crazy trying to figure out how to add WRC+ to my model
Great video, lots of value!
Is it possible to go thru NHL player props?
@GuyBostonSport what do i win?
Does the data update automatically or do I have to manually update it daily?
it automatically updates from the site
this video is awesome man thank you so much. would definitely be interested in player prop or additional approaches!
Please do a player prop tool
Insanely helpful bro, I've always wanted to do this and could never find a video exactly like this. One thing thats great is that once you get the hang of it, you can experience with different numbers and kind of find a perfect model for you.
Exactly!!
Do you think you could make a football one?
Definitely on the to-do list
This is awesome
How would you get sheets to calculate a % based upon the score projection in order to have a line in my head vs what the books have? Lets say the model makes a underdog a favorite but the books have it reverse. I want to be able to see What I would make that line. Thanks!
Thanks!
Wow, thank YOU
This might be a dumb question but, does the data from the websites auto-update in the spreadsheet each day after games?
anything with the HTMLimport will yes!
@@GuyBostonSports very cool- And wow incredible video thanks for all the work !
great video. Would love to see and NFL and Possibly NHL model.
Let’s get a player prop going, that would be cool to see how you break it down
A player prop one would be freaking dope!
Great video! Thanks for sharing your knowledge!
This is so amazing bro. Thank you
No problem!
plz do strikeout model! we appreciate you man!
The one team I'm having a problem with now is Kansas City
This was great.
Throw in a cheeky drop down for the teams and the pitchers and this becomes insanely simple to enter the data. Great video
Gday, how can i get a copy of the NBA one please
great video. would love to see a player props one!
Any more to this series?