Skip to content

alaa-aleryani/Stock_Analysis

Repository files navigation

VBA Challenge

In this challenge, we used VBA scripts effeciently to analyze the yearly stock data.

First, we printed each different tickor symbols just once. Then for each tickor we added the volumes for all corresponding tickors and printed the total. We calculated the yearly change and percent change for each different tickor. Finally, we looked for the greatest percent Increase and decrease as well as the greatest total volume.
Provided 3 screenshots, one for each year of the results and a vbs file which contains the code to run the calculations.

Releases

No releases published

Packages

No packages published