Create a script that will loop through all the stocks for one year and output the following information:
-
The ticker symbol.
-
Yearly change from the opening price at the beginning of a given year to the closing price at the end of that year.
-
The percentage change from the opening price at the beginning of a given year to the closing price at the end of that year.
-
The total stock volume of the stock.
-
Add functionality to your script to return the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume".
-
Make the appropriate adjustments to your VBA script to enable it to run on every worksheet (that is, every year) at once.
-
Make sure to use conditional formatting that will highlight positive change in green and negative change in red.
Note: Asked for helped on an issue with a teacher assistant and a peer for debugging and autofitting cells.
Note2: I uploaded the original excel files and also the completed Excel files with the scripts included.
Note3: I uploaded the VBA Script file on its own.