Skip to content

Latest commit

 

History

History
18 lines (13 loc) · 524 Bytes

README.md

File metadata and controls

18 lines (13 loc) · 524 Bytes

VBA of Wallstreet

Background

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.

Tools Used

  • Excel
  • VBA