VBA-Challenge

The attached code was developped progressively from simple task of Ticker finding to full assignment. I Have created a Macro and copy pasted for each step as a building block. If you want to see the optimized version that works for multiple years and with a single loop please go directly to the last Sub in the submitted code : "YearlyPricingChangewithMaxMinVarMultiYearVersionSingleLoop()"