Home Unfiltered Articles Stats Glossary
Baseball       
Hockey Prospectus home
Click here to log in Click here for forgotten password Click here to subscribe

Hockey Prospectus 2012-13 is here! Download Sample Chapter - Penguins!

<< Previous Article
Premium Article Shots On Goal (11/27)
<< Previous Column
Premium Article Numbers On Ice (11/11)
Next Column >>
Numbers On Ice (12/15)
Next Article >>
Premium Article Shots On Goal (11/29)

November 28, 2010
Numbers On Ice
All-Time Multi-League GVT Database

by Tom Awad

Printer-
friendly
Contact
Author

Displaying pretext

I guess it was only a matter of time until I put this together.

On Google documents I have placed an all-time GVT database that covers the NHL, WHA, AHL, IHL, the Swedish, Finnish, Russian, Czech and German elite leagues, as well as some of the Canada Cups and Olympic tournaments. There is both a text file, multi _gvt.txt, and an Excel file, multi_gvt2.xls. The text file contains all the players; the Excel file only contains the first several hundred, as the site didn’t allow me to upload spreadsheets larger than ~10 MB (!). You can download the text file then paste it into an Excel spreadsheet.

Calculating the GVT data itself was fairly simple, although for many of these leagues the data I was able to find was quite rudimentary: Games, Goals and Assists. For recent years, goaltender shots against and player plus-minus are available, which at least gives us a skeleton of defensive information to work with. For now, I have restricted myself to seasons for which I had enough data to work with and in which there is enough overlap between the various leagues that I can be reasonably confident of my normalization rates. I’ve started in 1983 for the AHL, 1988 for the Swedish Elitserien, 1989 for the Finnish SM-Liiga, 1992 for the IHL, 1999 for the Czech Republic League, 2001 for the German Deutsche Eishockey League and 2003 for the Russian Elite League / KHL. I have also included all the Canada Cups, World Cups and the 2006 and 2010 Olympics. More seasons will get added as I find the time.

The process of normalization, of course, is the most interesting part. GVT naturally normalizes to 3 goals a game, and I normalized goals and assists in the same way. I also normalized for schedule length, although because of the huge disparity in schedule lengths between various leagues, and the different levels of variance inherent in each, I could not normalize every league to 82 games: what would I do with an 8-game Olympic tournament? My compromise was to normalize versus a minimum of 70 games, so if a league had a 50 game season, I normalized the games played to 50 / 70 * 82 = 59 games. It’s not perfect, but it’s close enough.

The second part was to normalize for league difficulty. Past approaches, especially the most well-known ones by Gabriel Desjardins, normalize by games played. This is the correct approach when doing projections for the majority of players, as good players in lower leagues will often be marginal players in the NHL. However, I chose to use a translation system that was more accurate for elite players; to do this, I needed to normalize by ice time instead of by games played. Obviously, I don’t have ice time numbers for any league but the NHL, but I do have a simple algorithm to estimate ice time based on basic statistics. It’s not perfect, but it’s close enough. The upshot is that my normalization factors are slightly higher than Gabriel’s and track good players better but weaker players worse.

The rest of this article is restricted to Hockey Prospectus Subscribers.

Not a subscriber?

Click here for more information on Hockey Prospectus subscriptions or use the buttons to the right to subscribe and get access to the best hockey content on the web.

Sign Up Today

One year subscription $19.98
Get instant access to everything at Basketball Prospectus for only $19.98



A Prospectus Username is required to order hockey products. (basic subscription is free)

Click here and use the blue login bar to log in, or
Click here to get yours now.

0 comments have been left for this article.

<< Previous Article
Premium Article Shots On Goal (11/27)
<< Previous Column
Premium Article Numbers On Ice (11/11)
Next Column >>
Numbers On Ice (12/15)
Next Article >>
Premium Article Shots On Goal (11/29)

RECENTLY AT HOCKEY PROSPECTUS
Top 100 Draft Prospects 2013: 16-20
NHL Playoffs, Second Round: Boston Bruins vs...
Premium Article Conn Smythe Watch: Lundqvist Leads
NHL Playoffs, Second Round: Chicago Blackhaw...
NHL Playoffs, Second Round: Los Angeles King...


MORE BY TOM AWAD
2010-12-14 - Player Power Rankings: Cam Ward, Daniel Sedi...
2010-12-07 - Player Power Rankings: Dustin Byfuglien Appr...
2010-12-03 - Player Power Rankings: Steven Stamkos Is Pac...
2010-11-28 - Premium Article Numbers On Ice: All-Time Multi-League GVT Da...
2010-11-23 - Player Power Rankings: Sidney Crosby Makes H...
2010-11-11 - Premium Article Numbers On Ice: Zach Parise Injury Hasn't Do...
2010-10-29 - Player Power Rankings: Here Comes Steven Sta...
More...

MORE NUMBERS ON ICE
2010-12-29 - Numbers On Ice: On Sidney Crosby vs. Alex Ov...
2010-12-18 - Premium Article Numbers On Ice: The 1970's Canadiens
2010-12-15 - Numbers On Ice: Steven Stamkos Approaching E...
2010-11-28 - Premium Article Numbers On Ice: All-Time Multi-League GVT Da...
2010-11-11 - Premium Article Numbers On Ice: Zach Parise Injury Hasn't Do...
2010-10-27 - Numbers On Ice: What Makes Good Players Good...
2010-09-30 - Numbers On Ice: What Makes Good Players Good...
More...