Skip to content

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.

Notifications You must be signed in to change notification settings

LiakosData/Stocks_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

60 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Stock-Analysis

πŸ“Œ 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/

About

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.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published