Using VBA scripting to analyze real stock market data.

• Create a script that will loop through all the stocks for one year and output the following information.

  1. The ticker symbol.
  2. Yearly change from opening price at the beginning of a given year to the closing price at the end of that year.
  3. The percent change from opening price at the beginning of a given year to the closing price at the end of that year.
  4. The total stock volume of the stock.

• Use conditional formatting that will highlight positive yearly percent change in green, and negative yearly percent change in red.

• Find and display the stock with the “Greatest % increase”, “Greatest % decrease” and “Greatest total volume”.

• 2014 Stock Market Analysis Results:

• 2015 Stock Market Analysis Results:

• 2016 Stock Market Analysis Results: