Backtesting an investment strategy with EXCEL VBA!
$30-250 USD
Pago na entrega
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!!!
ID do Projeto: #854449