π Introduction This project analyzes stock market data for six major stocks (AAPL, AMZN, NVDA, TSLA, GOOG, SPY) using Python and Power BI. It explores trends, volatility, and correlations.
π Technologies Used Python (Pandas, Matplotlib, Seaborn, yfinance, talib) Power BI (DAX, variety of visualizations ) GitHub Jupyter Notebook
π Dataset The data consists of historical stock closing prices and volume from Yahoo Finance for the last 5 years.
πPython βοΈ Data Cleaning & Preprocessing. βοΈ Calculation of Key Metrics (MA, RSI, Volatility, Bollinger Bands, Daily Returns). βοΈ Statistical Correlation Analysis. βοΈ Visualization of Key Trends.
π Power BI Reports βοΈ YoY Growth with Matrix and Ribbon Chart. βοΈ Cluster Column Chart for Volume comparison. βοΈ Cluster Bar Chart for Volatility comparison. βοΈ Correlation matrix with conditinal formatting. βοΈ Table with Peak Prices. βοΈ Slicers for time interactivity.
π Key Findings π Tesla had the highest volatility. π Amazon had the most oversold positions. π₯ NVDA stock increased 10X in 5 years! π SPY had the lowest volatility but was the best benchmark for comparison as an ETF of the S&P 500.
π Future Improvements π Automate data fetching with APIs π Add machine learning predictions π Expand analysis with more stocks π Risk Management Analysis
π Contact π§ Email: ilias.analytics@gmail.com π LinkedIn: https://www.linkedin.com/in/ilias-roufogalis-320025347/ π» GitHub: https://github.com/LiakosData
π I have adjusted the project's layout and style and the new version is at my Portfolio GitHub Page : https://liakosdata.github.io/Portfolio/