Using Visual Basic in Excel Create an application that allows the user to input 5 stocks (pull stock data from yahoo finance) and return a portfolio optimization for those stocks. This will obviously involve using Solver in Excel. The app should be dynamic, so that if more stocks are to be added then it can be easily done. Include these attributes to the application: User forms to show basic functionality of the app, along with other info that should be provided to the user. - Instructions on the applications use for the user - Due to finite nature of solver calculations, please include a way to inform the user of the current stock portfolio variables so the user can make more informed decisions as to the maximum weightings of each stocks and expected returns. - We are assuming the user is very knowledgeable in financial matters but not with computer applications. 1. Ability to move between screens in both forward and backwards direction. 2. Ability to change data inputs but also includes a sample data by default that the user can use as demonstration of how the app works. 3. Hides the spreadsheet models and data from user view. 4. Proper titles and info icons on forms, msg boxes and input bpxes etc. 5. Use of default values where appropriate 6. Tabbing order that makes sense and creates easy to use interface 7. Ability to step backwards in the data entry stage 8. Use of colors and theme throughout the app 9. MUST use "option explicit" at the start of modules and user forms
Attachment:- excel file.xlsm