For Challenge #2-VBA

This is the assignment submission for challenge #2- VBA. This script will run through excel file stock listings with a known/set format. The script will run through all the worksheets in open workbooks and extract the ticker name, showing closing vs. opening changes for each, as well as total trade volume. Lastly, it will list the best and worst performing tickers and the one with greatest trade volume.

Simply copy the VBA script into your excel file and then run it.

All three of the following are uploaded to GitHub/GitLab:

Screenshots of the results (20xx_screenshot.jpg) - 3 of these

Separate VBA script file

README file (this!)

Authors and Acknowledgement: Christopher Yang

I would like to thank the University of Toronto for putting together a robust program for Data Analytics, and my fellow classmates as well as the wonderful Instructors and LAs at the University of Toronto for their support.

License: This script is intended to be used for the purposes of assignment completion for a specific data analytics course. You may use this script freely if it fits your format. Please credit the author for the original work and do not plagiarize for the purposes of the assignment.