Messages

MLB RUN ESTIMATOR

This spreadsheet is based off of Marko123 – MLB Prediction Formula thread.  As Marko mentions - this is a work in progress in its early stages and still work being done by Marko to fine tune.

Features:

·         Today’s matchups are updated from baseballpress.com when you click the “Update Lineup” button

·         Pitching and Team stats needed to complete the Run Estimation formula are updated when you click on the “Update Pitching Stats” and “Update team Stats” Button

·         NOTE: From time to time a new pitcher (say one called up from AAA) or if a pitcher goes to a different team – an error will occur when updating the pitching stats.  You will need to update the Pitcher List with the proper links from baseball reference and re-run the query.

You can download from the link below:

https://docs.google.com/open?id=0B5dydT9Oe6Jbdkd1alJRRENtVnM

Also available in my spreadhseets and more thread.

Interesting Stake - i will have to look at Rickey and MOB in more detail.....thanks

As far as catagorizing pitchers - pretty much anything can be automated - but I'm not sure I see the value in catagorizing the pitchers since a knuckleball pitcher like RA Dickey for example may not perform the same against a specific team as say another knucleball pitcher.  I see where you're going though - see if a specific team hits a specific pitcher type better or worse.  But there is no way to know if that team doesn't hit that pitcher type well - OR that specific PITCHER well.  I think you would be better off looking at past track record of team vs.  that pitcher and if no data is available - lay off that game.