Wednesday, February 20, 2013
Exportable 2013 MLB Schedule
Something that is difficult to find on the internet is an excel download file of the 2013 MLB Schedule. I have taken the time to type up the complete 2013 MLB Schedule in to CSV format and uploaded it to google docs. The file is free to download and can be found at the following link.
Here is the format that the file is in
Game ID,Year,Month,Day,Away,Home
1,2013,3,31,TEX,HOU
2,2013,4,1,FLA,WAS
3,2013,4,1,SD,NYN
4,2013,4,1,CHN,PIT
5,2013,4,1,COL,MIL
6,2013,4,1,SF,LAN
7,2013,4,1,PHI,ATL
8,2013,4,1,STL,ARI
9,2013,4,1,DET,MIN
10,2013,4,1,BOS,NYA
.
.
.
2428,2013,9,29,OAK,SEA
2429,2013,9,29,COL,LAN
2430,2013,9,29,WAS,ARI
Tuesday, February 12, 2013
2013 MLB Win Totals - Part I
Instead of just posting the current Vegas MLB odds to win the World Series, I am going to take things a step further and interpolate those W.S. odds out to 2013 win totals. There is no great scientific method that I am going to be using except for keeping consistent with the Vegas odds in the order I assign team wins. I think I have a pretty good idea at what Vegas typically sets their highest and lowest over/under win totals at, so everything in between I can do an "eye ball" interpolation on to set the win total over/under for each team. Later in my Part II of this series, I will use a more scientific method for matching up the Vegas odds to win totals. But for now... here we go!
| Team | Odds To Win W.S. | % Chance to Win | 2013 Wins Over/Under |
| Angels | 8-1 | 8.39 | 93 |
| Dodgers | 8-1 | 8.39 | 93 |
| Blue Jays | 8-1 | 8.39 | 93 |
| Nationals | 8-1 | 8.39 | 93 |
| Tigers | 9-1 | 7.55 | 92 |
| Braves | 12-1 | 5.81 | 90 |
| Yankees | 12.5-1 | 5.59 | 89 |
| Reds | 13-1 | 5.40 | 88 |
| Rangers | 13.5-1 | 5.21 | 88 |
| Phillies | 17-1 | 4.20 | 86 |
| Giants | 17-1 | 4.20 | 86 |
| Red Sox | 20-1 | 3.60 | 85 |
| Cardinals | 20-1 | 3.60 | 85 |
| Rays | 22-1 | 3.28 | 84 |
| Athletics | 30-1 | 2.44 | 82 |
| Orioles | 40-1 | 1.84 | 81 |
| Diamondbacks | 45-1 | 1.64 | 80 |
| White Sox | 50-1 | 1.48 | 79 |
| Royals | 50-1 | 1.48 | 79 |
| Brewers | 50-1 | 1.48 | 79 |
| Pirates | 72-1 | 1.03 | 77 |
| Mets | 75-1 | 0.99 | 75 |
| Padres | 75-1 | 0.99 | 75 |
| Indians | 77.5-1 | 0.96 | 75 |
| Cubs | 100-1 | 0.75 | 71 |
| Rockies | 100-1 | 0.75 | 71 |
| Mariners | 110-1 | 0.68 | 70 |
| Twins | 125-1 | 0.60 | 67 |
| Marlins | 150-1 | 0.50 | 63 |
| Astros | 200-1 | 0.38 | 61 |
Notes:
Percent chance of winning W.S. has the Vegas juice removed.
American League has a 51.5% (Vegas) chance of winning the W.S.
National League has a 48.5% (Vegas) chance of winning the W.S.
Odds were taken from 5Dimes on 2/12/13.
In calculating the pecent chance to win the W.S., I removed the Vegas "juice".
The 2013 Over/Unders from the Atlantis came out the day after this post.
For the most part, I did a straight interpolation from (Vegas) World Series odds to an over/under on team wins. There a couple of things that could be wrong with this. The first comes from the possibility that the Vegas World Series odds have some bias to them. Perhaps Vegas moved the odds up or down based on how popular a team is. This of course has nothing to do with my methodology. On the otherhand, something that does have to do with my methodology is that I am not controlling for the teams playing in divisions. Divisions that may be stronger or weaker than others. For example, the Royals might win a World Series out of every 50 times playing out of the AL Central, but what if they played out of the AL East? Chances are that 50 number would climb. A next step to this exercise would be to control for how hard or easy it is to win a division. I'm not sure on the best way to do this yet, so if you have any ideas feel free to leave a comment or send me a tweet (@DodgerSims).