Import LIVE Crypto Prices in Google Sheets (3 Easy Ways)
In this video, I'm going to show you how to import real-time cryptocurrency prices into your google sheet or crypto dashboard.
3 methods mentioned in the video:
#1. =GOOGLEFINANCE()
Works well if you want to import basic, popular crypto-token prices.
Supported Google Finance Crypto List: https://www.google.com/finance/market...
#2. =IMPORTXML()
Use this method if method 1 doesn't work or you can't find your token in google finance.
[Plugin] SelectorGadget - Chrome Web Store: https://bit.ly/3sBg3ZA
#3. =INDEX(IMPORTXML())
Copy this to your google sheet:
=INDEX(IMPORTXML("https://cointracking.info/coin_charts...","//td"),9,1)
Timestamps:
00:00 Intro
00:20 Previous Video
00:45 First Method
04:41 Second Method
06:55 Plugin for XPATH
09:40 Third Method
12:52 Final Thoughts
Other Google Sheets tutorials:
How to Build a Crypto Portfolio Tracker on Google Sheet: • How to Build a Crypto Portfolio Track...
How I use Google Sheets and Google Forms to track my finance: • How to Track Expenses in Google Sheet...
Drop a comment if you enjoyed this video!
============
NEW HERE? -
My name is Tario Sultan. You will see a mixture of tutorials, tech, crypto videos in this channel. That's who I am :)
📖 All My Courses: https://tariosultan.com/
👉🏻 Subscribe: http://bit.ly/38ZZpXf
☕️ Buy me a cup of coffee: https://bit.ly/2SQFwMs
✏️ Request content for my channel: https://link.tariosultan.com/request
============
💎 All my gear: https://bit.ly/3aYGgFB
📚 Books that changed my life: http://bit.ly/2uJo2bM
🛡 Protected yourself online with NordVPN (72% OFF): https://bit.ly/3iETA9v
============
▸ My fav camera: https://bit.ly/39hM7aS
▸ My fav lens: https://bit.ly/3crrURV
▸ One of my best storytelling videos: • Can Lumix G85 Handle Wedding Film? (G...
▸ My Crypto Playlist: https://bit.ly/3zqAFoP
============
Follow me on:
Instagram: / tariosultan
Facebook: / tariosultan
My Website: https://tarioproductions.com/
============
📲 Business Inquiries:
Email: [email protected]
Instagram DM: / tariosultan
============
Thanks for watching!
🙏🏻 Much love & stay blessed!
============
DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This helps to support the channel and allows us to continue to make videos like this. Thank you for the support!
Watch video Import LIVE Crypto Prices in Google Sheets (3 Easy Ways) online without registration, duration hours minute second in high quality. This video was added by user Tario Sultan 03 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 35,507 once and liked it 819 people.