Stock Market VBA Challenge

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

• 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 (along with conditional formatting to highlight positive change in green and negative change in red)
• Total stock volume
• A table including the stocks with the greatest percent increase, greatest percent decrease, and greatest total volume