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, duration hours minute second in high quality that is uploaded to the channel Dividendology 27 December 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 3,756 times and liked it 109 visitors.
