The VBA of Wall Street

Overview:

In this assignment you will use VBA scripting to analyze real stock market data.

Stock market analyst:

• Created a script that will loop through all the stocks for one year and output the following information:
  • The ticker symbol.
  • Yearly change from opening price at the beginning of a given year to the closing price at the end of that year.
  • The percent change from opening price at the beginning of a given year to the closing price at the end of that year.
  • The total stock volume of the stock.
• The conditional formatting highlights positive change in green and negative change in red.
• The result looks as follows.

CHALLENGES:

• The solution will also be able to return the stock with the "Greatest % increase", "Greatest % decrease" and "Greatest total volume". The solution will look as follows:

• Made the appropriate adjustments to the VBA script that will allow it to run on every worksheet, i.e., every year, just by running the VBA script once.

TECH ENVIRONEMNT USED:

Excel, Visual Basic, GitHub.