You are well on your way to becoming a programmer and Excel master! In this homework assignment you will use VBA scripting to analyze real stock market data. Depending on your comfort level with VBA, choose your assignment from Easy, Moderate, or Hard below.
-
Test Data - Use this while developing your scripts.
-
Stock Data - Run your scripts on this data to generate the final homework report.
-
Create a script that will loop through each year of stock data and grab the total amount of volume each stock had over the year.
-
You will also need to display the ticker symbol to coincide with the total volume.
-
Your result should look as follows (note: all solution images are for 2015 data).