Question: create a VBA script that loops through all the stocks for each quarter and outputs the following information: The ticker symbol Quarterly change from the

create a VBA script that loops through all the stocks for each quarter and outputs the following information:
The ticker symbol
Quarterly change from the opening price at the beginning of a given quarter to the closing price at the end of that quarter.
The percentage change from the opening price at the beginning of a given quarter to the closing price at the end of that quarter.
The total stock volume of the stock.
Add functionality to your script to return the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume".
Make the appropriate adjustments to your VBA script to enable it to run on every worksheet (that is, every quarter) at once
Make sure to use conditional formatting that will highlight positive change in green and negative change in red
Conditional formatting is applied correctly and appropriately to the quarterly change column
Conditional formatting is applied correctly and appropriately to the percent change column

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!