Search found 14 matches

by KwameBeanJordan
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...
by KwameBeanJordan
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...
by KwameBeanJordan
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 ...
by KwameBeanJordan
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: (...
by KwameBeanJordan
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...
by KwameBeanJordan
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...
by KwameBeanJordan
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...
by KwameBeanJordan
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 ...
by KwameBeanJordan
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 ...
by KwameBeanJordan
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...
by KwameBeanJordan
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...
by KwameBeanJordan
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). ...
by KwameBeanJordan
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...
by KwameBeanJordan
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...