Skip to content

Latest commit

 

History

History
9 lines (8 loc) · 656 Bytes

README.md

File metadata and controls

9 lines (8 loc) · 656 Bytes

Stock Analysis using VBA

Created a script that loops through all the stocks for one year and outputs the following information:

  • The ticker symbol
  • Yearly change from the opening price at the beginning of a given year to the closing price at the end of that year.
  • The percentage change from the 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 that will highlight positive change in green and negative change in red.

stockmarket