This dataset includes an excel file containing stock market data for several years. Each row in the dataset represents a stock on one day, and includes ticker symbol, date, opening/closing prices, high/low prices, and volume sold.
This VBA code will create a summary table within the same worksheet for each stock that includes:
- ticker symbol
- yearly change (with conditional formatting to show increase or decrease)
- percent change (with conditional formatting to show increase or decrease)
- total stock volume
The code then summarizes the following data for each year:
- which stock had greatest percent increase
- which stock had greatest percent decrease
- which stock had greatest total volume
For 2014-2016, here are some findings:
-
2014 greatest % increase: DM
-
2014 greatest % decrease: CBO
-
2014 greatest total volume: BAC
-
2015 greatest % increase: ARR
-
2015 greatest % decrease: KMI.W
-
2015 greatest total volume: BAC
-
2016 greatest % increase: SD
-
2016 greatest % decrease: DYN.W
-
2016 greatest total volume: BAC