Stock Market Data Analysis (VBA)

Portfolio Summary: VBA Stock Market Analysis

Background:

● Utilized VBA scripting to analyze stock market data, showcasing programming skills and automation capabilities.
● Demonstrated proficiency in creating VBA scripts for financial analysis.

Project Setup:
● Established a new repository named VBA-challenge for the project.
● Organized the repository with VBA files as main scripts for each analysis.
● Ensured proper version control and repository management.

Analysis Script:
● Developed a VBA script to loop through stock data for one year, providing the following information for each stock:
- Ticker symbol
- Yearly change from opening price to closing price
- Percentage change from opening price to closing price
- Total stock volume

Additional Functionality:
● Enhanced the script to identify and return the stock with the "Greatest % increase," "Greatest % decrease," and "Greatest total volume."
● Implemented conditional formatting to highlight positive change in green and negative change in red.

Advanced Solution:
● Modified the VBA script to enable running on every worksheet (every year) simultaneously.
● Ensured scalability and efficiency in handling multiple worksheets for comprehensive stock analysis.

Note*: Applied VBA scripting skills to automate stock market analysis, providing a versatile solution that can be applied to different datasets and scenarios. Successfully incorporated additional functionalities and advanced features for a comprehensive financial assessment.