Backtesting an investment strategy with EXCEL VBA!

In Progress Posted Nov 15, 2010 Paid on delivery
In Progress Paid on delivery

need an excel VBA app created to backtest investment strategies, I will give you a sample of the strategy backtested on one index, however I want you to create a simple user box that allows the user to test the strategy on several companies/indices (I will provide you with a downloader). Then I want to give the user an option to rank the companies by various statistics (you will them in the example, volatility overall portfolio return etc).

So the long and short:

You will make a userbox/interface that lets the user choose the ranking method, the list of companies, computes the same statistics as the sample and shows a graph of the different company values using the strategy over time.

deliverables :

There is one deliverable it is the UI that works. The user selects the list of securities/indices, then they select a ranking metric. The results are outputted on a new spreadsheet and ranked with the graph of the company values over time (for each company under the strategy).

I need this done in four hours

The bid end date is incorrect, I need this done ASAP!!!

Visual Basic

Project ID: #854449

About the project

1 proposal Remote project Active Nov 15, 2010

1 freelancer is bidding on average $30 for this job

cpromaster

Hi. I can provide it. Please check PM.

$30 USD in 1 day
(0 Reviews)
0.0