How To Handicap Basketball Games In Excel | NBA NCAAB College Analytics

Спорт

How To Handicap Basketball Games In Excel | NBA NCAAB College Analytics
In this video, Kyle walks you through how to use this spreadsheet to predict the score of a basketball game using analytics.
Instagram - / kylekirms
Twitter - / kylekirms
#sportsbetting #nbapicks #freepicks

Пікірлер: 148

  • @KyleKirms
    @KyleKirms3 жыл бұрын

    I threw the one I use up on my website. kylekirms.com/shop It's at the bottom of the page. Completely free just click the link

  • @timothyclowney8685

    @timothyclowney8685

    2 жыл бұрын

    I have built the spread sheet but how do I get it to where when I put the numbers in the spreadsheet calculates the spread?

  • @PapaBaine

    @PapaBaine

    2 жыл бұрын

    Where

  • @sha4x_

    @sha4x_

    2 жыл бұрын

    @@timothyclowney8685 💯💯💯

  • @CheFyLite

    @CheFyLite

    Жыл бұрын

    @@timothyclowney8685 did you ever get a answer to this question ?

  • @austinross_1426

    @austinross_1426

    Жыл бұрын

    I can’t find it…

  • @c.z.heyward4759
    @c.z.heyward47593 жыл бұрын

    I’m loving this! I’m glad you incorporate SOS, a lot of people overlook that in capping.

  • @frst2373
    @frst23733 жыл бұрын

    This is the best video I’ve ever seen on KZread thank you so much you’re a blessing 🙏

  • @ej55033233
    @ej550332333 жыл бұрын

    Love your channel. My favorite. I do my early likes & lines & then compare mine against yours. Thank you for everything. I like every video you do to help.

  • @MajinBuusha
    @MajinBuusha3 жыл бұрын

    I didn't ask for this but I'm so glad you did this. Can't wait to see your Excel sheet link!

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    I pinned the comment to the top

  • @garyh5920
    @garyh59203 жыл бұрын

    I'm a numbers nerd and loved the video. Thanks for putting that up.

  • @evanm.4214
    @evanm.4214 Жыл бұрын

    Just came across this. Amazing video and very well described and extremely informative. Thank you!

  • @saiatoli1574
    @saiatoli15743 жыл бұрын

    Thanks a bunch Brother, this dude not just giving us the fish, he teaching us to fish. Good man💯

  • @timothyclowney8685

    @timothyclowney8685

    2 жыл бұрын

    I have built the spread sheet but how do I get it to where when I put the numbers in the spreadsheet calculates the spread?

  • @thegrayarea2225
    @thegrayarea22252 жыл бұрын

    Excellent break down. Wonder if there could be validity to using player stats for the categories you mentioned and apply it to prop bets....

  • @saiatoli1574
    @saiatoli15743 жыл бұрын

    I was gona ask you on insta to show us this but I thought it was too much to ask (no other capper would do this) It seems I have greatly underestimated your heart, thanks again my Brother💯

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    We are all on a team against the books. The better we all do... the better deals we will get. Sportsbooks make less money and have to compete harder for our business

  • @mickeysealtoe9719
    @mickeysealtoe97196 ай бұрын

    Just subscribed! Your explanations are very helpful.

  • @jazogby
    @jazogby3 жыл бұрын

    This is tremendous. Thanks Kyle

  • @chriswhitethunder8912
    @chriswhitethunder89123 жыл бұрын

    Awesome! Thanks for the breakdown!

  • @waverunnerenterprise8063
    @waverunnerenterprise8063 Жыл бұрын

    This was just the type of video I was looking for thank you

  • @jiwon9474
    @jiwon94743 жыл бұрын

    This is awesome🔥🔥 Thanks!!

  • @MisterEO_YT
    @MisterEO_YT2 жыл бұрын

    That was excellent , thank you for what you do

  • @maxaronovitz
    @maxaronovitz3 жыл бұрын

    I don't even have excel but i love the two websites you dropped. Can you keep plugging great resources... your a g btw

  • @saiatoli1574

    @saiatoli1574

    3 жыл бұрын

    He put some resource websites up on his instagram about a week ago, they're really good sites and the numbers are updated daily so you can get a more accurate read.

  • @timokatrilaka3038

    @timokatrilaka3038

    3 жыл бұрын

    @@saiatoli1574 could you please tell me which websites

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    I'm not sure which 2 he's referring to I have a bunch I like. But he's probably talking about NBAstuffer . com and hashtag basketball . Com

  • @AquaRush
    @AquaRush3 жыл бұрын

    this is goat talk no question asked

  • @idrissfofana5584
    @idrissfofana55843 жыл бұрын

    Kyle that’s such a great video and you simplified it a lot! Much appreciate it. I’ll get the spreadsheet and the sites you use to extract the raw data. 👍🏾

  • @timothyclowney8685

    @timothyclowney8685

    2 жыл бұрын

    I have built the spread sheet but how do I get it to where when I put the numbers in the spreadsheet calculates the spread?

  • @taylor7614

    @taylor7614

    2 жыл бұрын

    @@timothyclowney8685 for sure. did you figure it out?

  • @timothyclowney8685

    @timothyclowney8685

    2 жыл бұрын

    @@taylor7614 unfortunately i did not. Could you be of some assistance?

  • @DaltonHuff483

    @DaltonHuff483

    2 жыл бұрын

    @@timothyclowney8685 You have to put in different formulas which will calculate

  • @sha4x_

    @sha4x_

    2 жыл бұрын

    @@DaltonHuff483 how? Can you be a little more specific? 🤕 I have the same problem as dude

  • @yobirsprouts4857
    @yobirsprouts4857 Жыл бұрын

    Thanks a lot Kyle, great video as usual but pls tell us how you combine these variables. I couldn't find the spreadsheet on your site.

  • @ferick397
    @ferick3972 жыл бұрын

    You got a new subscriber!

  • @terrell757
    @terrell7572 жыл бұрын

    Great info

  • @TheeDonnieRey
    @TheeDonnieRey Жыл бұрын

    Bro... THANK YOU

  • @Loc403
    @Loc403 Жыл бұрын

    Love the best

  • @garywright4481
    @garywright4481 Жыл бұрын

    Kyle, where can I get the spreadsheet you mention in video, BTW I look forward to your videos everyday!

  • @BlackListEDz
    @BlackListEDz3 жыл бұрын

    This is the stuff.

  • @johnnields3428
    @johnnields3428 Жыл бұрын

    Might be a dumb question but I’m trying to get into this. How do you get the factor? Factor of what? I rewatched the video and that’s the only thing I don’t understand

  • @taylor7614
    @taylor76142 жыл бұрын

    HEY . APPRECIATE THE VIDEO . i'm typing in the numbers but nothing is happening at all. please tell me how to make it create this algrothim

  • @justme6998
    @justme69982 жыл бұрын

    Hey kyle do you still have the nba sprradsheet?

  • @Yephoid9
    @Yephoid93 жыл бұрын

    Nice!

  • @stayodd
    @stayodd2 жыл бұрын

    great video, one thing I recommend is using the 4 factors to create a win probability total and converting that percentage into American odds to try and find an edge against the book for live dogs. Capping against the spread is great but if you can find the edge in the live dog market you can find some great EV

  • @DaltonHuff483

    @DaltonHuff483

    2 жыл бұрын

    Jus now getting into betting lines, and handicapping games myself and curious about this. How do I take his 4 factors and creating it into a win probability and then converting it to find the the dogs? Amy help would be much appreciated, thanks.

  • @stayodd

    @stayodd

    2 жыл бұрын

    ​@@DaltonHuff483 you take the difference in each 4 factor, multiply by 100... this gives you a manageable number. You then do as follows ... eFG% * .50 , TOV% * .30 , oREB% * .15, FTRATE * .05 -- this gives you the 4 factors advantage. Ideally you would be creating your own predictive 4 factors for each game to help make this more predictive and less reactive.

  • @stayodd

    @stayodd

    2 жыл бұрын

    also adding in HCA is a big part of this

  • @DaltonHuff483

    @DaltonHuff483

    2 жыл бұрын

    @@stayodd Thanks, man. So to make sure I'm correct in theory you'll take each of the following four factors and do this... Find the difference between Team A and Team A allowed (defense) for each of the four factors and the same for Team B. Then multiply each "difference " from one another multiply by 100 then multiply again by the corresponding %. Then subtract all those differences from each other?? Does that give you the win probability for said team?

  • @DaltonHuff483

    @DaltonHuff483

    2 жыл бұрын

    Sorry if you dont understand this. I'm somewhat new to statistics, but really am trying to get a hang of it.

  • @poligone7450
    @poligone74503 жыл бұрын

    Thanks man. Great explanations. Do you use similar for College ball as well? It seems like similar logic would work

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    I use the same chart. I tweek it and add a little more weight towards offensive rebounding for college games. Tend to have more success that way. But yeah this is for all basketball

  • @benkotylak2377

    @benkotylak2377

    3 жыл бұрын

    @@KyleKirms where do you find college ball stats ?

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    website I like is called CBB analytics. It's a paid one but they give you a 30 day free trial. Be careful tho and remember that it's FORCED turnover % on that site they list just "turnover %"... so for that category you have to switch opponents and teams

  • @jazogby

    @jazogby

    3 жыл бұрын

    I tried to push some numbers through the template but used my KenPom members subscription. Obviously great stats and a NCAABB must have but I don’t love its lack of filters (last 5 games as an example). I’ll have to give this other site a look.

  • @jazogby

    @jazogby

    3 жыл бұрын

    In addition to filtering by sample size (5 games, etc.) I struggle too with KenPom is what SOS metric to use. Any thoughts or suggestions?

  • @ChrisKessinger
    @ChrisKessinger6 ай бұрын

    Is there a similar site for NCAAB to get stats for the last 5 games?

  • @donniecole379
    @donniecole3792 жыл бұрын

    Is the spreadsheet still available to download?

  • @Gmel405
    @Gmel4053 ай бұрын

    In case you’re watching this years later like me, this definitely hit. ORL lost by 6 that night lol

  • @rogeliomontenegro8259
    @rogeliomontenegro82592 жыл бұрын

    Where can I download you spread sheet?

  • @bootleggable
    @bootleggable3 жыл бұрын

    hey the numbers on NBAstuffer and NBA official stats section are different, also when u plug in the official stats the number generated is different from NBAstuffer’s figures. i believe manually calculating gives a more accurate value then those posted on nbastuffer imo. any other resources to cross examine the coefficient generated?

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    Yo props for being thorough.... I am the same way I will check 5 different sources. I don't see those stats on NBA .Com stats tho I don't see EFG or FTO. Am I missing em? Yeah to do it manually would be the best way for sure

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    As far as other resources... I switch it up I don't have a set source. I've been using NBA stuffer recently. But anywhere that gives you those analytics accurately will work fine

  • @bootleggable

    @bootleggable

    3 жыл бұрын

    @@KyleKirms advanced stats four figure on nba.com

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    @@bootleggable can I get your name on social media or email? I like your style

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    @@bootleggable weird... they are really really close but not quit exact. Just tested 4 teams out and it was like 53.8 on NBA and 53.7 on NBA stuffer. It's close enough but I agree it pisses. Me off why aren't they the samr

  • @christianralph2259
    @christianralph22593 жыл бұрын

    Thanks man! First time of using this Got 4-0 tonight! chi Phi Por Orl getting all the points!🎉

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    👍👍👍 nice hits my man!

  • @quintonburke9108

    @quintonburke9108

    2 жыл бұрын

    How you been doing with this formula now

  • @timothyclowney8685

    @timothyclowney8685

    2 жыл бұрын

    I have built the spread sheet but how do I get it to where when I put the numbers in the spreadsheet calculates the spread?

  • @Jbank727
    @Jbank727 Жыл бұрын

    Wow. You just taught people to fish! Thank you man

  • @bristevenson866
    @bristevenson8663 жыл бұрын

    This video is the SAUCE

  • @Gmel405
    @Gmel4052 ай бұрын

    Can I get spreadsheet or the formula for the spread projection?

  • @frst2373
    @frst23733 жыл бұрын

    Can you do one on totals please?

  • @rickcarroll6138
    @rickcarroll6138 Жыл бұрын

    Any chance you can share what values you apply to certain "Extras".{e.g. Injury = a value, Traveling = a value etc...}

  • @KyleKirms

    @KyleKirms

    Жыл бұрын

    That part is personal preference. Honestly the whole thing is personal preference, in a way. You might find that when teams are missing their #1 rebounders… you have a higher hit rate. I might find that when I follow the turnover rate numbers, I’m hitting at a higher rate. It’s all a process of trying to stay consistent, find patterns and always be open minded to change. You might view 1 player being out as a 3 point difference… and I might not even view it as a factor.

  • @kadakome4417
    @kadakome44173 жыл бұрын

    Thanks for this video,but how you get this factor number?

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    Just type into Google 4 analytics basketball handicap

  • @kadakome4417

    @kadakome4417

    3 жыл бұрын

    @@KyleKirms Ok,thx Kyle.

  • @alleyezontheline8349
    @alleyezontheline83493 жыл бұрын

    Anything for any other sports

  • @bristevenson866
    @bristevenson8663 жыл бұрын

    Is the excel sheet still up ?

  • @setpiecesolution
    @setpiecesolution2 жыл бұрын

    How do you do this for NCAA?

  • @RussellGrande
    @RussellGrande3 жыл бұрын

    Can the spreadsheet be used in Google Sheets as well?

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    Thsts what I use Google sheets... honestly I'm not sure. I had my girlfriend convert it to xls... I dk how to send you the Google sheets file without letting you edit my original document you know? Like I dk how to send you a copy of 8t

  • @dennisraymartmacapobre3220
    @dennisraymartmacapobre32203 жыл бұрын

    How to comput over under hehe ?

  • @kevinoverholtzer3126
    @kevinoverholtzer3126 Жыл бұрын

    I like it but it seems like i always get a number like 3 or lower so it is almost always telling you to bet for the dog

  • @bestvideosaround1155
    @bestvideosaround11552 жыл бұрын

    What site is that

  • @Zt1Fox
    @Zt1Fox11 ай бұрын

    Whice type spreadsheet?

  • @user-bl7yv1wn2w
    @user-bl7yv1wn2w Жыл бұрын

    I can't find the spreadsheet in your tread. Can you email it to me? Thank you in advance! I love your videos

  • @RollinSchidt
    @RollinSchidt Жыл бұрын

    Does this work?

  • @johnmitchem2124
    @johnmitchem2124 Жыл бұрын

    How can I get spreadsheet

  • @evergreendiy3373
    @evergreendiy33732 жыл бұрын

    You are the fucking man dude

  • @hunterzinthehype8965
    @hunterzinthehype89653 жыл бұрын

    🔔

  • @TCS088
    @TCS088 Жыл бұрын

    This is useless without the formulas in the factor column. Do you have that info or a link to download the spreadsheet?

  • @KyleKirms

    @KyleKirms

    Жыл бұрын

    Yes. I give it away to my VIP subscribers. 22-23’s isn’t up yet tho. It’ll be up in 2 weeks

  • @CRYPTO_KHAOS
    @CRYPTO_KHAOS3 жыл бұрын

    Link please. U da man

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    Pinned comment at the top

  • @BoysKasa
    @BoysKasa3 жыл бұрын

    Care to share your excel template please?

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    I just pinned the comment to the top of these comments

  • @BoysKasa

    @BoysKasa

    3 жыл бұрын

    @@KyleKirms thank you soo much man... btw it's @iamselasie on Twitter haha

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    Ohhh whatsup man?? Awesome thanks for checking the video out

  • @BoysKasa

    @BoysKasa

    3 жыл бұрын

    @@KyleKirms blessed, man. working on tonight's cap. I'm betting 4 games today.

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    I'm gonna bet all 6 hahaha. Such a bad move by me

  • @tattooquis5392
    @tattooquis53923 жыл бұрын

    Yoyo

  • @stevepaglia6982
    @stevepaglia6982 Жыл бұрын

    Jersey baby I bet in ac alot u ever down there

  • @azmendozafamily
    @azmendozafamily Жыл бұрын

    I use TS% instead of eFG%

  • @cheeseworld6956
    @cheeseworld69562 ай бұрын

    I’m on the site and don’t see Last five games

  • @teamdinei7
    @teamdinei7 Жыл бұрын

    How calculate factor... i'm lost

  • @spookyofficer1417
    @spookyofficer1417 Жыл бұрын

    I still cant understand about the extras.

  • @tjnevercared8072
    @tjnevercared80723 жыл бұрын

    Can you give the link to that generator

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    Pinned comment at the top

  • @sethuser1731
    @sethuser17312 жыл бұрын

    Excel isn’t working for me

  • @leytontisalona1835
    @leytontisalona1835 Жыл бұрын

    I got 2 million on bengals half and game

  • @johnnields3428
    @johnnields3428 Жыл бұрын

    Guys I figured out the secret “formula” for factor 😂 look at the numbers think about the info he tells you… anyone need help let me know

  • @LIGHT7CODE7
    @LIGHT7CODE7 Жыл бұрын

    I think your factor table is way off. Pacers at Celtics. Spread is -8 for the Celtics. Your sheet spits out basically an even number for the spread.....so the game is really even? I think you need to relook at your values.

  • @KyleKirms

    @KyleKirms

    Жыл бұрын

    This is last year’s video and last year’s sheet man

  • @Keys222thecity

    @Keys222thecity

    5 ай бұрын

    @@KyleKirmsdo you have a sheet for this year?

  • @numbersguy0824
    @numbersguy08243 жыл бұрын

    Dope video. NERD ALERT

  • @KyleKirms

    @KyleKirms

    3 жыл бұрын

    🤣🤣🤣🤣

  • @lemuelconde
    @lemuelconde Жыл бұрын

    Only apply this to lowkey games, games that don't draw a big crowd. Why? Because when "Vegas" comes to play all of this is USELESS. MAFIA is real in sports betting and it's up to you if you can ride it. Remember this always.... Sports Betting is a Business.

  • 2 жыл бұрын

    ...For Totals?

  • @2011sliverdude
    @2011sliverdude2 жыл бұрын

    He lost the next day lol

Келесі