Skip to content

Latest commit

 

History

History
22 lines (13 loc) · 943 Bytes

README.md

File metadata and controls

22 lines (13 loc) · 943 Bytes

VBA-challenge -The VBA of Wall Street

VBA-Challenge to make a Stock Market Analysis.

Background

This project is a VBA script to analyze real stock market data.This analysis used two data-points one is the Test Data which is used while developing the script, and the other is Stock Data which is the main data to run the script. The data is sourced into Excel Microsoft Office, the test data have 7 sheets(A-P) the size of this file is smaller and used for testing. The stock data or the main data has three sheets categorized yearly 2014, 2015, 2016. This file is bigger in size, it may take time when you execute the script into the file.

Image Output

2016:

My cool logo

2015:

My cool logo

2014:

My cool logo

VBA Script/Macro

https://github.com/akarpie96/VBA-challenge-/blob/main/StockData_Script.vbs