I 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
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
2) 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).
## Platform
Excel VBA