Historical Win % NBA Teams

[conetah]

Hey guys,

I have been surfing around the page quite a bit looking for some data. As so far for my data needs it has been great in satisfying my needs! Super great resource. Anyway I am looking to do some analysis and would like the Historical Win/Loss % of all NBA teams from around 1945 to today in an excel file. I have been trying to retrieve it from the Basketball database thing but I can't get it to export correctly into an excel document. If anyone knows where I can find this data pre-compiled I would greatly appreciate it!

Thank You very much!

[conetah]

I am also looking for regular season data. I have accessed databasebasketball and downloaded the zip. I am not sure if it is regular season or compiled data.

Thanks.

[Mike G]

You can copy a table into a text file such as Notepad; save the file; import the text file into Excel.
Excel will prompt you to import it as columns, separated by commas, etc.
If you use basketball-reference.com, you may find CSV above a table; clicking this, you get comma-separated values, which are easy to put into Excel.

They and many others refer to "win-loss %". Isn't it really just "Win%"?

[conetah]

on that basketball database? just copy the data and paste it?

[Mike G]

Yes, copy/paste the data into a text file.
In Excel, within the Data tab, find From Text.
Browse to find your saved text file and hit Import.
Try the options until you get it right.

Having not looked at the database-bb site for a while, I notice they seem to have stopped updating in 2011. So you may need to use b-r.com after all.
For example -- http://www.basketball-reference.com/teams/TOR/

The CSV 'button' changes the page from a table to comma-separated values, and this makes it easy for Excel to import it.

[conetah]

Sorry to be such a nuisance.

The basketball database which I refer is this one:
http://apbr.org/basketballdb.exe

Just entering, it looks like it is not copiable. It seems, as far an my knowledge is concerned, that it cannot be copied.

As far as http://www.basketball-reference.com/lea ... otals.html is concerned it looks like there are some good exportable files but nothing that contains all of the Win/loss % for each NBA team for each year.

The closest I have found was

http://www.databasebasketball.com/

but it only goes to 2009 and the wins and losses seem to contain the post season statistics which I don't want.

http://apbr.org/basketballdb.exe
Seems to have the data but it is impossible to retrieve.

If anyone has any hints on any of these websites or options I would be glad to hear. Thank you so much for you help. I appreciate. thanks mikeg for your help so far.

[conetah]

If anyone was curious I figured it out. I used the apbr.org/basketballdb.exe thing. After than I printed out the columns I needed into a .xps file. After that I went to cometdocs.com. (I highly recommend it) and converted it into excel. From there, because it did not convert 100% accurately I cleaned it up a little bit and I just saved it into a working form good enough to use for some analysis.

Thanks guys! This is a great resource on here. It was fascinating looking over the community here and some analysis.

As some background, I am an Econ student at BYU. There are some great professors there who are interested in basketball data at BYU and have done a few projects with such data. I am performing an analysis on basketball with similar data for a school project of mine.

On another note, one of the notable professors at BYU is Professor Joe Price (https://economics.byu.edu/Pages/Faculty ... Price.aspx). He wrote a popular paper titled "Racial Discrimination Among NBA Referees". It caused quite the controversy over at the NBA. I was curious what the popularity of the paper was outside my classmates. Have you guys heard of the paper?

[Crow]

I remember reading at least one NBA analysis paper out of BYU a few years ago that was huge and very good.

I heard about the racial discrimination paper in the media but have not read it.