henryle-n / stock-analysis-vba Goto Github PK

VBA is excellent choice for Excel spreadsheet automation, especially in this project where an Excel Workbook consists of multiple years of stock data from 2014 to 2016 (~2.3 million rows of data): VBA codes to loop through each year, each stock in that year, and provide comprehensive summary tables of stock counts, total volumes, losses, and gains. It's almost impossible for manual summary of this large amount of data. The whole stock workbook was analyzed in less than 3 minutes while the same tasks could take human days if not weeks to manually complete.