I need someone to help me out with the Excel file with stock price data. The excel file has the data and the set of formulas applied to that data. I wish to have an automated file which can do the following.
1. The final model should be able to pick up the data from a new file ( Which will have (upto 2 Years) share prices of upto 20 stocks) and then be able to apply the predefined formulas (All formulas provided) on that data.
2. Present the computed values in a presentable form (Dashboard).
3. Model should be able to take inputs and use "solver" function to compute the other values.
More information on request.
I am looking for freelancers with the lowest rates