Skip to content

Excel & VBA project using Macros & stock market data across 6 worksheets.

Notifications You must be signed in to change notification settings

Phil-Mart/VBA-stock-market-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 

Repository files navigation

VBA-Stock Market Analysis

This project loaded market data Excel worksheets to determine:

  • Ticker symbol
  • Yearly change from opening price at the beginning of 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.
  • Added functionality to my script to return the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume".
  • Made the appropriate adjustments to the VBA script to enable it to run on every worksheet (that is, every year) at once.
  • Used conditional formatting that highlights positive change in green and negative change in red.

Results were screenshot in lieu of worksheet uploads. Screen Shot 2023-01-09 at 9 45 00 PM

Contact:

About

Excel & VBA project using Macros & stock market data across 6 worksheets.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published