Skip to content

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.

Notifications You must be signed in to change notification settings

sayaliwalke30/Stocks-Analysis-and-Prediction

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.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published