sayaliwalke30 / Stocks-Analysis-and-Prediction Public

Notifications You must be signed in to change notification settings
Fork 1
Star 4

Web scrapped the stocks fundamentals for 502 stocks and carried out data analysis using SQL and POWER BI. Built a very useful visualization for Value Investing. Selected 5 stocks and predicted their price.

4 stars 1 fork Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 53 Commits
BerkshirePricePrediction.ipynb		BerkshirePricePrediction.ipynb
FinalPresentation.pdf		FinalPresentation.pdf
GooglePricePrediction (1).ipynb		GooglePricePrediction (1).ipynb
JohnsonPricePrediction.ipynb		JohnsonPricePrediction.ipynb
NetflixPricePrediction.ipynb		NetflixPricePrediction.ipynb
ProjectReport1.pbix		ProjectReport1.pbix
SalesforcePrediction.ipynb		SalesforcePrediction.ipynb
Stocks_Fundamentals.csv		Stocks_Fundamentals.csv
WebscrapingStocksData.ipynb		WebscrapingStocksData.ipynb
readme.md		readme.md

Repository files navigation

Financial Analysis of Stocks and Price Prediction

Problem Statement:

Stocks analysis using financial statistics web scraped from Market watch for 500 stocks and price prediction using 4 different machine learning algorithms.

/**

author Sayali Walke

**/

Steps:

1. Web scrapped using python around 25 stocks fundamentals for each of 502 stocks using python.

2. Carried out in depth data analysis on web scrapped data.

3. Selected 5 Stocks that are suitable for investing using SQl

4. Created an innovative interactive dashboard using POWER BI which can be used by anyone for value investing

5. Link for power BI report- shorturl.at/drCNV

6. Developed a machine learning model to Predict prices for all the five stocks after 1 year. I have tried different types of algorithms for predicting stocks inclusing Moving Average, Linear Regression, ARIMA, k-nn and Prophet. However I got best results with Prophet.

7. Created Hedge fund with 5 stocks and 3 different combination.

8. Calculated Return on Equity for every combination.

About

Web scrapped the stocks fundamentals for 502 stocks and carried out data analysis using SQL and POWER BI. Built a very useful visualization for Value Investing. Selected 5 stocks and predicted their price.

python machine-learning sql data-analysis stocks financial-analysis powerbi price-prediction prophet-model stocks-fundamentals

Report repository

Releases

No releases published

Packages

No packages published

Languages

Jupyter Notebook 100.0%