This assignment uses VBA scripting to analyze real stock market data. The instructions are as follows:
-
Create a script that will loop through all the stocks for one year and output the following information.
-
The ticker symbol.
-
Yearly change from opening price at the beginning of a given year to the closing price at the end of that year.
-
The percent change from opening price at the beginning of a given year to the closing price at the end of that year.
-
The total stock volume of the stock.
-
-
You should also have conditional formatting that will highlight positive change in green and negative change in red.
The VBA script including the bonus are saved in one VBScript. A screen shot for each year of the results on the Multi Year Stock Data are saved on a word document.