Experimental 2/1 xStats
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
Feel free to use this document whenever you like. It is updated in the morning between 8am and 11am, depending on my schedule. I try to get it done as early as possible.
3
4
I recommend that you make a copy of the document for your own personal use by pressing "File" and "Make a Copy..." rather than altering this main doc.
5
6
If you do wish to use this doc without making a copy, I ask that you return it to the manner in which you found it. Each field unfiltered, and each sheet sorted in alphabetical order by player name.
7
8
9
The PA, TBF totals might not match what you see from other sources. This is a limitation of the dataset I am drawing from, and I do as much as I can to fix issues and make it as accurate as possible.
10
In general, PA and TBF will be very close to accurate, a fraction of a percent off.
11
12
13
Change log
14
4/30/2017MASSIVE UPDATE
15
xStats has been updated to the point where it requires a new fork. I have created xStats v4.30, this sheet is now obsolete and will be kept static.
16
Use this link to the new xStats v4.30
https://docs.google.com/spreadsheets/d/1Rn6YLAyKkZ1-Uaoi02ZPWsldTchhF5tm377i2cxxHh0/edit?usp=sharing
17
4/4/2017Updated for the new 2017 season.
18
Added Some Charts to the Look Up Sheets.
19
Added 6 batted ball types: Dribble Ball, Ground Ball, Low Drive, High Drive, Fly Ball, and Pop Up. You can find stats for these batted balls in the glossary.xstats.org/glossary
20
2/22/2017Fixed single/double/triple/home run balance. They were off by a factor of about 1.004. This is a minor correction.
21
Fixed the xOBP numbers on the Base, vR, and vL pages.
22
Minor balancing adjustments to other stats, mostly within a factor of 1.001
23
2/1/2017Monthly totals for batters and pitchers are now up to date.
24
2/1/2017I added a correction to batted ball probabilities which corrected a small measuring issue. It is proportional to result type, so it almost entirely affects singles.
25
1/14/2017I've made massive updates across the board. This is an experimental version of xStats! It may be discarded! I'm not sure! Changes Include:
26
xAVG, xOBP, xSLG were all rewritten from scratch. More information below.
27
One error was found xAVG which gave incorrect (too low) results across the board. It was corrected.
28
All Exit Velocities have been corrected for Ball Park Measurement Bias. Read more here: http://www.baseballprospectus.com/article.php?articleid=29210
29
All Exit Velocities have been corrected for game time temperature.
30
All Ball Parks have minor park adjustments to success rates for singles, doubles, triples, and home runs. These take into account batter handedness.
31
2/1The Monthly based stats pages have been updated behind the scenes BUT THIS PAGE HAS NOT BEEN UPDATED. THOSE ARE HORRIBLY OUTDATED NUMBERS.
32
These stats have not been fully tested and vetted for errors. Errors may (likely) still exist in the code. If you see something odd, tell me.
33
For the older version of xStats click here:
https://docs.google.com/spreadsheets/d/1_bwfyWPDu20x5nXMXQGBuHiXqJoS9N4-xSlPqkwh8PA/edit#gid=2084960448
34
10/27/2016Substantial changes to the xSLG, xOBP, xBABIP, and xBACON formulas.
35
Before they were calculated using PA multiplied by a constant, they are now calculated using AB to put them more in line with standard SLG, OBP, BABIP and BACON.
36
9/6/2016Data from 9/3 has been added. All is well.
37
9/5/2016All data is missing from 9/3. There's nothing I can do about it. For most players it wont make a big difference overall, but it is a shame for the starting pitchers from that day.
38
8/26/2016Updated scFIP to include PH along side strike outs. The new formula is: [ 13 x estHR + 3 x BB - 2 ( PH + K ) ] / IP + C. Also fixed a bug where season totals in 'Pitchers 16 Monthly' included 2015 numbers.
39
8/24/2016Fixed a bug that stopped the pitcher inning totals from updating correctly between 8/20 and 8/23. The update trigger broke.
40
8/20/2016Added Fangraphs ID to Batters 16, Batters 15, Pitchers 16 and Pitcher 15 pages, you can also find it in the lookup page right below their team.
41
8/19/2016Added PH%, K% and standard FIP, reworked several formulas, and fixed many bugs both large and small.
42
8/15/2016I fixed the link to the Pitch Value Spreadsheet!
43
8/11/2016Created a Separate Google Doc for Pitch Values. Click this link to View it.
44
7/27/2016Added Monthly Totals for Batters and Pitchers.
45
7/4/2016Small update which created some ripples across the stats. Corrected an error that improperly categorized some strike outs during calculation of certain odds.
46
6/30/2016Fixed an error that displayed a pitcher as playing for the team of his most recent opponent. Actual stats weren't affected, only the team name for pitchers.
47
6/28/2016Added xBACON
48
As I said, a lot of my code was damaged in an electrical storm, which is one of the reasons I completely rewrote everything. The past two days have been rocky as a result of all this work.
49
Some numbers may be different now than they were two days ago. There might be bugs in the new code, more likely there were bugs in the old code.
50
6/28/2016I completely rewrote all of my code to generate these stats. The logic is the same, it does all of the same math, but the code is updated significantly.
51
6/25/2016Fixed IP totals, they now represent actual innings pitched. Replaced xERA with scFIP, a statcast based FIP, which uses launch angle and exit velocity to estimate home run totals.
52
6/21/2016Fixed a small error that only applied to players who were in the post season in 2015.
53
6/17/2016I did my best to repair all of the damage caused yesterday, also made a few updates along the way. I am sure there are bugs to be ironed out in all of the new code.
54
Soon the data will be in the cloud and stuff like this wont be able to happen.
55
6/16/2016There are no stats updates for June 16th, my house was hit by an electric surge that fried part of my hard drive, which had to be replaced. Sorry. Should be back for tomorrow.
56
6/13/2016I bought xstats.org It currently redirects to this google doc. You can use that domain to always find my stats.xstats.org
57
6/6/2016Added Totals for BIP, GB, LD, and FB. Fixed a large number of errors in the Look Up sheets. If you see an error, please tell me.
58
6/5/2016Major Overhaul. Added vR and vL versions of the base. Added GB, LD, FB avg Exit Angles and Velocities. Complete rework of lookup sheets. Added Notes for stats.
59
6/4/2016Reworked the lookup sheet to include more stats.
60
6/3/2016Fixed issue involving post season 2015 stats, eliminated post season numbers from the stats.
61
6/2/2016Converted xRA to xERA.
62
5/31/2016Fixed error resulting in improper splits (used count() instead of sum() by accident). Changed Look Up 16 sheet so Batters and Pitchers 16 no longer need to be in alphabetical order.
63
IP is a rough estimate, not perfect. I will try to make it perfect, but no promises.
64
Some pitchers are listed as having more IP than they actually have, perhaps the result of strikeouts where baserunners reached base safely.
65
The other 121 missing outs are currently of unknown origin, although likely the result of baserunning in some manner.
66
Known bugs:IP for pitcher is missing 211 outs for the 2016 season. At least 90 of these outs are from 90 successful pickoffs. Baserunner data is not currently in the database, so not accounted for.
67
5/30/2016Added IP for pitchers, fixed code that decides batter handedness (it now recognizes switch hitters) and current team more accurately (hopefully).
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Cover
Comments
Look Up 17
Batters 17
Look Up 16
Look Up 15
Base 17
vR 17
vL 17
Batters 17 Monthly
Batters 16
Batters 16 Monthly
Batters 15
Pitchers 17
Pitchers 17 Monthly
Pitchers 16
Pitchers 16 Monthly
Pitchers 15
Base 16
vR 16
vL 16
Eligibility