Stock market analysts often work with large, structured data sets to extract valuable market insights and make forecasts based on the data. The analysis of such sets often includes repetitive tasks which can be automated using VBA scripting. This project analyzes real multi-year stock market data to achieve the following goals for each analyzed year:
- For each ticker symbol in the data set, get the yearly change, percent change and total stock volume.
- Return the greatest % increase, greatest % decrease and greatest total volume
- Run through every worksheet, i.e. every year, by running the VBA script once.
Stock data Excel file from 2014 to 2018. The complete analyzed data set can be found in the Excel files included in this repository.
This repository contains the VBA code in the VBA Homework script.vb
file. This script can be run in the .xlsm
files as macros to get the corresponding results.