For the years 2014–2016, this reviews annual trading per stock ticker.
Daily Stock Trades There are over 700,000 trades per year on the stock market, yet the trades revolve around the approximate 3,000 companies known by their ticker symbol. The goal is to find the annaul trading volume per stock.
Macro for Annual Volume To do this, I created a simple macro button that can quickly parse through the results. The major elements in the code are a For Loop, Next Cell, Finding Last Row, Adding Columns that auto-adjust width, and Formatting borders.
Annual Results: 2014
https://github.com/charlasu/Stock-Market-Annual-Trading-Volume/blob/master/AnnualVolume_2014.vbs
Annual Results: 2015
https://github.com/charlasu/Stock-Market-Annual-Trading-Volume/blob/master/AnnualVolume_2015.vbs
Annual Results: 2016
https://github.com/charlasu/Stock-Market-Annual-Trading-Volume/blob/master/AnnualVolume_2016.vbs