HFBoards

Go Back   HFBoards > General Hockey Discussion > By The Numbers
By The Numbers Hockey Analytics... the Final Frontier. Explore strange new worlds, to seek out new algorithms, to boldly go where no one has gone before.

Best Website for Exportable NHL Data

Reply
 
Thread Tools
Old
10-11-2012, 03:59 PM
  #1
overpass
Registered User
 
Join Date: Jun 2007
Posts: 3,513
vCash: 500
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
Player $ESP/S
Wayne Gretzky 95
Mario Lemieux 88
Jaromir Jagr 81
Eric Lindros 78
Alex Ovechkin 78
Peter Forsberg 77
Bobby Orr 75
Mike Bossy 71
Phil Esposito 68
Pavel Bure 68

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
Player $PPP/S
Bobby Orr 55
Mario Lemieux 55
Phil Esposito 51
Wayne Gretzky 48
Mike Bossy 45
John Bucyk 44
Kent Nilsson 44
Alex Ovechkin 42
Al MacInnis 42
Peter Forsberg 41

Player $SHP/S
Derek Sanderson 9
Bobby Orr 8
Wayne Gretzky 7
Mike Richards 7
Ed Westfall 7
Bobby Clarke 6
Mark Messier 6
Lorne Henning 6
Dave Poulin 6
Bill Barber 6


Last edited by overpass: 08-20-2013 at 07:56 PM.
overpass is offline   Reply With Quote
Old
10-11-2012, 04:00 PM
  #2
overpass
Registered User
 
Join Date: Jun 2007
Posts: 3,513
vCash: 500
On-ice even strength goals for
Player ESGF
Wayne Gretzky 2202
Larry Robinson 1963
Ray Bourque 1870
Paul Coffey 1858
Scott Stevens 1731
Larry Murphy 1671
Mark Messier 1540
Nicklas Lidstrom 1526
Chris Chelios 1473
Borje Salming 1453
Estimated from official TGF, PGF, TGA, PGA data. Formula is ESGF = TGF - PGF - (PGA/TmPGA*TmSHGF)

On-ice even strength goals against
Player ESGA
Wayne Gretzky 1679
Paul Coffey 1496
Larry Murphy 1396
Mark Messier 1388
Ray Bourque 1335
Scott Stevens 1333
Ron Francis 1314
Dave Babych 1306
Borje Salming 1287
Phil Housley 1246

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

Adjusted even strength goals for
Player $ESGF
Wayne Gretzky 2166
Ray Bourque 1933
Nicklas Lidstrom 1903
Scott Stevens 1893
Paul Coffey 1879
Larry Robinson 1862
Larry Murphy 1771

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

Adjusted even strength goals against
Player $ESGA
Wayne Gretzky 1721
Paul Coffey 1522
Mark Messier 1488
Larry Murphy 1473
Scott Stevens 1452
Mark Recchi 1424
Ron Francis 1416
Ray Bourque 1410
Phil Housley 1346
Brian Leetch 1336

Even strength GF/GA ratio (on-ice)
Player R-ON
Bobby Orr 2.15
Steve Shutt 1.81
Pierre Mondou 1.80
Bobby Clarke 1.79
Mike Bossy 1.79
Peter Forsberg 1.71
Jacques Lemaire 1.67
Jim Watson 1.67
Guy Lafleur 1.67
Yvan Cournoyer 1.63

Minimum 500 GP.

Even strength GF/GA ratio (off-ice)
Player R-OFF
Yvon Lambert 1.71
Guy Lapointe 1.66
Rejean Houle 1.66
Jim Watson 1.61
Don Saleski 1.56
Doug Jarvis 1.55
Serge Savard 1.52
Jacques Lemaire 1.51
Bob Gainey 1.51
Pierre Bouchard 1.51

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

Adjusted plus-minus
Player AEV+/-
Ray Bourque 577
Bobby Orr 563
Jaromir Jagr 499
Larry Robinson 411
Wayne Gretzky 401
Nicklas Lidstrom 378
Al MacInnis 371
Teemu Selanne 369
Mark Howe 367
Eric Lindros 363
Bobby Clarke 361

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
Player EV+/-
Larry Robinson 696
Bobby Orr 610
Nicklas Lidstrom 551
Ray Bourque 523
Guy Lafleur 492
Al MacInnis 467
Jaromir Jagr 455
Bobby Clarke 454
Scott Stevens 443
Serge Savard 425

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

Even strength usage (total)
Player EVCalc
Wayne Gretzky 8.6
Scott Stevens 8.6
Ray Bourque 8.4
Larry Murphy 8.0
Chris Chelios 8.0
Nicklas Lidstrom 7.8
Paul Coffey 7.7
Larry Robinson 7.5
Ron Francis 7.4
Mark Messier 7.3

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)
Player EV%
Bobby Orr 49%
Bill White 49%
Gilles Marotte 47%
Gary Bergman 46%
Wayne Gretzky 46%
Ian Turnbull 45%
Dallas Smith 45%
Brian Leetch 45%
Barry Gibbs 45%
Ted Harris 44%

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)
Player PPCalc
Ray Bourque 17.7
Ron Francis 15.9
Phil Housley 15.8
Wayne Gretzky 15.4
Al MacInnis 15.2
Nicklas Lidstrom 14.1
Paul Coffey 14.0
Joe Sakic 13.5
Mark Recchi 13.4
Larry Murphy 13.3

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)
Player PP%
Bobby Orr 96%
Mario Lemieux 92%
Alex Ovechkin 88%
Ilya Kovalchuk 87%
Ray Bourque 87%
Brian Leetch 87%
Denis Potvin 86%
Al MacInnis 86%
Jeff Brown 84%
Phil Housley 84%

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)
Player SHCalc
Chris Chelios 11.9
Ray Bourque 11.8
Scott Stevens 11.5
Nicklas Lidstrom 10.0
Mark Messier 9.1
Guy Carbonneau 8.7
Rod Brind'Amour 8.3
Craig Ludwig 8.2
Craig Ramsay 8.0
Chris Pronger 7.9

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)
Player SH%
Ed Westfall 69%
Don Luce 66%
Bill White 65%
Bobby Orr 63%
Craig Ramsay 59%
Jay Bouwmeester 58%
Ray Bourque 58%
Serge Savard 58%
Chris Chelios 57%
Bill Hajt 57%

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.


Last edited by overpass: 08-20-2013 at 06:55 PM.
overpass is offline   Reply With Quote
Old
11-02-2012, 12:40 PM
  #3
TheKingSlayer
He was in the way!
 
TheKingSlayer's Avatar
 
Join Date: Mar 2008
Location: Ottawa
Country: Canada
Posts: 1,262
vCash: 500
Best Website for Exportable NHL Data

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]

TheKingSlayer is offline   Reply With Quote
Old
11-02-2012, 12:53 PM
  #4
fedfed
Moderator
@FedFedRMNB
 
fedfed's Avatar
 
Join Date: Oct 2010
Location: Moscow City
Country: Russian Federation
Posts: 3,546
vCash: 500
Hockey-Reference.com allowas you to download data in CSV format.

fedfed is offline   Reply With Quote
Old
11-02-2012, 06:05 PM
  #5
TheKingSlayer
He was in the way!
 
TheKingSlayer's Avatar
 
Join Date: Mar 2008
Location: Ottawa
Country: Canada
Posts: 1,262
vCash: 500
Quote:
Originally Posted by fedfed View Post
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.

TheKingSlayer is offline   Reply With Quote
Old
11-07-2012, 06:36 PM
  #6
Czech Your Math
Registered User
 
Czech Your Math's Avatar
 
Join Date: Jan 2006
Location: bohemia
Country: Czech_ Republic
Posts: 3,489
vCash: 50
Behindthenet.com has some individual advanced stats for recent seasons and league stats on a more historical basis.

Czech Your Math is offline   Reply With Quote
Old
11-07-2012, 06:51 PM
  #7
Czech Your Math
Registered User
 
Czech Your Math's Avatar
 
Join Date: Jan 2006
Location: bohemia
Country: Czech_ Republic
Posts: 3,489
vCash: 50
Quote:
Originally Posted by overpass View Post
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.

Czech Your Math is offline   Reply With Quote
Old
11-10-2012, 07:57 AM
  #8
Dalton
Registered User
 
Dalton's Avatar
 
Join Date: Aug 2009
Location: Ho Chi Minh City
Country: Vietnam
Posts: 2,096
vCash: 500
Thanks op and Czech.

Dalton is offline   Reply With Quote
Old
08-20-2013, 06:45 PM
  #9
overpass
Registered User
 
Join Date: Jun 2007
Posts: 3,513
vCash: 500
Updated for 2013 in OP.

overpass is offline   Reply With Quote
Old
09-16-2013, 04:23 PM
  #10
socratic
Registered User
 
Join Date: Jun 2011
Posts: 263
vCash: 500
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?

socratic is offline   Reply With Quote
Old
09-17-2013, 10:52 PM
  #11
seventieslord
Moderator
 
seventieslord's Avatar
 
Join Date: Mar 2006
Location: Regina, SK
Country: Canada
Posts: 23,823
vCash: 500
Quote:
Originally Posted by socratic View Post
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.

seventieslord is online now   Reply With Quote
Old
09-18-2013, 08:17 AM
  #12
BraveCanadian
Registered User
 
BraveCanadian's Avatar
 
Join Date: Jun 2010
Country: Canada
Posts: 7,546
vCash: 500
Quote:
Originally Posted by overpass View Post
Updated for 2013 in OP.
Awesome.

Thanks overpass

BraveCanadian is offline   Reply With Quote
Old
05-05-2014, 01:46 PM
  #13
TheDevilMadeMe
Global Moderator
 
TheDevilMadeMe's Avatar
 
Join Date: Aug 2006
Location: Brooklyn
Country: United States
Posts: 38,541
vCash: 500
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.

TheDevilMadeMe is offline   Reply With Quote
Old
05-07-2014, 09:21 PM
  #14
overpass
Registered User
 
Join Date: Jun 2007
Posts: 3,513
vCash: 500
Quote:
Originally Posted by TheDevilMadeMe View Post
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?

overpass is offline   Reply With Quote
Old
05-10-2014, 10:07 PM
  #15
TheDevilMadeMe
Global Moderator
 
TheDevilMadeMe's Avatar
 
Join Date: Aug 2006
Location: Brooklyn
Country: United States
Posts: 38,541
vCash: 500
Quote:
Originally Posted by overpass View Post
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.

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

TheDevilMadeMe is offline   Reply With Quote
Reply

Forum Jump


Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -5. The time now is 03:45 AM.

monitoring_string = "e4251c93e2ba248d29da988d93bf5144"
Contact Us - HFBoards - Archive - Privacy Statement - Terms of Use - Advertise - Top - AdChoices

vBulletin Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
HFBoards.com is a property of CraveOnline Media, LLC, an Evolve Media, LLC company. 2014 All Rights Reserved.