Date: Dec 16, 2020 Version: 1 Copyright: n/a
== License =========================== Requires Microsoft Excel to run VBA script against Microsoft Excel file.
== Configuration Instructions ======== None.
== Installation Instructions ========== None.
== Operating Instructions ============= Open Excel Install Developer Add-On Developer Tab > Visual Basic Run button
== List of Files ==================== Multiple_year_stock_data.xlsx < not included but required to run VBA Module1_SVF_FINAL1.bas VBA Stock Results 2014.PNG VBA Stock Results 2015.PNG VBA Stock Results 2016.PNG
== Known Bugs ===================== None
== Troubleshooting =============== Resources used to build this code: https://trumpexcel.com/vba-loops https://www.mrexcel.com/board/threads/vba-change-number-of-decimal-places-of-a-percentage.521221/ https://www.automateexcel.com/vba/conditional-formatting/ https://stackoverflow.com/ https://docs.microsoft.com/en-us/office/vba/api/overview/excel URLs last used: December 16, 2020
== Contact Information =============== Boulder, Colorado United States
== Random Notes =============== This is my first official attempt at VBA. I chewed through a lot of bubblegum trying to figure this code out, and more importantly got the help from a lot of people. #ClassmatesRule Code is likely very messy and could be refined by an experienced VBA programmer. Please see rem/comments throughout the VBA file for additional notes or references.