Thay Chansy Logo Image
Thay Chansy

Project 1

Module Challenge - VBA Multi Year Stock Data Script Challenge

Project Image

Project Overview

Create a script that loops through all the stocks for each quarter and outputs the following information: 1) The ticker symbol 2) Quarterly change from the opening price at the beginning of a given quarter to the closing price at the end of that quarter 3) The percentage change from the opening price at the beginning of a given quarter to the closing price at the end of that quarter 4) The total stock volume of the stock.

Tools Used

Excel
VBA Developer
Excel Macros
Advance Excel