xFIP is almost the same thing as FIP, just with something ‘xtra’. \u00a0The idea is that while pitchers are responsible for the 3 True Outcomes (HR, BB\/HP, and K), home runs can also be subject to luck. \u00a0For example, a fence-scraper over the short right porch in Fenway might not be a home run through the marine layer at Dodger Stadium. \u00a0What does this tell us about the pitcher’s expected performance?<\/p>\n
Well, to account for the vagaries of chance, xFIP takes all of a pitchers fly balls and multiplies them by the league average HR\/FB rate. \u00a0Basically, it assumes a number of HR a pitcher\u00a0would have given up<\/em> based on the number of fly balls their opponents hit rather than the number of HR they\u00a0actually did give up.<\/em><\/p>\n It feels like splitting hairs to me, but hey. \u00a0That’s baseball. \u00a0The formula for xFIP is just like FIP with that one change: The constant is the same FIPConstant we calculated for FIP. \u00a0So, this one is pretty straight-forward, except that we need the HR\/FB% for the league. \u00a0We’ll go back to our FIPConstant table and add it there for each league year. \u00a0Our FIPConstant table now looks like this:<\/p>\n I added the formula above to the CalcPitching table and we’re done. \u00a0OOTP doesn’t track xFIP (at least in v18), so there’s nothing to compare it to. \u00a0This one’s done.<\/p>\n xFIP is almost the same thing as FIP, just with something ‘xtra’. \u00a0The idea is that while pitchers are responsible for the 3 True Outcomes (HR, BB\/HP, and K), home runs can also be subject to luck. \u00a0For example, a fence-scraper over the short right porch in Fenway might not be a home run through… Continue reading Pitching Stats 4: xFIP<\/span>
\nxFIP = ((13*(Fly balls * lgHR\/FB%))+(3*(BB+HBP))-(2*K))\/IP + constant<\/code><\/p>\nDROP TABLE IF EXISTS FIPConstant;\r\nCREATE TABLE IF NOT EXISTS FIPConstant AS\r\n\r\nSELECT\r\n year\r\n , league_id\r\n , hra_totals\/fb_totals AS hr_fb_pct\r\n , @HRAdj := 13*hra_totals AS Adjusted_HR\r\n , @BBAdj := 3*bb_totals AS Adjusted_BB\r\n , @HPAdj := 3*hp_totals AS Adjusted_HP\r\n , @KAdj := 2*k_totals AS Adjusted_K\r\n , @InnPitch := ((ip_totals*3)+ipf_totals)\/3 AS InnPitch\r\n , @lgERA := round((er_totals\/@InnPitch)*9,2) AS lgERA\r\n , round(@lgERA - ((@HRAdj+@BBAdj+@HPAdj-@KAdj)\/@InnPitch),2) AS FIPConstant\r\nFROM (\r\n SELECT year\r\n , league_id\r\n , sum(hra) as hra_totals\r\n , sum(bb) as bb_totals\r\n , sum(hp) as hp_totals\r\n , sum(k) as k_totals\r\n , sum(er) as er_totals\r\n , sum(ip) as ip_totals\r\n , sum(ipf) as ipf_totals\r\n , sum(fb) as fb_totals\r\n FROM players_career_pitching_stats\r\n GROUP BY year, league_id\r\n ) AS x;<\/code><\/pre>\nDROP TABLE IF EXISTS CalcPitching;\r\nCREATE TABLE IF NOT EXISTS CalcPitching AS\r\n\r\nSELECT\r\n i.player_id\r\n , i.year\r\n , i.stint\r\n , i.team_id\r\n , i.league_id\r\n , split_id\r\n , i.ip\r\n , i.ab\r\n , i.tb\r\n , i.ha\r\n , i.k\r\n , i.bf\r\n , i.rs\r\n , i.bb\r\n , i.r\r\n , i.er\r\n , i.gb\r\n , i.fb\r\n , i.pi\r\n , i.ipf\r\n , i.g\r\n , i.gs\r\n , i.w\r\n , i.l\r\n , i.s\r\n , i.sa\r\n , i.da\r\n , i.sh\r\n , i.sf\r\n , i.ta\r\n , i.hra\r\n , i.bk\r\n , i.ci\r\n , i.iw\r\n , i.wp\r\n , i.hp\r\n , i.gf\r\n , i.dp\r\n , i.qs\r\n , i.svo\r\n , i.bs\r\n , i.ra\r\n , i.cg\r\n , i.sho\r\n , i.sb\r\n , i.cs\r\n , i.hld\r\n , i.ir\r\n , i.irs\r\n , i.wpa\r\n , i.li\r\n , i.outs\r\n , i.war\r\n , @InnPitch := ((3*ip)+ipf)\/3 AS InnPitch\r\n , round((9*i.k)\/@InnPitch,1) AS 'k9'\r\n , round((9*i.bb)\/@InnPitch,1) AS 'bb9'\r\n , round((9*i.hra)\/@InnPitch,1) AS 'HR9'\r\n , round((i.bb+i.ha)\/@InnPitch,2) AS WHIP\r\n , round(i.k\/i.bb,2) AS 'K\/BB'\r\n , i.gb\/i.fb AS 'gb\/fb'\r\n , round((i.ha-i.hra)\/(i.ab-i.k-i.hra-i.sh+i.sf),3) AS BABIP\r\n , round((i.er\/@InnPitch)*9,2) AS ERA\r\n , round(((13*i.hra)+(3*(i.bb+i.hp))-(2*i.k))\/@InnPitch+f.FIPConstant,2) AS FIP \r\n , round(((13*(i.fb*f.hr_fb_pct))+(3*(i.bb+i.hp))-(2*i.k))\/@InnPitch+f.FIPConstant,2) AS xFIP\r\n \r\n \r\nFROM players_career_pitching_stats AS i\r\n INNER JOIN FIPConstant AS f ON i.year=f.year AND i.league_id=f.league_id\r\nWHERE i.split_id=1 AND i.league_id<>0;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"