As per request, I've built an NBA workbook that uses each teams Ratings, Schedule Strength, and Points Per Game in a formula to predict outcomes for each individual matchup.
The sheet is in BETA testing, but should serve as an excellent resource to handicap your games. The sample game on the Matchup Page is from Chicago @ Atlanta, December 9th, 2009.
Statistics are taken from basketball-reference, and you can easily copy and paste these statistics into the sheet for basically plug and play results.
Shameless plug: I run actionreverse.com, and most of my work involves the NFL and NCAAF using the YPPT & HFA formula and system filters, which is the basis behind the NBA sheet. I have NFL and NCAAF matchup sheets available for free download, and will only be putting this NBA sheet up on Covers for the time being, until it is back tested with some solid proven advantages. Let me know how you guys use it, and use this thread to track how you're playing it also if you choose.
The sheet is available here: NBA Matchup Analysis Workbook
0
To remove first post, remove entire topic.
As per request, I've built an NBA workbook that uses each teams Ratings, Schedule Strength, and Points Per Game in a formula to predict outcomes for each individual matchup.
The sheet is in BETA testing, but should serve as an excellent resource to handicap your games. The sample game on the Matchup Page is from Chicago @ Atlanta, December 9th, 2009.
Statistics are taken from basketball-reference, and you can easily copy and paste these statistics into the sheet for basically plug and play results.
Shameless plug: I run actionreverse.com, and most of my work involves the NFL and NCAAF using the YPPT & HFA formula and system filters, which is the basis behind the NBA sheet. I have NFL and NCAAF matchup sheets available for free download, and will only be putting this NBA sheet up on Covers for the time being, until it is back tested with some solid proven advantages. Let me know how you guys use it, and use this thread to track how you're playing it also if you choose.
The sheet is available here: NBA Matchup Analysis Workbook
Looks great, Can't find about S.O.S and Ratings on basketball-reference, i guess S.O.S in your spreadsheet won't change but where should i look for Ratings? Thanks
0
Looks great, Can't find about S.O.S and Ratings on basketball-reference, i guess S.O.S in your spreadsheet won't change but where should i look for Ratings? Thanks
Looks great, Can't find about S.O.S and Ratings on basketball-reference, i guess S.O.S in your spreadsheet won't change but where should i look for Ratings? Thanks
S.O.S. and Ratings can be found here: https://www.usatoday.com/sports/sagarin.htm Not sure how often the NBA is updated (probably everyday) but that's where they're available.
0
Quote Originally Posted by hstlaur:
Looks great, Can't find about S.O.S and Ratings on basketball-reference, i guess S.O.S in your spreadsheet won't change but where should i look for Ratings? Thanks
S.O.S. and Ratings can be found here: https://www.usatoday.com/sports/sagarin.htm Not sure how often the NBA is updated (probably everyday) but that's where they're available.
Indiana Pacers 100 - New Jersey Nets 99 Houston Rockets 103 - Philadelphia 76ers 97 Atlanta Hawks 107 - Toronto Raptors 101 Dallas Mavericks 101 - Miami Heat 98 Oklahoma City Thunder 102 - Memphis Grizzlies 98 Cleveland Cavaliers 97 - Portland Trailblazers 94 New Orleans Hornets 106 - New York Knicks 101 Golden State Warriors 105 - Chicago Bulls 103 San Antonio Spurs 98 - Charlotte Bobcats 96 Los Angeles Lakers 109 - Minnesota Timberwolves 89 Orlando Magic 108 - Phoenix Suns 104
Total Results ATS: 6-4-1, 60%
0
12/11/09 Recap: NBA Predictive Box Score System:
Indiana Pacers 100 - New Jersey Nets 99 Houston Rockets 103 - Philadelphia 76ers 97 Atlanta Hawks 107 - Toronto Raptors 101 Dallas Mavericks 101 - Miami Heat 98 Oklahoma City Thunder 102 - Memphis Grizzlies 98 Cleveland Cavaliers 97 - Portland Trailblazers 94 New Orleans Hornets 106 - New York Knicks 101 Golden State Warriors 105 - Chicago Bulls 103 San Antonio Spurs 98 - Charlotte Bobcats 96 Los Angeles Lakers 109 - Minnesota Timberwolves 89 Orlando Magic 108 - Phoenix Suns 104
Thanks for sharing your work. One quick question, underneath the home and awat team input fields there are two grey line next to each other. You example has inputs for atlanta and chicago two times but with different inputs. What values go into these fields?
thanks again
0
Hey Action
Thanks for sharing your work. One quick question, underneath the home and awat team input fields there are two grey line next to each other. You example has inputs for atlanta and chicago two times but with different inputs. What values go into these fields?
Thanks for sharing your work. One quick question, underneath the home and awat team input fields there are two grey line next to each other. You example has inputs for atlanta and chicago two times but with different inputs. What values go into these fields?
thanks again
I've actually updated the sheet, this one just using the team statistics. (The player statistics in the first sheet were not fully implemented and it was just extra work)
The new sheet you simply update the Team Statistics page like the first sheet, get the Ratings and S.O.S. from the link provided above, and as far as the Matchup Page goes you only have to copy & paste stats for the Home Team & Away Team, and then insert the ratings in the boxes. Try the new sheet as I'm not exactly sure about the old sheet.
Matchup Sheet Download
0
Quote Originally Posted by pdg893:
Hey Action
Thanks for sharing your work. One quick question, underneath the home and awat team input fields there are two grey line next to each other. You example has inputs for atlanta and chicago two times but with different inputs. What values go into these fields?
thanks again
I've actually updated the sheet, this one just using the team statistics. (The player statistics in the first sheet were not fully implemented and it was just extra work)
The new sheet you simply update the Team Statistics page like the first sheet, get the Ratings and S.O.S. from the link provided above, and as far as the Matchup Page goes you only have to copy & paste stats for the Home Team & Away Team, and then insert the ratings in the boxes. Try the new sheet as I'm not exactly sure about the old sheet.
quick stupid question - in the input fields for defense - do you use the data from the team opponents statistics?
I capped the LA game tonight at 102-92 is that correct?
thanks
Yep, "Team Statistics" for Offense, "Opponent Statistics" for Defense.
Let me know how you make out w/ the sheet as right now I will not be tracking it, but it would be nice for someone to post their sheet results and compare them to the final results like how I started.
0
Quote Originally Posted by pdg893:
Thanks Action!
quick stupid question - in the input fields for defense - do you use the data from the team opponents statistics?
I capped the LA game tonight at 102-92 is that correct?
thanks
Yep, "Team Statistics" for Offense, "Opponent Statistics" for Defense.
Let me know how you make out w/ the sheet as right now I will not be tracking it, but it would be nice for someone to post their sheet results and compare them to the final results like how I started.
Awesome work Action, yeah i was thinking the same thing about the player stats..that would be really a lot of work...i just about have the TAR system done on a sheet and also sergios ppg also on a sheet...just cleaning it up...its not as professional as your sheet...i can send you the systems if you want, as another tool for your arsenal...lmk...thanks again for your hard work...
0
Awesome work Action, yeah i was thinking the same thing about the player stats..that would be really a lot of work...i just about have the TAR system done on a sheet and also sergios ppg also on a sheet...just cleaning it up...its not as professional as your sheet...i can send you the systems if you want, as another tool for your arsenal...lmk...thanks again for your hard work...
Hey Action, got a question, how much of an impact does team rating and sos play into the predictive score...can you explain the factors of what they play into the predictive outcome. thanks in advanced..
0
Hey Action, got a question, how much of an impact does team rating and sos play into the predictive score...can you explain the factors of what they play into the predictive outcome. thanks in advanced..
Tnx, AR, for this tool, and tnx, pdg893, for posting calculations - for some reason, I can't get it to work at my place.
So, for 16.12. it went 10-2 SU, with a few scores predicted almost to the point! I guess you got a pretty good starting point here, AR, when you find the time perhaps you could work on this some more.
Until then, good job!
P.S. Pdg893, I hope you continue posting these calculations.
0
Tnx, AR, for this tool, and tnx, pdg893, for posting calculations - for some reason, I can't get it to work at my place.
So, for 16.12. it went 10-2 SU, with a few scores predicted almost to the point! I guess you got a pretty good starting point here, AR, when you find the time perhaps you could work on this some more.
Until then, good job!
P.S. Pdg893, I hope you continue posting these calculations.
17-2 SU 89.5% and 9-7-3 ATS 43.7% I have not been tracking the total results but have noticed that the prediction is usually very close to the line for the total. Action, did you say you have another spreadsheet for these calculations? I am wondering how to factor in travel, B2b games (with travel) and fatigue from long road trips into the prediction.
0
results for 12/16
10-2 SU and 6-5-1 ATS
since starting on 12/15
17-2 SU 89.5% and 9-7-3 ATS 43.7% I have not been tracking the total results but have noticed that the prediction is usually very close to the line for the total. Action, did you say you have another spreadsheet for these calculations? I am wondering how to factor in travel, B2b games (with travel) and fatigue from long road trips into the prediction.
I have PHO 100 POR 101 for this game ... same results for first 2 games, i dont know whats wrong ... but thought it could be useful to know if plan going for the under ....
0
Quote Originally Posted by pdg893:
Predictions for 12/17
Knicks 99 Chicago 100 line chicago -3 203
Magic 101 Miami 97 line magic -4 200
Phoenix 94 Portland 95 line portland -2 202.5
I have PHO 100 POR 101 for this game ... same results for first 2 games, i dont know whats wrong ... but thought it could be useful to know if plan going for the under ....
I have PHO 100 POR 101 for this game ... same results for first 2 games, i dont know whats wrong ... but thought it could be useful to know if plan going for the under ....
I already went OVER for 4 units, so I'm kinda hoping you'll be closer to the actual scoreline.
Either way, thanks you both for sharing the predictions with us, guys. However, all of these games appear to close to call. Even SU.
0
Quote Originally Posted by hstlaur:
I have PHO 100 POR 101 for this game ... same results for first 2 games, i dont know whats wrong ... but thought it could be useful to know if plan going for the under ....
I already went OVER for 4 units, so I'm kinda hoping you'll be closer to the actual scoreline.
Either way, thanks you both for sharing the predictions with us, guys. However, all of these games appear to close to call. Even SU.
If you choose to make use of any information on this website including online sports betting services from any websites that may be featured on
this website, we strongly recommend that you carefully check your local laws before doing so.It is your sole responsibility to understand your local laws and observe them strictly.Covers does not provide
any advice or guidance as to the legality of online sports betting or other online gambling activities within your jurisdiction and you are responsible for complying with laws that are applicable to you in
your relevant locality.Covers disclaims all liability associated with your use of this website and use of any information contained on it.As a condition of using this website, you agree to hold the owner
of this website harmless from any claims arising from your use of any services on any third party website that may be featured by Covers.