stock-analysis

Data analytics bootcamp module 2 challenge.

By the end of this lesson, you will be able to:

1. Define the building blocks of all programming languages: variables, arrays, conditionals, loops, and functions.
2. Create simple VBA macros to trigger pop-ups and change cell values.
3. Write VBA subroutines that use variables and conditionals.
4. Practice essential coding skills, including syntax recollection, pattern recognition, problem decomposition, and debugging.
5. Describe the basic syntax of a VBA for loop.
6. Direct logic flow by using for loops and conditionals.
7. List the benefits of using nested for loops.
8. Explain the basic process of using nested for loops.
9. Comprehend fundamental coding skills, including syntax recollection, pattern recognition, problem decomposition, and debugging.
10. Format spreadsheets with VBA code.
11. Loop through a table with VBA code and check for changes in values.

model 2 challenge

See 'worksheets' folder for the workbooks with the VBA scripts ran and the VBA script. See 'screenshots' folder for the screenshots of the results.