Using ticker symbols for 2,835 stocks on the New York Stock Exchange over the course of 3 years (2014-2016), each year's worksheet demonstrates whether or not the stock made overall gains or losses based on a color code (green: positive, red: negative) using conditional formatting. The total stock volume and percent change are noted next to these color-coded ticker symbols.
The included script calculates the stocks with the greatest % increase, greatest % decrease, and largest volume in a separate table at the top of each sheet.
Comments are included in the VBA script for clarification on the functionality of each line of code.