Peruttu

Mutual Fund Raw Data - repost

I need someone to compile lots of historical data of 200 mutual funds into three Motion Graphs that work in Excel. 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.

Let me share with you what I am doing. Watch the video: [url removed, login to view] Similarly, I’m looking to put mutual fund data into one visualization. Here is a great guide in how to create these Motion Graphs ([url removed, login to view]); there’s a link to just download the sample Excel worksheet.

I would like to create an analysis of a lot of mutual funds in three Motion Charts. This is the data that is needed (all of this is on Yahoo Finance):

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

GRAPH #1 – Expense Ratio

On the Motion Chart, each “bubble” would represent one mutual fund. The first chart will be to show that over time expensive (i.e. higher “Expense Ratio”) funds under-perform low cost funds. The Y (vertical) axis represents Performance (i.e. month to month price), and the X (horizontal) axis represents Risk (i.e. 3 year Standard Deviation). The size of the bubble represents expense ratio.

We’d take the expense ratio of all the funds and segment out the mutual funds by quartiles. Color the bubbles according to their quartile expense ratio: the highest cost quartile mutual funds Red, the next quartile Orange, the next Blue, and the cheapest Green (so that the high expense ratio funds are shown as bigger/“fat” red bubbles and the low cost funds are smaller/“skinny” green bubbles).

Then in the Motion Graph we start the graph as early as we can (Yahoo Finance typically only goes to the early-mid 1990s, I’d be VERY happy if you can go earlier).

The cheapest ones should show out performance and lower risk. I believe that if we animate it, over time the green bubbles will move to the upper left quadrant (showing relatively lower risk to higher performance) and the expensive bubbles to the lower right (showing relatively higher risk to lower performance).

GRAPH #2 – R-Squared

The second Motion Chart would be to show that index funds outperform managed funds. The way we’d do this is by R-Squared. This one would only have two colors: Blue and Red. The index funds would be the funds with an R-Squared of 99.8-100.0.

Again, we’d run the chart and (hopefully) the index funds would gradually outperform the managed funds.

GRAPH #3 – Sharpe Ratio

We’d use the same coloring of Graph #2 where the index funds are isolated. We’d simply graph it for how the Sharpe Ratio changes over time. I don’t imagine that this chart will have as much movement as the other two. But just that the index funds will “hover” above the other bubbles with a little variation.

As far as specifically what funds, it will be200 of them and I will share this list with you when I award the project. The data would need to be laid out like the Excel document here ([url removed, login to view]). Thank you.

Taidot: .NET, Talousmarkkinat, Taloudellinen tutkimus, Perl, Tutkimus

Näytä lisää: yahoo-finance, www create a graph, what is r squared, what graph to use for data, use of graph, sample graph data, low cost websites, link graphs, how to graphs, how to graph data, how to create graph, how to create a graph, how to animate video, how to animate a video, how much youtube red cost, how much cost youtube red, how do you graph data, how do you animate a video, graph to data, graph this data, graph the data, graphs with data, graphs of data, graphs for data, graphs data

About the Employer:
( 21 reviews ) Greenwood Village, United States

Projektin tunnus: #4234527

2 freelanceria on tarjonnut keskimäärin 65 $ tähän työhön

ETNASoftware

Hello, I have couple of guys who would be perfect fit with extended technological background & experience with financial software development. Examples of our projects: [url removed, login to view] Please contact me Lisää

30 $ USD 1 päivässä
(1 arvostelu)
5.0
raskinlove

dear sir we have 4 year experience in development. also having good knowledge in php , MySQL,css,jscript. i can complete the task as per the standard. and i am much aware the function which will required to complete Lisää

100 $ USD 5 päivässä
(2 arvostelua)
2.4