VBA-challenge

Module 2 Challenge Assignment for Betul Akbas

Description

• This assignment includes creating a script that loops through all the stocks for 2018, 2019, and 2020.
• Provides outputs for the ticker symbols, yearly change from the opening price at the beginning of the given year to the closing price at the end of the year, the percentage change from the opening price at the beginning of the given year to the closing price at the end of the year, and the total stock volume.
• Color codes the Yearly Change and Percentage Change columns to see positive and negative changes.
• Provides a summary box noting the ticker symbol and value for the stock with the greatest increase percentage change, greatest decrease percentage change and the greatest total volume for each given year.

Support

Had many tutoring session, worked with friends, watched many VBA coding videos and studied accordingly.

Submission Includes

• ReadMe File
• Screenshot of the 2018 Results
• Screenshot of the 2019 Results
• Screenshot of the 2020 Results
• The VBA code saved directly from the VBA Editor in a .txt file