Stock data for 2018-2020 was analyzed using VBA according to the specifications below:
Create a script that loops through all the stocks for one year and outputs 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. The result should match the following image:
Moderate solution
Add functionality to your script to return the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume". The solution should match the following image:
Hard solution
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.
Define code
Refer documentation on VBA
Define function
Loop with condition if/else
This project used code that was authored by Lauren Ables-Torres and edX Bootcamps LLC.