Import LIVE Crypto Prices in Google Sheets (3 Easy Ways)

2 years ago
11

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/markets/cryptocurrencies

#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.php?cur=HNT2","//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: https://youtu.be/YaP2jYnuL7g
How I use Google Sheets and Google Forms to track my finance: https://youtu.be/Xx5aP5MLuyk

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: https://youtu.be/9KHdAxozJbU
▸ My Crypto Playlist: https://bit.ly/3zqAFoP
============
Follow me on:
Instagram: https://www.instagram.com/tariosultan/
Facebook: https://www.facebook.com/tariosultan
My Website: https://tarioproductions.com/
============
📲 Business Inquiries:
Email: tario@tarioproductions.com
Instagram DM: https://www.instagram.com/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!

Loading comments...