Skip to content

Latest commit

 

History

History
10 lines (10 loc) · 818 Bytes

README.md

File metadata and controls

10 lines (10 loc) · 818 Bytes

VBA-Challenge: Module2Challenge

Description: The VBA script sets out to loop throught the yearly worksheets in the file and produce: 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 ( w/conditional formating applied to showcase the positive (green) and negative chnages(red) The total stock volume of the stock. and the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume" Credits: Portions of the VBA code for calculating the stock analysis was adopted from [https://github.com/davidjaimes/yearly-stock-market-analysis/blob/master/README.md] by [David Jaimes]