Use VBA scripting to analyze real stock market data. Depending on your comfort level with VBA, choose your assignment from Easy, Moderate, or Hard below.
-
Create a script that will loop through one year of stock data for each run and return the total volume each stock had over that year.
-
You will also need to display the ticker symbol to coincide with the total stock volume.
-
Your result should look as follows (note: all solution images are for 2015 data).
-
Create a script that will loop through all the stocks for one year for each run and take 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 result should look as follows.
-
Your solution will include everything from the moderate challenge.
-
Your solution will also be able to return the stock with the "Greatest % increase", "Greatest % Decrease" and "Greatest total volume".
-
Solution will look as follows.
