Mutual Fund Data

CANCELLED
Bids
9
Avg Bid (USD)
$297
Project Budget (USD)
$30 - $250

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 http://www.s-anand.net/motion-chart.xls 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: http://corporate.morningstar.com/bf/documents/MethodologyDocuments/MethodologyPapers/StandardDeviationSharpeRatio_Definition.pdf)

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.

Skills required:
Data Entry, Excel, Finance, Financial Research, Visual Basic
Hire tpdenver
Project posted by:
tpdenver United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire pandey2008
$ 150
in 5 days
$ 500
in 5 days
Hire KKFA
$ 300
in 5 days
$ 120
in 5 days
Hire florin5231
$ 245
in 8 days
$ 110
in 7 days
Hire sakamotoraj
$ 250
in 8 days
Hire bobtech247
$ 750
in 7 days
Hire sindujavenkat
$ 250
in 4 days