Mutual Fund Data

Cancelled

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.

Skills: Data Entry, Excel, Finance, Financial Research, Visual Basic

See more: mutual fund data, excel mutual fund data, excel mutual finance, yahoo mutual fund data excel, mutual fund data excel, yahoo-finance, what is r squared, mutual fund finance excel, excel mutual fund spreadsheet, Mutual funds, mutual fund, finance r, finance excel data, data gathering, crawl data, bf, getting data, crawl sites excel, net crawl, application crawl, finance data excel, crawl net, yahoo pdf excel, write data excel spreadsheet, pdf corporate looking

Project ID: #4245381

8 freelancers are bidding on average $304 for this job

pandey2008

let's start.thanx

$150 USD in 5 days
(67 Reviews)
5.1
gshiels

I can do this via Yahoo, in Excel, using VBA. Please check my feedback.

$500 USD in 5 days
(12 Reviews)
5.0
KKFA

As you can see in our profile we are already work in a familiar program in finance yahoo api. even though that our rating as a team is low , as we are new freelancers ,we are sure that you ll be satisfied from the r More

$300 USD in 5 days
(2 Reviews)
2.9
arif15

Can do the work. Please read PM.

$120 USD in 5 days
(2 Reviews)
2.2
florin5231

I like this project . Whend i start working ?

$245 USD in 8 days
(0 Reviews)
0.0
shrirampoulkar1

right now i am working for mutual fund industry so i can do ur project easly and i ve copyrights projects also

$110 USD in 7 days
(0 Reviews)
0.0
sakamotoraj

I currently have a software I wrote in Matlab that downloads Yahoo price data. This can be customized to suit your needs.

$250 USD in 8 days
(0 Reviews)
0.0
bobtech247

Bob knows data visualization. I have access to professional market data. I would prefer to create the bubble charts in a more robust tool like R if that is acceptable. All source code would be provided so you can easil More

$750 USD in 7 days
(0 Reviews)
0.0
sindujavenkat

Hello, I am an experienced Excel user and Financial Researcher. I can complete the data population in two days if you provide a list of funds- as I know how to design the application required to populate the spreadshee More

$250 USD in 4 days
(0 Reviews)
0.0