Skip to content

Latest commit

 

History

History
32 lines (19 loc) · 1.34 KB

README.md

File metadata and controls

32 lines (19 loc) · 1.34 KB
Raw

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.