Project Overview
For this project, VBA scripting was used to analyze generated stock market data. Created a script in VBA that loops through all the stocks for one year and outputs 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.
Used conditional formatting to highlight positive change in green and negative change in red.
Tools Used
Excel
VBA