The VBA of Wall Street

Background

I used VBA scripting to analyze real stock market data.

Data

• Stock Data

Stock market analyst

Approach

• Created a scripts that looped 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.

• Used conditional formatting to highlight positive change in green and negative change in red.

• The result looked as follows.

• Returned the stock with the "Greatest % increase", "Greatest % decrease" and "Greatest total volume". The solution looked as follows: