Skip to content

danawoodruff/Excel-VBA

Repository files navigation

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.

About

VBA analysis of a 22M record dataset.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages