Analyzing Stock Market Data

I wrote my own VBA script to analyze real stock market data.

Features & Libaries

• Excel
• VBA

My Process

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

• Ticker symbol
• Yearly change
• Percent change YoY
• Total stock volume of the stock.

2. Write a script for conditional formatting

Screenshot

This code was written in VBA, and the output was NOT made by hand in excel