I require THREE Excel Spreadsheets with Macros built in to them to scrape desired data from baseball-reference.com. The sheets should require a few simple inputs to determine the information to scrape, followed by a 'Scrape' button to activate/run the macro (View 'Setup' sheet of the attached workbooks).
From this output, I require the data to be correctly inserted into various sheets within the workbook. Each sheet requires various, differing parts of the scraped data in various columns (see attached examples for the data/column layout)
The first sheet required will scrape Player Data in order to create a player database (...Player DB Scrape eg.xlsx)
The second sheet will be a simpler version of the first sheet, and will simply scrape each/all team's roster(s) for a particular year (...Roster Scrape eg.xlsx)
The final sheet will be a box score scraper
I have attached examples of each sheet and the sort of input options I want, as well as the various outputs desired.
URL's of the specific examples are in each sheet, but I shall also list them here:
It is important that the programmer has sufficient knowledge of excel, VB/Macros as well as a good understanding of Baseball.
If you have any questions or require further clarification of anything, please ask.