Stock Market Analysis

VBA script analyzing the stock market from 2014 to 2016 in three parts.

Part 1:

• 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.
• Display the ticker symbol to coincide with the total volume.

Part 2:

• Create a script that will loop through all the stocks and take the following information.

  • Yearly change from what the stock opened the year at to what the closing price was.
  • The percent change from the what it opened the year at to what it closed
  • The total Volume of the stock
  • Ticker symbol
  • Add conditional formatting that will highlight positive change in green and negative change in red.

Part 3: Under Construction

• Your solution will include everything from the moderate challenge.
• Your solution will also be able to locate the stock with the "Greatest % increase", "Greatest % Decrease" and "Greatest total volume".
• Make the appropriate adjustments to your script that will allow it to run on every worksheet just by running it once.