Closed

Excel Web Scraper for baseball-reference.com

This project was awarded to JScottArnold for £165 GBP.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
£20 - £250 GBP
Total Bids
11
Project Description

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 [url removed, login to view])
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 [url removed, login to view])
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:
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online