VBA Stock Data Visualizations

Overview & Findings

This is a simple report using a script that loops through all the stocks for one year and outputs the following information:

• 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.