The mission of this project was to produce a summarized report of daily stock market activity of 2,835 publically listed companies, over a three-year period, and identify the companies that had the largest gains, losses and trade volume per year.

Raw data was supplied to me in Excel sheets, 1 sheet per calendar year. I created a VBA script that condensed daily transaction data (nearly 800,000 rows of data) into yearly summary data per company (2,835 companies), and automatically identified the biggest movers. This script is optimized to work with any sheet with data presented in a similar way.

In the repository you can see:

-The VBS file with my code and commentary
-The Excel sheet with the raw data and the VB script executed.
-Screenshots of the execution, for good measure!

I invite your feedback!