Wall Street Quicklook Using VBA Script

---

Visit my Online Portfolio

Overview

Data:

• Provided with an excel sheet containing about 71,000 rows of WallStreet Data
• Each data entry included the Ticker Symbol, Date, as well as the following daily attributes: Opening Price, Closing Price, Highest Price, Lowest Price, and Volume.

---

Project:

A VBA (Visual Basic for Applications) script was developed to loop through all stocks and create a column for:

1. Total Volume of each Stock’s Sales throughout the year,
2. Stock’ Ticker Symbol,
3. Yearly Price Change (Opening price to Closing Price),
4. Yearly Percent Change (Opening price to Closing Price),
5. Greatest & Increase/Decrease,
6. Greatest Total Volume.

---

Ticker Summary:

Quickloock Snapshots:

Summary Excel File Can Be Seen Here:

Conditional formatting was applied to the Excel worksheets seen in the screenshots.