VBA-challenge

Data Analytics Bootcamp Assignment 2 - VBA

' Data Analytics and Visualization Bootcamp

' Module 2 - VBA Scripting

' Version 1.1

' Assignment 2

' Name: Thet Win

' Date: May 5, 2024

VBA Script that loops through all the stocks for each quarter and outputs the following information:

• The ticker symbol

• Quarterly change from the opening price at the beginning of a given quarter to the closing price at the end of that quarter.

• The percentage change from the opening price at the beginning of a given quarter to the closing price at the end of that quarter.

• The total stock volume of the stock.

• Add functionality to your script to return the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume".

Code Reference Sources:

https://www.wallstreetmojo.com/vba-conditional-formatting/#h-example-1

https://stackoverflow.com/questions/51977446/vba-find-highest-value-in-a-column-c-and-return-its-value-and-the-adjacent-ce