Mutual Fund Data

This project received 8 bids from talented freelancers with an average bid price of $304 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I need someone to compile historical data on 200 mutual funds. For the data gathering, it will be done through public websites like Yahoo Finance. Because of the amount of data, I am only looking for someone who can write an application that will crawl through the websites and automatically arrange the data onto an Excel spreadsheet in a specific way (similar to this [url removed, login to view] I will give you a sample Excel sheet showing how it needs to be laid out).

This is the data that is needed (all of this is on Yahoo Finance and other sites):

1. Historical monthly price

2. Current Expense Ratio

3. Current R-Squared

4. Calculated Standard Deviation (3 year)

5. Calculated Sharpe Ratio

Here’s how to calculate Standard Deviation and Sharpe Ratio: [url removed, login to view])

Yahoo Finance typically only goes to the early-mid 1990s, if you have a way of getting data that is even earlier than this I would HIGHLY consider your bid. The data will need to go up to December 31, 2012.

As far as specifically what funds, I will provide you a list of the 200 funds and again, I’ll need the data laid out in a specific way for how I’m using it. Thank you.

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