In this activity, it was requested to create a script that loops through all the spreadsheet tabs and outputs the following information:

• The ticker symbol.

• The 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.

• The Greatest % increase, the Greatest % decrease, and the Greatest total volume.

• Conditional formatting, highlighting positive change in green and negative change in red for the Yearly Change and the Percent Change columns.

—