Best Website for Exportable NHL Data

overpass · Oct 11, 2012

Spreadsheet with historical adjusted and situational stats

Edit: 2013 update.

Here's a copy of the spreadsheet I use for historical regular season adjusted and situational stats. Link goes to a zip file that includes an Excel spreadsheet and a text file with documentation.

The stats go back to the 1967-68 NHL season. They include official NHL stats, special teams scoring stats taken from the Hockey Summary Project data, and advanced stats derived from the official stats.

The numbers are updated through the 2011-2012 season. While there are more detailed numbers available for analyzing recent seasons, I've included them here for the sake of completeness and historical comparison.

Some selections from the stats included are presented below.

Even strength points since 1967-68

Player | ESG | ESA | ESP
Wayne Gretzky | 617 | 1205 | 1823
Mark Messier | 452 | 708 | 1163
Marcel Dionne | 478 | 618 | 1105
Jaromir Jagr | 465 | 627 | 1092
Steve Yzerman | 440 | 636 | 1080
Ron Francis | 349 | 687 | 1036
Bryan Trottier | 344 | 614 | 971
Joe Sakic | 388 | 573 | 961
Mario Lemieux | 406 | 546 | 954
Mark Recchi | 364 | 583 | 947

Even strength assists from 1967-68 to 1986-87 are from Hockey Summary Project boxscore data.

Adjusted even strength points since 1967-68
Player | $ESG | $ESA | $ESP

Wayne Gretzky | 597 | 1190 | 1787
Jaromir Jagr | 584 | 779 | 1363
Mark Messier | 470 | 755 | 1225
Steve Yzerman | 473 | 703 | 1176
Joe Sakic | 469 | 698 | 1167
Mark Recchi | 432 | 710 | 1142
Ron Francis | 377 | 761 | 1138
Marcel Dionne | 452 | 593 | 1045
Mats Sundin | 463 | 578 | 1041
Teemu Selanne | 505 | 523 | 1028

The adjustment is to a league scoring level of 200 ESG per team per season. No adjustment is made for scoring distribution.

Power play points since 1967-68

Player | PPG | PPA | PPP
Wayne Gretzky | 204 | 682 | 886
Ray Bourque | 173 | 586 | 759
Ron Francis | 188 | 543 | 731
Al MacInnis | 166 | 557 | 723
Mario Lemieux | 236 | 463 | 699
Paul Coffey | 135 | 523 | 658
Marcel Dionne | 234 | 402 | 636
Joe Sakic | 205 | 426 | 631
Phil Housley | 129 | 480 | 609
Steve Yzerman | 202 | 390 | 592

As with even strength assists, power play assists from 1967-68 to 1986-87 are from Hockey Summary Project boxscore data.

Adjusted power play points since 1967-68

Player | $PPG | $PPA | $PPP
Wayne Gretzky | 206 | 694 | 901
Ray Bourque | 185 | 608 | 793
Ron Francis | 188 | 549 | 737
Al MacInnis | 173 | 564 | 737
Phil Esposito | 303 | 384 | 687
Joe Sakic | 216 | 463 | 679
Nicklas Lidstrom | 152 | 506 | 657
Teemu Selanne | 280 | 367 | 647
Marcel Dionne | 226 | 409 | 635
Paul Coffey | 131 | 500 | 631

Adjusted to a league scoring level of 70 PPG per team per season.

Shorthanded points since 1967-68

Player | SHG | SHA | SHP
Wayne Gretzky | 73 | 76 | 149
Mark Messier | 63 | 79 | 142
Steve Yzerman | 50 | 33 | 83
Jari Kurri | 39 | 43 | 82
Mario Lemieux | 48 | 22 | 70
Dave Poulin | 39 | 31 | 70
Bobby Clarke | 32 | 37 | 69
Sergei Fedorov | 36 | 27 | 63
Ed Westfall | 23 | 38 | 61
Derek Sanderson | 34 | 22 | 56

Shorthanded assists from 1967-68 through 1986-87 are from Hockey Summary Project boxscore data.

Adjusted shorthanded points since 1967-68

Player | $SHG | $SHA | $SHP
Wayne Gretzky | 68 | 71 | 138
Mark Messier | 62 | 76 | 138
Bobby Clarke | 42 | 50 | 93
Ed Westfall | 33 | 47 | 79
Steve Yzerman | 45 | 31 | 76
Jari Kurri | 34 | 37 | 71
Derek Sanderson | 47 | 22 | 69
Bill Barber | 41 | 28 | 69
Sergei Fedorov | 39 | 26 | 65
Todd Marchant | 34 | 26 | 61

Adjusted to a league scoring level of 10 SHG per team per season.

Adjusted even strength points per season

Minimum 500 NHL games played. "Per season" means per season's worth of games - i.e. 82 games, 80 games, etc. Basically a per-game measure scaled to a season.

Adjusted power play points per season

overpass · Oct 11, 2012

On-ice even strength goals for

Estimated from official TGF, PGF, TGA, PGA data. Formula is ESGF = TGF - PGF - (PGA/TmPGA*TmSHGF)

On-ice even strength goals against

Estimated from official TGF, PGF, TGA, PGA data. Formula is ESGA = TGA - PGA - (PGF/TmPGF*TmSHGA)

Adjusted even strength goals for

$ESGF is simply ESGF adjusted to a league scoring level of 200 ESG per team per season.

Adjusted even strength goals against

Even strength GF/GA ratio (on-ice)

Minimum 500 GP.

Even strength GF/GA ratio (off-ice)

Minimum 500 GP. Calculation weights each season by ($ESGF+$ESGA), so the weighting is identical to R-ON.

Adjusted plus-minus

Presented and discussed more fully in another thread. Briefly, it adjusts for scoring level and is based on comparing a player's R-ON to his R-OFF.

Even-strength plus-minus

Plus-minus adjusted for scoring level and removing shorthanded goals, but without the team strength adjustment.

Even strength usage (total)

A measure of the share of his team's even strength goals that a player was on the ice for over his career.

Even strength usage (rate)

A measure of the share of his team's even strength goals that a player was on the ice for over his career - per game. Minimum 500 GP.

Power play usage (total)

A measure of the share of his team's power play goals that a player was on the ice for over his career.

Power play usage (rate)

A measure of the share of his team's power play goals that a player was on the ice for over his career - per game. Minimum 500 GP.

Shorthanded usage (total)

A measure of the share of his team's power play goals against that a player was on the ice for over his career. Can be used as an estimate of a shorthanded role.

Shorthanded usage (rate)

A measure of the share of his team's power play goals against that a player was on the ice for over his career - per game. Can be used as an estimate of a shorthanded role. Minimum 500 GP.

TheKingSlayer · Nov 2, 2012

Hey guys,

I was just wondering if there were any websites that has the option to export their data to Excel (or have downloadable content). I know the information I am looking for is all on NHL.com, but it does not seem like I can download it directly to Excel.

Does anyone have a website or method that they use to export the data they need?

Any help is greatly appreciated.[/B]

fedfed · Nov 2, 2012

Hockey-Reference.com allowas you to download data in CSV format.

TheKingSlayer · Nov 2, 2012

fedfed said:
Hockey-Reference.com allowas you to download data in CSV format.

Thanks, I had a look at the site and they seem to be very limited as to tracking actual stats. For some reason, they do not have hits, takeaways/giveaways, Penalty shots etc.

Czech Your Math · Nov 7, 2012

Behindthenet.com has some individual advanced stats for recent seasons and league stats on a more historical basis.

Czech Your Math · Nov 7, 2012

overpass said:
Here's a copy of the spreadsheet I use for historical regular season adjusted and situational stats. Link goes to a zip file that includes an Excel spreadsheet and a text file with documentation.

MOD NOTE: I merged your post into this thread since it's an Excel resource, and so that it may get more exposure over the long term. Let one of us know if you'd rather it was merged into a different thread (such as Adjusted Plus-Minus or Adjusted ES Production) or if you'd prefer it to remain a stand alone thread.

Dalton · Nov 10, 2012

Thanks op and Czech.

overpass · Aug 20, 2013

Updated for 2013 in OP.

socratic · Sep 16, 2013

This is incredible, and thanks or doing it. I can't seem to find stats for "shots" in here, or shooting percentage. am I just missing those somewhere?

seventieslord · Sep 17, 2013

socratic said:
This is incredible, and thanks or doing it. I can't seem to find stats for "shots" in here, or shooting percentage. am I just missing those somewhere?

it's not in this sheet.

BraveCanadian · Sep 18, 2013

overpass said:
Updated for 2013 in OP.

Awesome.

Thanks overpass

TheDevilMadeMe · May 5, 2014

Note that if anyone is trying to calculate 2014 numbers, the updated 2013 spreadsheet adjusts to 180 even strength goals per team per season, not 200 as the OP indicates (the 2012 spreadsheet did you 200 ES goals per team per season).

~~Conveniently, it looks like NHL teams scored exactly 180 ES goals per team per season in 2013-14, so the raw even strength point totals can be used.~~

overpass · May 7, 2014

TheDevilMadeMe said:
Note that if anyone is trying to calculate 2014 numbers, the updated 2013 spreadsheet adjusts to 180 even strength goals per team per season, not 200 as the OP indicates (the 2012 spreadsheet did you 200 ES goals per team per season).

Conveniently, it looks like NHL teams scored exactly 180 ES goals per team per season in 2013-14, so the raw even strength point totals can be used.

Yep. I thought it gave more aesthetically pleasing results.

I count 170 ESG/team, TDMM. 225 total, 170 ES, 48 PP, 7 SH. Were you including shootout "goals" from the NHL standings?

TheDevilMadeMe · May 10, 2014

overpass said:
Yep. I thought it gave more aesthetically pleasing results.

I count 170 ESG/team, TDMM. 225 total, 170 ES, 48 PP, 7 SH. Were you including shootout "goals" from the NHL standings?

I might have just subracted wrong. :laugh:

I was using h-r which has the same numbers you have: http://www.hockey-reference.com/leagues/NHL_2014.html

TheDevilMadeMe · Sep 20, 2015

2014 - NHL teams averaged 170 ES points, 48 PP points, 7 SH points
2015 - NHL teams averaged 171 ES points, 47 PP points, 6 SH points

Search

Search

Best Website for Exportable NHL Data

overpass

Registered User

overpass

Registered User

TheKingSlayer

He was in the way!

fedfed

@FedFedRMNB

TheKingSlayer

He was in the way!

Czech Your Math

I am lizard king

Czech Your Math

I am lizard king

Dalton

Registered User

overpass

Registered User

socratic

Registered User

seventieslord

Student Of The Game

BraveCanadian

Registered User

TheDevilMadeMe

Registered User

overpass

Registered User

TheDevilMadeMe

Registered User

TheDevilMadeMe

Registered User

Ad

Latest posts

Upcoming events

Ad

Ad