Skip to content

Instantly share code, notes, and snippets.

@LeeZee1

LeeZee1/code for creating season-to-date FIP- column

Created May 16, 2016 06:27
Show Gist options
  • Save LeeZee1/0a47e76cfe1820ec59a2eb9c8fd61dec to your computer and use it in GitHub Desktop.
Save LeeZee1/0a47e76cfe1820ec59a2eb9c8fd61dec to your computer and use it in GitHub Desktop.
Download ZIP
Raw
code for creating season-to-date FIP- column
ALTER TABLE starting_pitcher_stats ADD COLUMN std_FIPm1 DOUBLE;
UPDATE starting_pitcher_stats SET std_FIPm1 = (std_FIP + (std_FIP - (std_FIP*(std_F_parkfactor/100))))/(std_lg_FIP)*100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment