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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
