THE BOOK cover
The Unwritten Book is Finally Written!
An in-depth analysis of: The sacrifice bunt, batter/pitcher matchups, the intentional base on balls, optimizing a batting lineup, hot and cold streaks, clutch performance, platooning strategies, and much more.
Read Excerpts & Customer Reviews

Buy The Book from Amazon

SABR101 required reading if you enter this site. Check out the Sabermetric Wiki. And interesting baseball books.
MOST RECENT ARTICLES
MAIL : You ask | We say

Advanced


THE BOOK--Playing The Percentages In Baseball

Filter posts by...

 

Monday, May 11, 2009

FIP constants

By Tangotiger, 01:16 PM

Someone asked me for the FIP constant to use for all the years, leagues.  Here’s the SQL that you can plug into the Access DB:
SELECT
lgID
, yearID
, Sum(9*[ER]+2*[SO]-3*([BB]-nz([IBB])+nz([HBP]))-13*[HR])/(Sum([IPouts])/3) AS FIP_constant
FROM Pitching
GROUP BY lgID, yearID

Note that the “BB” term is non-intentional walks plus hit batters.  The “Nz” is to count as zero those terms if they don’t exist.  “IPouts/3” gives you IP.

Here’s the handy-dandy file: FIP_constant.txt

(10) Comments • 2010/02/12 • Sabermetrics • Data
Page 1 of 1 pages

Recent comments

May 25 19:41 What sabermetrics is NOT
May 25 19:41 Pete Palmer’s new book: Basic Ball
May 25 19:38 “Why Kickstarter works”
May 25 17:32 Largest demonstration in Canadian history?
May 25 16:59 Howard Stern
May 25 15:12 Do pitcher’s reach back for velocity when needed?
May 25 12:51 Chad Curtis
May 25 11:26 Lack of hustle during a game
May 25 10:58 Rooting for laundry
May 25 02:38 NFLPA lawsuit against collusion
May 25 01:43 Neal Huntington’s best moves
May 24 17:04 Firefox, IE, or Chrome?
May 24 12:07 How to beat the shift
May 24 11:11 Incredible story
May 24 09:41 Racial bias in card collecting: not the collectors, but the players on the cards
May 24 08:13 espnW for hockey: CBC’s WhileTheMenWatch.com
May 24 00:16 Psst… wanna intern… somewhere?
May 23 23:33 Inertia of player safety
May 23 21:36 Doc Halladay: this month’s “hey, a superstar generated random numbers, let’s build a narrative!”
May 23 19:43 Minor league baseballs are built to different specifications than major league baseballs

Older comments

Page 1 of 344 pages  1 2 3 >  Last »

Complete Archive – By Category


Complete Archive – By Date

You must love baseball to post in this blog.

"Think of this place as something like a college classroom. We’re in charge, we pick the topics, we set the rules, and we try to foster as much intelligent discourse as possible. If this isn't your cup of tea, there are plenty of other sites out there for you to try—we're not going to be for everybody, and we're not going to try to appeal to the masses." —USSM

The views, comments and reactions in this website are personal views, comments and reactions of the individual bloggers and visitors of this website. Each of Andy, Mitchel, and Tom disclaim and disavow responsibility whatsoever of anything written by the other two, or by the visitors, as it is not reflective of his own views, comments and reactions to any issue at hand. Please be advised accordingly.

Latest...

COMMENTS

May 25 19:41
What sabermetrics is NOT

May 25 19:41
Pete Palmer’s new book: Basic Ball

May 25 19:38
“Why Kickstarter works”

May 25 17:32
Largest demonstration in Canadian history?

May 25 16:59
Howard Stern

May 25 15:12
Do pitcher’s reach back for velocity when needed?

May 25 12:51
Chad Curtis

May 25 11:26
Lack of hustle during a game

May 25 10:58
Rooting for laundry

May 25 02:38
NFLPA lawsuit against collusion

THREADS

May 11, 2009
FIP constants

Add to My Yahoo | RSS 2.0 Summary | RSS 2.0 Comments |     
Powered by ExpressionEngine