UCI Data Analytics Bootcamp | Module 2 Challenge
The stock_analysis.vba is a visual basic script that can be copied into any excel workbook to briefly analyze and summarize stock information. The script will loop through any number of worksheets within the workbook.
Column headers must be in the below order. Data should be sorted by ticker then by date from oldest to newest.
- Ticker
- Date
- Open
- High
- Low
- Close
- Volume