Skip to content

cmartell5/stock-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 

Repository files navigation

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

About

Using VBA, analyzing one year of stock data

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published