Need MS Excel expert to clean up and finish MS excel analytical tool consisting of 8 linked pages providing alternative methods of analysis which tie to a cover page/dashboard. Formulae and layout for each analysis are already provided and appear to function properly if data is manually inserted.
Need to add: (1) ability to download relevant stock and option data from public sites on the internet for use in the analytical tool [daily open, high, low and closing price for each trade (stocks, options). Also, download volatility for options only. On one particular spreadsheet, the high and low prices are needed for the previous 15 trading days], and
(2) commercial quality password protection.
Please do not bid on this project unless you have extensive MS Excel experience with financial models and proven ability to extract data from the internet. Final work product must be platform agnostic and work on both MS Excel for Windows XP/Vista and Excel for Mac OSX.
Objective is to turn analytical tool into commercial product. This is an ongoing project. Exceptional work on this phase will lead to additional development opportunities.