-
The script will loop through all the stocks and take the following info:
-
Yearly change from the stock price at the beginning of the year to the price at the end of the year.
-
The percent change in that stock’s price from the beginning of the year to the end.
-
The total volume of the stock traded over the year with ticker symbol
-
-
Applied conditional formatting to highlight a yearly increase in the stock price in green, and a decrease in the stock price in red.
-
Identified the stock with the greatest percentage increase in its price; the stock that suffered the greatest percentage decrease in its price; and finally, identified the stock with the greatest trade volume.
-
The script covered every worksheet by running it once.
teomotun / the-vba-of-wallstreet Goto Github PK
View Code? Open in Web Editor NEWWall Street Stock analysis with Excel VBA