Module 2 Challenge
Requirements
Retrieval of Data (20 points) The script loops through one year of stock data and reads/ stores all of the following values from each row: ticker symbol (5 points) volume of stock (5 points) open price (5 points) close price (5 points)
Column Creation (10 points) On the same worksheet as the raw data, or on a new worksheet all columns were correctly created for: ticker symbol (2.5 points) total stock volume (2.5 points) yearly change ($) (2.5 points) percent change (2.5 points)
Conditional Formatting (20 points) Conditional formatting is applied correctly and appropriately to the yearly change column (10 points) Conditional formatting is applied correctly and appropriately to the percent change column (10 points)
Calculated Values (15 points) All three of the following values are calculated correctly and displayed in the output: Greatest % Increase (5 points) Greatest % Decrease (5 points) Greatest Total Volume (5 points)
Looping Across Worksheet (20 points) The VBA script can run on all sheets successfully.
GitHub/GitLab Submission (15 points) All three of the following are uploaded to GitHub/GitLab: Screenshots of the results (5 points) Separate VBA script files (5 points) README file (5 points)
Sources
https://powerspreadsheets.com/excel-vba-cell-empty/ Used for the IsEmpty() function
https://www.excelmojo.com/vba-conditional-formatting/ Used for conditional formatting
https://support.microsoft.com/en-us/topic/macro-to-loop-through-all-worksheets-in-a-workbook-feef14e3-97cf-00e2-538b-5da40186e2b0 Used for looping through all the sheets