How to build a Cryptocurrency Price Index [with Python using SQL,APIs and Streamlit]

Hi everyone,
in this one we are going to build a cryptocurrency price index similar to the S&P500/Dow Jones/Sensex/DAX whatever you are for stocks. Those indices are usually calculated using value weighted returns. Anyhow we are using equal weighted returns.
There are basically endless possibilities with that but this video should give you an idea how to start. Figuring out the altair part took me multiple hours so please hit the like button to make it worth it :D

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

Please check out the mentioned videos beforehand to better follow along:
Video on a live price data stream using binance unicorn and streamlit:

Please also check the linked streamlit videos below that.

Videos on requesting data from cryptoexchange APIs:

Video on how returns are calculated:

If you are interested in more Python and Crypto related content please check out my cryptobot playlist:

Get Market caps credits to javierfish on stackoverflow:

symbols = ['btc', 'eth', 'bnb', 'xrp', 'ada','sol','dot','luna','AVAX','doge','shib','matic',
'ltc','atom','link','near','trx','algo','bch','ftt','xlm','ftm','uni','mana','hbar','sand',
'etc','axs','icp','vet','xtz','fil','egld','theta','xmr','klay','hnt','grt','gala','one','eos',
'flow','aave','cake','mkr','qnt','enj','ar','tfuel','xec','stx','neo','ksm','zec','amp','rune',
'cvx','bat','celo','lrc','crv','rose','chz','dash','waves','scrt','slp','snx','mina']

00:00 - 02:10 Intro / Prerequisites / Explanations
02:10 - 05:18 First script pushing live prices to a SQL DB
05:18 - 08:32 Get Market Caps using the Coingecko API
08:32 - 16:20 Step by step Index calculation
16:20 - 19:22 Repeating all Index calculation steps within a function
19:22 - 24:42 Creating the streamlit script
24:42 - 25:34 Run the app / Thx for watching

#Python #Crypto #Index

[AlexDBall]

I'm a simple man.. Algovibes uploads? I like the video and THEN watch it!

[rajeevmenon]

All your videos are really engrossing. Thanks for these high quality content videos. Please keep the videos coming frequently

[HimanshuSharma-bzgh]

Like first, watch later. Awesome as always.

[danielfenech]

Thanks man. Very informative. Enhancing my python skills and using real world examples with crypto makes alot of sense!

[KeyvanTajbakhsh]

Your video is very handy for algo trading thank you very much !

[cesarstevendiazchoque]

Thanks for everything man, i wonder if you have some video explaning how to read the orderbook from binance or any exchange

[mikul_]

Hi! Could you perhaps look into how to pull data from the fear and greed index and make a candle chart on that information. That would be really cool an educational to see how to pull information like that and put it into a real candle chart..

[darshanpatil]

Thanks for such wonderful videos, its really very helping.
Requesting you to please consider some more crypto indicators/Strategy vidoes (except the one which we have already covered MACD, RSI Stoch, MA, EMA, SMA etc..)

[rashaadalli]

hello.. great channel. please show how to do two EMA on 1min data. first one is 10 period, the second one is 50 period but using 4H data. then plot both on 1min chart.

[thompsomimports]

Hum guys, is there any model of prediction where a I could check results? Like week by week checking If my predections were right or wrong for instance

[anshmiester]

Hi Algo vibes, I wanted to benchmark my Portfolio with the Index. How should I go about calculating my Buy's and sell and adjusting the Net asset value of the portfolio and compare with how the index has performed and Plot the Index and Portfolio's performance on the Chart. Thanks for another informative video.

[sergecornushov]

Is any way to enable Binance client data cache?

[sergecornushov]

How to overlay Bitcoin price? I'd like to see 2 lines on a chart: index and BTCUSDT close price.

[dallibabs]

sorry for so many questions, your code seems sound however I keep getting

Traceback (most recent call last):
File "c:\Users\dalli\Documents\alertocoin\johnmodified.py", line 35, in <module>
SQLimport(data)
File "c:\Users\dalli\Documents\alertocoin\johnmodified.py", line 24, in SQLimport
klines = data['kline']
TypeError: string indices must be integers

[bigqclasses]

Sir can you make a video about trading bot with ma 5 & ma 20 croos over strategy in binance api

[erfandadashi]

Hi.good job..can you code a bot to trade on kucoin futures?

[kicc]

It will be nice to plot an index with some WMA's, let say the 200, the 20 and the 100, and and at least a lower indicator. No SQL.

[sergecornushov]

How to make this index weighted based on volume?

[artura]

Question: why you don't put your code somewhere ? It can be retyped from screen anyway (which I am doing actually), but it is a waste of time. The code is very good I really like your vids.

[neoaes]

Dow is a price weighted index not value weighted