Build an Interactive Finance Dashboard with Python & Streamlit to compare Fundamentals of Stocks

In this video we are creating an interactive Finance Dashboard showing the fundamentals of stocks in a certain peer group based on their sector. We are checking the Dow Jones Industrial Average for e.g. Price Earnings ratios or dividend yield but as said this is extendable based on your requirements.

This whole implementation is in Python using the streamlit library.

If you found this video interesting or helpful please consider subscribing. Thank you very much in advance!

Get the Notebook/Source code by becoming a Tier-2 Channel member:

To make this Dashboard even better you should update the Database regularly. I have resources on how to do that on my channel as well.

In the beginning I stated IBM pays the highest dividend and Apple pays the lowest dividend. This statement has to be understood in a relative context. I am referring to the yield and not the absolute amount.

Video on streamlit:

Video on fundamental analysis of stocks with Python:

Video on Python and SQL:

Link to wikipedia table:

Disclaimer: This video is not an investment advice and is for educational and/or entertainment purposes only!

0:00 - 01:24 How the Dashboard is working and prerequisites
01:24 - 08:02 Getting fundamentals and store them in a SQL DataBase
08:02 - 12:36 Creating the Streamlit Dashboard

#Python #Streamlit #Fundamentals

[lovejournal]

Great video! Thank you very much for sharing. Can't wait to see more.

[atangbingana]

Just completed this with Jupiter labs look like you have to reinstall old version of sqlalchemy for code to work and use concat. Thanks for the video @Algo appreciate you bro.

[SF-jfuv]

Hi Algovibes, I really like your video and I already re programmed alot of them but in this video is receive the following error when i want to run streamlit. "streamlit Segmentation fault: 11" Do you know how to fix it? Many thanks in advance.

[itsmegayatri]

Do video on notification send to the user to buy or sell the stock by using the yahoo finance

[chapmansbg]

sorry about asking this question a second time but there was no answer the first time. Why do you use an SQL DB instead of a csv file? Okay answered my own question, SQL allows for selecting information before loading it to a variable whereas CSV requires loading all of the information prior to selecting rows that you are interested in.

[denizhan]

Can I get codes? I will try for binance.

[kendrickperkins]

i keep having operating issues and my database isnt connect. I think it is due to it not storing. Can anyone please help

[MarcoPolo-mlpm]

Hey top Videos ! Könntest du eventuell ein Video machen in dem du erklärst wie man die GUV, die Bilanzen und cashflow Rechnungen mehrerer Jahre in Python kriegt und dort analysieren kann? Ich würde zB gerne den RAROE ausrechnen bzw ausrechnen lassen.

[kicc]

On your loop for ticker in tickers, I get the warning as to use, pandas.concat instead of df = df.append(frame). I am assuming it should be as df.pandas.concat(frame) then? Not sure. It will be deprecated in future pandas versions. Thanks.