The stats I would like pulled are from the [url removed, login to view] page under [url removed, login to view] (eg. [url removed, login to view]):
In case the above is confusing, I need the sum of the runs from the first 5 innings. Also, I only need the stats (outs, earned runs) for the first pitcher listed for home and away (starters) to be pulled. The seemingly difficult part is pulling the wins, losses and ERA of the starting pitchers coming IN to the game, not after. As an example, these stats can be
[url removed, login to view]
The starters played ids would have to be traced from the [url removed, login to view] page to [url removed, login to view] page in order to grab these three stats.
Also, I would like to have the wins and losses for each team coming into the game, not after. Since I don't see this data located anywhere in the components site, it would have to be calculated. The calculation would be simple: if 'home team' wins, subtract 1 win from the 'home team' wins; if 'home team' loses, subtract 1 loss away from the 'home team' losses; likewise for the away team.
I would like this set up so it can be run on a daily basis. It would be really nice if the data could be put into a CSV file like the attached example, and emailed to my email account as an attachment so I could view the data from a remote computer. Please let me know if you have other questions.