Skip to content

Latest commit

 

History

History

excel_vbas

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 

Calculating historical stock market data in VBA

The following VBA code takes a large dataset consisting of historical stock market data and calculates the yearly change, percent change and total stock volume for each ticker. Additionally, it also calculates the ticker with the greatest % increase, the greatest % decrease and the greatest stock volume. 2020 2019 2018