A Visual Basic 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.
As well as:
-
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.
-
Clone the repo
git clone https://github.com/manc1n1/VBA-challenge.git
-
Change directories to
VBA-challenge
cd VBA-challenge
-
Run the Visual Basic Script in your
.xlsm
file.
- Run the macro in the
.xlsm
file.