Рет қаралды 32,787
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: www.google.com...
#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: bit.ly/3sBg3ZA
#3. =INDEX(IMPORTXML())
Copy this to your google sheet:
=INDEX(IMPORTXML("cointracking.i...","//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 ...
How I use Google Sheets and Google Forms to track my finance: • How to Track Expenses ...
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: tariosultan.com/
👉🏻 Subscribe: bit.ly/38ZZpXf
☕️ Buy me a cup of coffee: bit.ly/2SQFwMs
✏️ Request content for my channel: link.tariosult...
============
💎 All my gear: bit.ly/3aYGgFB
📚 Books that changed my life: bit.ly/2uJo2bM
🛡 Protected yourself online with NordVPN (72% OFF): bit.ly/3iETA9v
============
▸ My fav camera: bit.ly/39hM7aS
▸ My fav lens: bit.ly/3crrURV
▸ One of my best storytelling videos: • Can Lumix G85 Handle W...
▸ My Crypto Playlist: bit.ly/3zqAFoP
============
Follow me on:
Instagram: / tariosultan
Facebook: / tariosultan
My Website: tarioproductio...
============
📲 Business Inquiries:
Email: tario@tarioproductions.com
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!