Build a Crypto Watchlist with Live Crypto Prices in Google Sheets! (Live Crypto Data!)
Link to download my portfolio tracking spreadsheets:
/ dividendology
In this video, I take you step by step on how to create a cryptocurrency tracker in google sheets. This tracker will automatically track live crypto data, and also give you buy/sell signals based on your target buy and target sell price. This is a very useful tool, feel free to pause or rewind the video where needed as I move fast!
Formulas:
Live crypto prices:
=(index(importhtml(concat("https://coinmarketcap.com/currencies/",A2),"table",1),1,2))
24 Hour Change:
=(index(importhtml(concat("https://coinmarketcap.com/currencies/",A2),"table",1),2,2))
Market Rank:
=(index(importhtml(concat("https://coinmarketcap.com/currencies/",A2),"table",1),7,2))
24 Hour High/Low:
=(index(importhtml(concat("https://coinmarketcap.com/currencies/",A2),"table",1),3,2))
Trading Volume:
=(index(importhtml(concat("https://coinmarketcap.com/currencies/",A2),"table",1),4,2))
Thanks so much for watching the video, and please don't forget to like and subscribe to the channel!
Get $10 of bitcoin for free when you sign up for coinbase at my affiliate link: https://www.coinbase.com/join/breece_ie
I am not a Financial advisor or licensed professional. Nothing I say or produce on YouTube, or anywhere else, should be considered as advice. All content is for educational purposes only. I am not responsible for any financial losses or gains. Invest and trade at your own risk.
