In this project, VBA scripting will be used to analyze real stock market data.
-
Test Data - This file was used while developing the VBA scripts. You can run the VBA scripts against this file to see the results faster than running through the larger Stock Data file.
-
Stock Data - Run VBA scripts on this data to generate the final report.
-
The VBA script 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.
-
Conditional formatting that will highlight positive change in green and negative change in red.
-
Return the stock with the "Greatest % increase", "Greatest % decrease" and "Greatest total volume". The solution will look as follows:
-
-
Use TickerProcessorAllWorksheets() to process the tickers on all the worksheets in the workbook.
-
Use TickerProcessor() to process the tickers on the current active worksheet.
-
Use ClearTickerSummary() to clear the summary tables on all of the worksheets in the workbook.
-
Uploaded to Github:
-
A screen shot for each year of your results on the Multi Year Stock Data.
-
VBA Scripts as separate file. TickerProcessor.vbs
-
README.md file.
-