Search found 14 matches
- Mon Sep 12, 2016 4:37 am
- Forum: APBRmetrics
- Topic: RAPM request thread
- Replies: 155
- Views: 290089
Re: RAPM request thread
Is there any level of RAPM from the MJ era? I noticed awhile back JE you said you didn't have the data to get this done from say 89. What is the earliest year RAPM we have? It goes back to 1996-97. Here's 1996-97. Reading through this thread over at realgm I was surprised to find that we have NPI R...
- Mon Aug 15, 2016 7:16 pm
- Forum: APBRmetrics
- Topic: Old Play by Play Files
- Replies: 4
- Views: 5724
Re: Old Play by Play Files
Here, certain people have them. On the web, you can find some sites that sell PBP files for quite a bit of Money. But they are not matchup files like you can find in the basketballvalue.com. I've only ever found 2004-present PbP files for sale online. And they're expensive, like you said, especiall...
- Sun Aug 14, 2016 4:32 am
- Forum: APBRmetrics
- Topic: Old Play by Play Files
- Replies: 4
- Views: 5724
Old Play by Play Files
So, I've been using play by play files to gather information that is usually not on stat websites (ie. what percent of a player's own misses he rebounds), and I am wondering if any one has the 2001-2005 PbP files. I've found several past threads with links to the downloads but unfortunately all the ...
- Wed Aug 10, 2016 9:40 am
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Re: Setting Up Excel File for RAPM
Could you be a little more clear about how different is "quite different"? Your list of reasons seem valid to me, but barring some fairly large differences in PBP cleaning one would hope that the rest don't lead to anything too drastic. I could perhaps shed some light on the difference: (...
- Tue Aug 09, 2016 12:26 am
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Re: Setting Up Excel File for RAPM
As for the guide, when I have enough time I'll read it again and point out the errors in that article because I tried to learn how to calculate APM or RAPM by reading that article first and eventually found out the problems. I think your right. Eli's guide uses the formula =IF(ISNUMBER(FIND(AY$1&am...
- Mon Aug 08, 2016 7:50 pm
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Re: Setting Up Excel File for RAPM
It's been a very long time but If I remember correct, you're doing it wrong. You should suppose to use one formula to find the best lambda and player coefficients according to that. It should be like; file = read.table "("c:\.......\file.csv", sep=";" , header="TRUE&qu...
- Sun Aug 07, 2016 11:56 pm
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Re: Setting Up Excel File for RAPM
It appears you didn't use lambda.min or you made a miscalculation at cross-validation stage. Because RAPM values are too high thanks to your small lambda value. As for the list I don't remember 2009's RAPM but I can say it's not correct. Some names just shouldn't be there at the top. Here's the cod...
- Sat Aug 06, 2016 9:51 pm
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Re: Setting Up Excel File for RAPM
I ran the ridge regression for the 2009 regular season with standardize=FALSE and alpha=0. Lambda from 10-fold cross validation was about 0.39. Here are the results. I can't tell if the "weird" results are just because it's single year, NPI, or because of issues with glmnet. Sorry for the ...
- Sat Aug 06, 2016 3:20 am
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Re: Setting Up Excel File for RAPM
Yes, your current structure would work fine. Just do IF(OR(Z$1=$F1,Z$1=$G1,Z$1=$H1,Z$1=$I1,Z$1=$J1),1,IF(OR(Z$1=$K1,Z$1=$L1,Z$1=$M1,Z$1=$N1,Z$1=$O1),-1,0)). There may be a better construction for speed of calculation, but this method is constructed similarly to the last one. Thanks, that worked. I ...
- Thu Aug 04, 2016 9:30 pm
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Re: Setting Up Excel File for RAPM
I haven't read that guide but I just looked at the page roughly and saw "glmnet". That library produces wrong results because of that supposedly efficient method it uses to calculate ridge regression. Unfortunately I haven't seen any other library that includes weighted ridge regression c...
- Wed Aug 03, 2016 10:36 pm
- Forum: APBRmetrics
- Topic: The Lie That's Called Shooting Efficiency
- Replies: 14
- Views: 16003
Re: The Lie That's Called Shooting Efficiency
I sometimes wonder why do people give too much credit to shooting efficiency? I agree to an extent. It's easy to see how comparing the shooting efficiency of two players can be misleading: (1) If one player takes a higher number of "bail out" shots. (2) If one player is moreso the recipie...
- Wed Aug 03, 2016 9:08 pm
- Forum: APBRmetrics
- Topic: Setting Up Excel File for RAPM
- Replies: 34
- Views: 55702
Setting Up Excel File for RAPM
Hey guys, I've been trying to compute some RAPM, using Jacob Frankel's guide , but I am unsure how to set up the excel file for the computations. I've downloaded the 2009 regular season matchups and player ID's from basketballvalue , extracted them, and opened them in an excel file (tab delimited). ...
- Tue Mar 11, 2014 9:43 pm
- Forum: APBRmetrics
- Topic: Something Doesn't Add Up: Synergy Data
- Replies: 2
- Views: 4172
Re: Something Doesn't Add Up: Synergy Data
I am counting the free throw attempts correctly. He went to the line ~23 times. 11 of those times he only received 1 free throw attempt. On the other 12 he received two. So he received 24+11=35 attempts. I was thinking that goaltending might be an explanation, but I doubt that alone would account fo...
- Tue Mar 11, 2014 1:53 am
- Forum: APBRmetrics
- Topic: Something Doesn't Add Up: Synergy Data
- Replies: 2
- Views: 4172
Something Doesn't Add Up: Synergy Data
Note: This post uses information that is free and accessible to everyone via http://www.mysynergysports.com. I recently signed up to Synergy Sports Technology and immediately noticed that under most every category for every player there are certain unaccounted points and plays. Since the start of th...