stock-analysis

module 2

Project Overview

This project aims to refactor the original workbook's code so that it runs faster and could be used to analyze the entire stock market in the future.

Results

After trying multiple ways, the code was eventually adjusted to use a tickerIndex and 3 arrays to calculate the Total Daily Volume and Return for each stock listed in the sheets.

To fully enable this workbook to be used on all the stocks in the stockmarket, code will need to be added that automatically fills tickers() with the stock tickers contained in the active sheet which is outside the scope of this project.

Refactoring the code resulted in the code running faster for 2018 stock data. Before: After:

2017 stock data also ran faster. Before: After:

Summary

Overall, refactoring code can result in code that is easier to read, easier to maintain, and runs faster. There is a risk that the updated code could produce outputs that are different from the current outputs.

The advantage of the original VBA script for this project is that it was less complicated and easier to understand. It also took longer to run than the refactored code and could not scale up to