Analysis of Stock Market Data

In this class project, I was tasked to use VBA scripting to analyze real stock market data. 

The instructions are as follows:

1) Create a script that will loop through all the stocks for one year for each run and take the following information:

 a. The ticker symbol.

 b. Yearly change from opening price at the beginning of a given year to the closing price at the end of that year.

 c. The percent change from opening price at the beginning of a given year to the closing price at the end of that year.

 d. The total stock volume of the stock.

2) Create conditional formatting that will highlight positive change in green and negative change in red.

3) Return the stock with the "Greatest % increase", "Greatest % Decrease" and "Greatest total volume".

4) Make the appropriate adjustments to your VBA script that will allow it to run on every worksheet, i.e., every year, just by running the VBA script once.