A short post for three pretty straightforward rate stats: Slugging Percentage, On Base Plus Slugging, and Isolated Power.<\/p>\n
All three are measures of a batter’s hitting for power. \u00a0Keeping with my tradition here of not explaining things that I understand, I will get straight to the point. \u00a0Seeking to keep things simple and readable, and wanting to show off my mad variable skills, I set them all as variables, including batting average. \u00a0The result is:<\/p>\n
DROP TABLE IF EXISTS CalcBatting;\r\nCREATE TABLE IF NOT EXISTS CalcBatting AS\r\n\r\n SELECT b.year\r\n , b.league_id\r\n , b.player_id\r\n , b.stint #We can eventually move this down the list\r\n , b.split_id #We can eventually remove\r\n , b.team_id #We can eventually move this down the list\r\n , l.abbr as Lg\r\n , t.abbr as Team\r\n , b.g\r\n , b.ab\r\n , @PA := b.ab+b.bb+b.sh+b.sf+b.hp AS PA\r\n , @BA := round(b.h\/b.ab,3) AS ba\r\n , round(b.k\/@PA,3) as krate\r\n , round((b.bb)\/@PA,3) as bbrate\r\n , @OBP := round((b.h + b.bb + b.hp)\/(@PA-b.sh-b.ci),3) AS obp\r\n , round(100*(@OBP\/r.woba),0) as OBPplus\r\n , @SLG := round((b.h+b.d+2*b.t+3*b.hr)\/b.ab,3) as slg\r\n , round(@OBP+@SLG,3) as ops\r\n , round(@SLG-@BA,3) as iso\r\nFROM \r\n players_career_batting_stats b \r\n INNER JOIN leagues l ON b.league_id=l.league_id \r\n INNER JOIN teams t ON b.team_id=t.team_id\r\n INNER JOIN tblRunValues2 r ON b.year=r.year AND b.league_id=r.league_id\r\n WHERE b.ab<>0 AND b.split_id=1\r\n ORDER BY b.player_id, b.year<\/code><\/pre>\n
\nThe full script as it stands now:<\/p>\n
#Calculated batting stats for OOTP\r\n DROP TABLE IF EXISTS CalcBatting;\r\n CREATE TABLE IF NOT EXISTS CalcBatting AS\r\n\r\n SELECT b.year\r\n , b.league_id\r\n , b.player_id\r\n , b.stint #We can eventually move this down the list\r\n , b.split_id #We can eventually remove\r\n , b.team_id #We can eventually move this down the list\r\n , l.abbr as Lg\r\n , t.abbr as Team\r\n , b.g\r\n , b.ab\r\n , @PA := b.ab+b.bb+b.sh+b.sf+b.hp AS PA\r\n , b.r \r\n , b.h\r\n , b.d\r\n , b.t\r\n , b.hr\r\n , b.rbi\r\n , b.sb\r\n , b.cs\r\n , b.bb\r\n , b.k\r\n , b.ibb\r\n , b.hp\r\n , b.sh\r\n , b.sf\r\n , b.gdp\r\n , b.ci\r\n , @BA := round(b.h\/b.ab,3) AS ba\r\n , round(b.k\/@PA,3) as krate\r\n , round((b.bb)\/@PA,3) as bbrate\r\n , @OBP := round((b.h + b.bb + b.hp)\/(@PA-b.sh-b.ci),3) AS obp\r\n , round(100*(@OBP\/r.woba),0) as OBPplus\r\n , @SLG := round((b.h+b.d+2*b.t+3*b.hr)\/b.ab,3) as slg\r\n , round(@OBP+@SLG,3) as ops\r\n , round(@SLG-@BA,3) as iso\r\n \/* NOT yet modified for OOTP and MySQL\r\n , round((r.wobaBB*nz(b.bb,0) + r.wobahb*nz(b.hbp,0) + r.woba1b*(b.h-b.[2b]-b.[3b]-b.hr) + r.woba2b*b.[2b] + r.woba3b*b.[3b] + r.wobahr*b.hr)\/(b.ab+nz(b.bb,0)-nz(b.ibb,0)+nz(b.sf,0)+nz(b.hbp,0)),3) as woba\r\n , round((([woba]-r.lgwoba)\/r.wobascale)*[PA],1) as wRAA\r\n , round(((([woba]-r.lgwoba)\/r.wobascale)+(l.totr\/l.totpa))*[PA],0) as wRC\r\n , ((([wRAA]\/[PA] + l.RperPA) + (l.RperPA - t.bpf*l.RperPA))\/(lb.wRC\/lb.PA))*100 AS [wRC+]\r\n *\/\r\n FROM \r\n players_career_batting_stats b \r\n INNER JOIN leagues l ON b.league_id=l.league_id \r\n INNER JOIN teams t ON b.team_id=t.team_id\r\n INNER JOIN tblRunValues2 r ON b.year=r.year AND b.league_id=r.league_id\r\n WHERE b.ab<>0 AND b.split_id=1\r\n ORDER BY b.player_id, b.year<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"A short post for three pretty straightforward rate stats: Slugging Percentage, On Base Plus Slugging, and Isolated Power. All three are measures of a batter’s hitting for power. \u00a0Keeping with my tradition here of not explaining things that I understand, I will get straight to the point. \u00a0Seeking to keep things simple and readable, and… Continue reading Batting Stats 3: SLG, OPS, and ISO<\/span>