This project uses Excel VBA to analyze real stock market data. Using a series of test data to develop the script, the final project runs through a full year's worth of stock data. Script output:

• Ticker symbol. Yearly change from opening price at the beginning of a given year to the closing price at the end of that year.
• Percent change from opening price at the beginning of a given year to the closing price at the end of that year.
• Total stock volume of the stock.

Conditional formatting highlights positive change in green and negative change in red.

---

This assignment is from the University of Denver's Data Analytics Boot Camp.

Copyright

Trilogy Education Services © 2020. All Rights Reserved.