This repository contains my homework for Module 2.
Attached to this repository, you will find:
- All Macros.bas: this file contains all code written in VBA for this homework;
- Sub Loop Through All Years.doc: this file contains the VBA code written to allow the macro to loop through all the years and do the analysis;
- Sub Loop Through Stock One Year: this file contains the VBA code written to run through all the stocks for a given year and return for each Ticker the requested parameters;
- Sub Retrieve Largest Change.doc: this file contains the VBA code written to run through the outcome of a given year and retrieve the greatest Percent Change, greatest Percent Decrease and greatest Total Volume.
Unfortunately given size restrictions, I could not upload the total solution in xlsm format. However, if needed, you can retrieve the file from Google Drive using the below link.
https://drive.google.com/drive/folders/1saXRtoGbvslhBrJyz455mCaBZvK6e6GQ?usp=sharing
Please see below a screenshot containing the results for task 1
Please see below a screenshot containing the results for task2
