February 27, 2007

Trades

There's a lot of coverage all over the place. I mentioned this before, but I have a trade page, that's not as updated as many of the big websites, but it has some useful features, such as grouping trades by team and presenting a few of their season stats on one page. It's a bit of a mess, but it gets the job done.

February 25, 2007

Canucks 2-1 OTL

So I didn't listen to the whole game and certainly didn't watch, but I found it strange that the Canuck's had 7 minor calls against, while Dallas had one (in the first minute). This meant 7 penalties against the Canucks in a row including a long 5-3 and penalty in overtime. So I was curious what is the worst ratio in the NHL for penalties against each team. The answer is 1:0, happened three times [1 2 3]. However these games had very few calls in total (worst was 4). The game this afternoon had a penalty ratio of 7:1. So a larger picture seemed necessary. I plotted home penalties vs. away penalties [only looking at minors - graph on the right]. Each dot is labeled with the gameid that the NHL uses; you can find the game summary by changing the # in this URL: http://www.nhl.com/scores/htmlreports/20062007/GS020936.HTM. The usual relationship can be seen: as away team gets more penalties the home team does as well. I can't say whether the officiating was fair or not in the Canucks game, but I can say it's a little strange. What's maybe most remarkable is that the Canucks were able to come away with a point.

February 21, 2007

Betting Rankings

NnameBET
1BUF59.2%
2OTT57.4%
3N.J55.8%
4ATL54.5%
5T.B52.9%
6CAR52.4%
7MTL52.2%
8PIT51.0%
9NYR50.2%
10TOR50.0%
11WSH48.9%
12NYI46.4%
13BOS45.9%
14FLA44.6%
15PHI39.8%
NnameBET
1DET60.3%
2ANA59.1%
3NSH58.5%
4S.J58.0%
5DAL55.4%
6VAN55.2%
7CGY54.9%
8COL52.2%
9MIN51.7%
10EDM50.3%
11PHX45.7%
12STL43.4%
13CHI42.9%
14CBJ42.1%
15L.A41.8%

Now these change a lot quicker than normal standings would. These come from BCLC - Oddset ratings and should be dated Saturday February 17, 2007. So they're already a little outdated. I did a regression and got a score for each team that's accurate by about 1%, based on the estimated winning percentage that would maximize BCLC revenue. It's not very often you see a regression as good as this one, although there were only about 40 degrees of freedom (30 variables to solve for). I'll see how this develops over time, but some people may find it interesting. If the ratings are off your expected percentages there is a chance you could make money betting on that team (expect Boston to make the playoffs, expect NYI to make playoffs). These are probably reasonably similar to other betting outlets, but I can't speak for them, it's enough work inputing information from one source. As an aside Oddset provides horrible return on bets I've basically determined it's impossible to consistently make money (your expected result has to differ by about 10% of their expectation - so if they say 50% you need to be confident it'll be 60% to make money).

February 13, 2007

Frequency Stadings Update

It's been a month since I posted these and as always find the data interesting. For example Ottawa has very low CB and a high LW, which partially can explain (or be explained by) their big wins and big losses. Anaheim lost quite a bit of ground in the last month due to the injuries and their CB lost 6 points. A month ago I said Pittsburgh could be a dark horse in the playoffs, and now they've almost secured themselves a playoff spot and could start out on home ice. So without further ado here's the list:
NnameWLTePTSSWTLOLLWCB
1ANA5120121132.856%37%49%60%
2N.J4817171132.849%41%49%67%
3NSH522371123.162%34%45%56%
4DET532361122.755%41%58%60%
5BUF4819151113.249%42%46%69%
6S.J532811072.653%46%66%59%
7DAL4724111052.646%46%57%59%
8VAN452891002.752%42%50%51%
9CGY46297992.652%43%53%51%
10MIN392419982.943%46%44%59%
11PIT422613983.650%44%38%63%
12MTL422813963.043%49%48%61%
13OTT46333962.353%45%62%44%
14CAR42346902.847%49%52%54%
15T.B393111903.347%47%41%58%
16TOR393210893.149%45%42%52%
17ATL383113893.447%47%39%58%
18EDM42364882.650%47%52%46%
19NYI383312872.945%48%44%52%
20NYR373510843.147%47%40%50%
21WSH363510832.742%52%49%50%
22COL36379823.549%46%36%53%
23BOS333316823.647%45%31%54%
24CHI343810782.942%51%42%50%
25FLA34399772.938%57%48%54%
26PHX34409762.838%56%48%52%
27STL313912743.339%54%37%55%
28CBJ33428732.643%52%45%43%
29L.A27469633.238%57%36%50%
30PHI22509543.541%54%26%46%


W - wins, L - losses, T - ties (for 82 game season) - estimated using simulation.
PTS - expected points using this method.
SW - average score switching - high numbers likely indicate difficulty maintaining a lead (bad defense/goaltending)
TL - Percentage the team takes lead.
OL - Percentage the opposition takes lead.
LW - Percentage the lead results in win. (otherwise it is tied again).
CB - Percentage of come backs - # of times team re-ties game. (otherwise opposition wins).

2003-2004 Frequency Standings.

As promised a month ago I have collected the frequency standings from 03-04. I suggested and showed that the 2005-2006 Stanley Cup Playoff teams did better if they had a higher come back score. The 2003-2004 playoffs didn't quite work out as well, with Tampa (57%) and Calgary (55%) going the finals. The Montreal - Boston upset (predicted at 80%) was another strange series. As a result the CB factor was negatively correlated to winning in 2003-2004. When you combine the data (2005-2006 and 2003-2004) you get the positive correlation back, however it is no longer significant (p-value = 30%). However doing a regression on the results showed that predicting wrong generally resulted in a longer series (6 games instead of 5). Either way I still don't have conclusive evidence that the CB stat helps teams win in the playoffs. That being said the other statistics (LW, OL, TL) were less significant than the CB variable so there aren't better alternatives.
NnameWLTePTSSWTLOLLWCB
1DET5318111172.554%39%59%62%
2N.J4921121102.654%38%51%54%
3TOR5022101102.450%43%61%58%
4S.J4922121092.750%43%54%60%
5BOS4720151092.947%44%51%66%
6T.B502391092.957%38%49%57%
7DAL4822131082.349%42%57%54%
8PHI4621151082.850%41%49%60%
9VAN4825101052.948%46%53%62%
10OTT4824101052.851%43%52%58%
11COL4623131042.851%41%48%57%
12MIN392221992.643%44%43%56%
13STL432712992.949%43%46%56%
14MTL45298992.553%42%52%47%
15CGY45307982.749%46%54%55%
16NSH432811982.752%41%46%48%
17NYI442711982.649%43%51%50%
18EDM412912943.146%47%44%59%
19BUF40339892.548%46%49%44%
20L.A353116863.044%46%38%51%
21FLA343215843.043%49%39%52%
22ATL37369833.044%50%45%52%
23CAR343315832.637%53%47%51%
24PHX293518773.236%54%35%56%
25ANA333810773.046%48%38%46%
26NYR30457682.739%57%45%45%
27CBJ284310672.942%52%36%42%
28WSH274510652.936%57%40%47%
29PIT27478613.037%58%38%46%
30CHI244611602.939%54%33%41%
W - wins, L - losses, T - ties (for 82 game season) - estimated using simulation.
PTS - expected points using this method.
SW - average score switching - high numbers likely indicate difficulty maintaining a lead (bad defense/goaltending)
TL - Percentage the team takes lead.
OL - Percentage the opposition takes lead.
LW - Percentage the lead results in win. (otherwise it is tied again).
CB - Percentage of come backs - # of times team re-ties game. (otherwise opposition wins).

February 12, 2007

Making the playoffs

The west is settled except for Edmonton and Colorado. Edmonton has to make up about 9 points in 26 games and Colorado has to make up 12 points in 27 games. Colorado has one advantage: 15 divisional games vs. Edmonton’s 10. Winning a lot of these games can guarantee a playoff birth, for example if Colorado wins 5/6 of the games with Calgary they get +10 on Calgary (6*2-2 = 10), theoretically tying Calgary and Colorado. Edmonton still has 5 games against Minnesota. Colorado has 4 against Vancouver. Meaning any of these teams can easily fall out of playoff contention quickly. Other than the complications in the North West the West is settled with Dallas, Anaheim, San Jose, Detroit and Nashville fighting for positions in the top 8.

The East is a little more complicated: beyond the fact we know that Boston, Washington, Florida and Philadelphia are out and Buffalo and New Jersey are in. So I’m going to make some interesting predictions and explain why:

Atlanta [3rd]

It’d be nice for Atlanta to be guaranteed a spot, but considering in their last 18 games they’ve got a goal differential of -13 and a Pythagorean win percentage of 39% and 3 regulation wins in those games I would say Atlanta is a great candidate for falling out and it could happen quickly (Calgary, Ottawa and Carolina are up next). It appears Atlanta had a great finish last year and couldn’t make it they better hope the opposite can holds true this year: that is to say, a terrible finish, but still make it.

Pittsburg [4th]

In the last few weeks Pittsburg has taken off and almost caught up to New Jersey. Pittsburg is 8 points from falling out of the playoffs and considering the drive of Crosby to join the post season it’s hard to imagine them not being able to pull it off. They have a lot of games to play in March so their lead could dwindle slightly, but they should make it.

Ottawa [5th]

Ottawa has had a strange year so far with such a terrible start they appear to have everything under control in fact their Pythagorean win percentage over the last 17 games is sitting at 73% with 11/17 games won in regulation. They’d need some pretty poor luck to miss the playoffs.

Tampa Bay [6th]

As the only team with a positive goal differential in the South East division they should win the division. Both of the games against Atlanta are at home, however, which if Atlanta gets things going again would most likely seal the division for Atlanta. They’ve won a lot of shootouts lately boosting their point totals. They’ve been the most consistent team in the South East all season and they should be able to get in, but they could easily slip out. My number crunching pegs them at positive odds (69%) chance of making the playoffs.

Montreal [7th]

They better make it. I always enjoy watching and cheering for Montreal in the playoffs their series (most notably the one vs. Boston a couple years ago) are some of the more entertaining ones. However since January they’ve played at a Pythagorean win percentage of 35% and won 6/19 games in regulation. If they want to make it they need to get the ball rolling, the game against Florida on the 13th should help (or really hurt). My numbers say they’re slightly favored to make the playoffs (57%).

Carolina [8th]

Based on who’ve they’ve played and won against, Carolina is the better team in the South East division and should make it in the playoffs. They have to do a bit better than they’re currently doing, but it’s perfectly feasible.

Toronto [9th]

There’s two ways for Toronto to make it in: Montreal falls out, or that the Atlantic and South East divisions are so bad they allow 4 teams from the North East in. I often consider the possibility of 4 teams in the playoffs from one division as not possible as it requires the better division to be a lot better than the bad divisions. Toronto still has 3 games against Montreal that could change things significantly including a game on April 7.

NY Islanders [10th]

Of all the teams that shouldn’t make it in, the Islanders might be the team that does. However, they’ve been losing ground since the beginning of the year when they did really well. Over the last 19 games they’ve won 6 in regulation and went to overtime a lot. However they’ve maintained an even goal differential and are pegged to play a bit above average for the rest of the season. I have at 57% chance of making it.

NY Rangers [11th]

The most important thing for the Rangers in the last stretch is that they play the Islanders 4 times, the winner of that series will likely be the one closest to making the playoffs. Too bad for Rangers their record against the Islanders is rather poor this year. I don’t see them making it, but they do have a 50-50 chance statistically speaking.

Basically it’ll work out like [best guess]:

  1. Buffalo [114]
  2. New Jersey [108]
  3. Tampa Bay [96]
  4. Ottawa [102]
  5. Pittsburg [99]
  6. Carolina [93]
  7. Atlanta [93]
  8. Toronto [91]
  9. Montreal [91]
  10. New York Rangers [91]
  11. New York Inlanders [89]
I could easily see those tie braking rules coming into effect this season in the East.

Trade Deadline

Trades in general make both parties involved better off. Often in the NHL a trade deadline deal is a swap of high present value for high future value. Draft picks are the best representation of high future value and Stuart or Nagy represent high present value. For a team making the playoffs the present is extremely valuable (each additional playoff round is worth millions) and the present is almost worthless for a team not making the playoffs as the only thing they’re going to lose is a few ticket sales in the last 30 games.

I always find the trades that go down to provide significant insight into the value of draft picks and players. For example prior to the new (2006) CBA draft picks were often swapped for good players. Currently it appears almost mandatory to include a prospect in the other direction rather than a draft pick. This is because the new CBA makes the players RFAs after they turn 27 rather than 30 and considering that most players (after the first 20 picks or so) don’t become regulars until they turn 23 or 24, which leaves only 3-4 years of value. The salary cap also shifted the value of the RFAs in such a way that is too complicated to discuss here.

In order to look at the statistical value of the trades I added a trade feature on my website, trades up to this date are displayed here as well:
F TNameGPNETSalaryEVEV+EV-VALPPPPSSHSHS
C. KOBASEW40$2.3M$1.2M10:502.11.10.22:204.30:035.8
A. FERENCE54$4.2M$0.8M13:142.41.9-0.092:035.13:123.7
B. STUART48$-1.4M$2.4M16:4434.5-0.192:132.63:586.9
W. PRIMEAU51$0.4M$1.2M11:021.53.1-0.421:074.42:566.5
J. VASICEK38$2.7M$1.3M11:452.72.60.050:445.20:426.2
E. BELANGER56$0.8M$1.3M10:402.22.30.162:402.81:315.5
V. VISHNEVSKI52$3.5M$1.6M16:082.73-0.190:064.73:034.5
A. HALL49$0.4M$1M8:321.23-0.611:404.92:156
P. DUPUIS48$0.3M$0.8M11:401.22.1-0.330:474.12:407.1
S. AVERY55$4.1M$1.1M12:352.230.212:316.61:455.8
J. WARD46$5.9M$0.7M9:062.43.30.090:1153:022.9
J. LUNDMARK39$1.9M$0.6M7:4611.8-0.270:485.40:036.8
C. CONROY52$3.7M$2.4M11:471.82.80.12:036.21:385.2
2008 2nd $1.5M
2007 4th $0.5M
J. MOTZKO7$2.8M - 6:161.41.400:0800:020
M. HARTIGAN6$4.5M$0.5M10:12200.173:386.80:005.5
2007 4th $0.5M
2007 1st $2.7M
M. TJARNQVIST18$2.1M$0.5M8:001.93-0.230:100.10:04-3.7
L. NAGY55$4.1M$3M13:152.72.60.173:586.40:405.6
2007 1st $2.7M