Hopefully someone can point me in the right direction. 5 people (including myself) have been doing an offline keeper league for almost 10 years now and we have been manually keeping track of the scores each day. Obviously, this is hard. I am looking for a way to automate the process either via a website or excel or whatever. I've thought about writing a program to pull stats of a website but that would be last resort giving the amount of time it would take to develop. Below is our scoring system. Thanks!
jbrady3324 wrote:Hopefully someone can point me in the right direction. 5 people (including myself) have been doing an offline keeper league for almost 10 years now and we have been manually keeping track of the scores each day. Obviously, this is hard. I am looking for a way to automate the process either via a website or excel or whatever. I've thought about writing a program to pull stats of a website but that would be last resort giving the amount of time it would take to develop. Below is our scoring system. Thanks!
Starting Pitchers 10- Win 5- Complete Game IP-Earned Runs -5-Loss 1- Strikeout -1- Walk
Closer 7- Save 5- Scoreless Appearence 2- Win -2- Blown Save, Loss 1- Strikeout -1- Walk
Middle Relief 5- Scoreless Appearence 5- Win 3- Save 1- Strikeout -1- Walk IP-Earned Runs -2-Loss, Blown Save
Set up 5 bogus email accounts. Set up a yahoo league, with your scoring. Set up the 5 teams with the 5 rosters. let yahoo pull the stats for you. Copy and paste the results to your friends and don't tell them how you are doing it.
B-Chad wrote:Pedroia's LD rate of 20% is reason to believe he'll maintain a higher BA then Cano. It should also be noted he hits more FB's then Cano, which means that even if he posts a lower HR/FB then Cano, he should come in reasonably close to Cano in HR's
Issue is that Yahoo does not do this type of scoring based on batting order position. We prefer a free method to do this but are not opposed to paying a small fee to a website that can do this.
I don't know if it is the best way, but it is free and entirely customizable ...
Use mlb.com's Gameday XML feed to parse out whatever it is you need. Start here: http://gd2.mlb.com/components/game/mlb/ load year, day/month ... find the game you want, etc.
It took me about 4 hours to write a scoring program for my points league.
If you can automate generating the day and month, the url above can be built up to the /gid part. You can read in a days scoreboard (http://gd2.mlb.com/components/game/mlb/ ... eboard.xml) to populate the /gid part and beyond. Once you have that ...
For any given game, boxscore.xml should have everything you need. The hardest part is getting HBP and Inherited Runners out of the <game_info> section. If you do not need those for scoring, its a breeze. Some comments from my VB code outlining the format of the boxscore sections ... I only use 2.2, 2.3, 2.4, 2.5 and 2.6 below.
My scoring code is highly tailored for my needs, but if you have MS Excel 2000 + and would like a copy of what I have (Excel spreadsheet with VBA macros) you should be able to tweak it up to fit any needs. PM me your email and I will send you the .xls file.
ex. Shane Victorino yesterday 2/3 3 runs, 2BB, 2BI, 1HR and batted 1st is the extra scoring per batting position in addition to or does it replace Everyone - points?
If added, Victorino would get 3 points per RS, if replaced he would get 2 points.
Let me know and I will knock the rest of this out.
PM sent. Was pretty straighforward changes. Pitching types (SP, MR, CL) was hard for me to determine how you determine, so I just score every pitcher as all 3 types. You can decide which one of the 3 you want on a per pitcher basis. I could do it by looking at the point they were brought in the game, but I don't currently parse that XML node and am on limited time through the rest of the weekend.
Cafe Home
Fantasy Football
Fantasy Basketball
Fantasy Hockey
by jbrady3324 » Tue Apr 06, 2010 12:45 pm 
