Skip to content

Latest commit

 

History

History
11 lines (11 loc) · 501 Bytes

README.md

File metadata and controls

11 lines (11 loc) · 501 Bytes

VBA and the Stock Market


The code analyzes appx 22 million rows of data to retrieve and calculate data points.
* Retrieval and calculation is accomplished with five procedures utilizing functions, e.g., AdvancedFilter and XLookup.
* A sixth procedure loops each worksheet through the previous five procedures.
* A user form was created to prompt the user to begin calculations. When calculations have finished after 30-40 seconds it disappears.