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.
Watch video Build a Crypto Watchlist with Live Crypto Prices in Google Sheets! (Live Crypto Data!) online without registration, duration hours minute second in high quality. This video was added by user Dividendology 27 December 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,756 once and liked it 109 people.