VBA on Ticker Tracker

To recreate my results, click This Excel File and then "view raw" to download the stock data, then paste the text from my VBA Script into a module within VBA. Finally click the developer tab and run the macros.

This VBA script loops through all the stocks for one year and output the following information before repeating this process on the next years (worksheets) data:

• The ticker symbol.
• Yearly change from opening price at the beginning of a given year to the closing price at the end of that year.
• The percent change from opening price at the beginning of a given year to the closing price at the end of that year.
• The total stock volume of the stock.
• The stocks "Greatest % increase", "Greatest % decrease" and "Greatest total volume".

Tech Stack

• Miscrosoft Excel and VBA