This task is to use VBA scripting to analyze generated stock market data
-
I created a script to loop through all the stock from year 2018 to 2020, creating ticker, yearly change, percentage change, total stock volume columns and adding colour to the yearly change colour
-
2018
-
2019
-
2020
