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

Подписаться 25 тыс.

Просмотров 32 тыс.

50% 1

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/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: bit.ly/3sBg3ZA
#3. =INDEX(IMPORTXML())
Copy this to your google sheet:
=INDEX(IMPORTXML("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 ...
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.tariosultan.com/request
============
💎 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: tarioproductions.com/
============
📲 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!

Хобби

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 94

@mmmfosters 2 года назад

Really useful. I’ve updated my spreadsheet which was built using your previous video - so many thanks! 👏🏻

@tariosultan 2 года назад

Most welcome Timothy! Glad it worked for you.

@DougASAP 4 месяца назад

After a couple of years, still a great video! Thank you, I will be looking at you other stuff!

@ensomining 11 месяцев назад

Exactly what I was looking for, thanks!!

@tariosultan 10 месяцев назад

No problem!

@yogiesetia1 6 месяцев назад

Awesome🔥🔥, it work very well. Thankyou 👍

@juanignaciox_ 2 года назад

Incredible video. So easy and well explained. I can´t explain how much the video tags helped, since I didn´t want to use the Google Finance method, so skipping into the important part was easy. Thanks!

@tariosultan 2 года назад

You’re very welcome Juan! Enjoy!

@dd981p1 20 дней назад

This was very usefull. Thanks a lot!

@PBz420 Год назад

excellent Guide on how to integrate live data - thank you for putting this together.

@tariosultan Год назад

You're very welcome!

@blastav 2 года назад

Just awesome video! Really very helpful! Thank you for video!

@tariosultan 2 года назад

Most welcome! Glad you enjoyed it!

@moeisthis1490 2 года назад

this was extremely helpful, thank you

@tariosultan 2 года назад

You’re very welcome!

@MRbuchek100 6 месяцев назад

The best tutorial!

@cryptony3298 2 года назад

thank you for this video!🥰so good

@tariosultan 2 года назад

You’re welcome 😊

@rmo6404 Год назад

Great video, Thank you!

@tariosultan Год назад

You are welcome!

@mister_maxwell 5 месяцев назад

Very good videos - thanx for this

@brittanyw9107 Год назад

SO HELPFUL!

@tariosultan Год назад

Glad to hear that!

@georgejones6000 Год назад

Hi Tario, have just tried all 3 methods and none of the are working for me, have used AVAX as my test coin. Method 1: This works for AVAX, but not for BNB, DOGE, FTM or MINA to name a few. Method 2: "N/A. Error. Imported content is empty. Method 3: Give me a black cell and the error message "Error.Resource at url contents exceeded maximum size." Any help would be appreciated. Thanks, George

@WaqasRehmanSpeaks 2 месяца назад

Very Helpful

@giovanniharry-qm9fq Месяц назад

Excellent

@mrkyn 2 месяца назад

Thanks!

@8brands 7 месяцев назад

Very help thanks! Are they the same methods for importing Market Caps?

@OlosLife 11 месяцев назад

Hi. it's very useful. However the importXML function appears to result in the input being text so I’m unable to perform any calculations on it. For example multiplying the price by the number of coins I have. Is there any way round this? Please someone help me!!! 🙏🙏

@RJBrothers-lb2sd 6 месяцев назад

LIFE SAVER

@PBz420 Год назад

Have you done the video to show importing historical data as you mention at 9:25 of this video? Would really love to know this - thanks again

@jjaybeardedbarber 3 месяца назад

Thanks for the explanation but I am keep getting an error in the cell? I am doing it exactly how you are. Also, the copy and paste link in the bio doesn't work. Please help.

@portable7789 Год назад

Unfortunalty, importXML not working ...

@jorwegs 6 месяцев назад

When I try this the cell says " Error - Resource at url contents exceeded maximum size."

@jamesnduka3913 6 месяцев назад

same issue for me

@yowaway 11 месяцев назад

Is the price then updating live on the google sheet ? Cause it does not follow the live price for me. Thank you

@ZakBoxer 2 года назад

Method 1 worked perfectly!! Can we also pull in market caps for crypto?

@frapelloso 9 месяцев назад

great video, the only one that explain in an easy and undertandable way, expecially the first method! I've been looking for it for ages. Do you know by any chance how to fetch Gold price? I've been trying everything with the ticker but it can't find the right one, thanks!

@rosolo_ Год назад

Hello, Really really cool content! I use it, but when i receive the day variation in percent, the number is always positive, even when the price go down. have you a tips for that ? Thx !

@nuovovideo 5 месяцев назад

Very Useful, the best one, Thanks.......

@LucioTorresZ 6 месяцев назад

Hey man, this video is awesome. Could you show how to do it with market cap? Having trouble with that formula

@ViktorUnginovic Год назад

Great video. Very helpful. I have one question - How can we pull the price automatically/semi-automatic so that in code we don't have to type in each coin by hand? Just name the cell by the coin that we want and automatically shows in the code? Hope I hope the question is understandable. Tnx

@Joshua-kj2hc 3 месяца назад

Hai Tario, what an amazing video! its very helpfull!! btw i have question, how long it will be refresh the data? or what can we do for make it automatically refresh? Thanks

@NestorBits 4 месяца назад

Gracias

@steveshuffle Год назад

9:15 -> where is that video you talk about (creating daily snapshots?) :)

@vovaeh 6 месяцев назад

You did the best job ever bro!!! Thanks a lot. İ am tring to create a portofilo as i want but connot for a long time. Because i dont want to pay to exel, i dont want to learn numbers in mac. I tried CMC portfolio but there i cant see avarage buy price as i want. Also i tried to do things by api keys but exchange that i use does not supported, expect koinly. But koinly does not work properly...... so now i know the way..

@dimasajisantoso200 2 года назад

sir is importxml in spreadsheet not work all coin becouse range 1 coin in work

@Gragento Год назад

Do you know how to get the close price?

@joaobarbosa3807 Год назад

Hi. Great video, very useful. However the importXML function appears to result in the input being text so I’m unable to perform any calculations on it. For example multiplying the price by the number of coins I have. Is there any way round this?

@OlosLife 11 месяцев назад

Hi, did u fix it? i have the same problem!!

@666kgb666 2 года назад

I tried using method three and all was done as u did but all i get in the price box is #NAME? .... What am i do doing wrong please? i am using office 365 for mac

@TheNJB 4 месяца назад

After a few days the values start to say N/A. Anyways to fix this?

@SteveJobs777 2 года назад

can u show how to do it with p2p last orders?

@gazjacko1 Год назад

Late to the party, but thought i would try and ask anyway. 3rd method, I cant seem to get it to work for a lot for a lot of coins, it comes back with the error, "Resource at URL contents exceeded maximum size," I tried this with a few coins, BTC, XRP, ADA and I thought maybe it was because it was a 3 character ticker, but then I tried it with DOGE and it still says the same. Works fine for MATIC am i doing something silly???

@user-uh4kb5wp8b Год назад

same 3 doesn't work for me with the same error message

@Trippin_tales Год назад

if im trying to track something valued at less than 1 penny, how would i get sheets so reflect that. im trying to track clay, pavia and copi and all 3 are valued less than a penny, but sheets is rounding up to a whole cent.

@Wormman11 10 месяцев назад

You have to keep increasing the decimal point on google sheets

@bmwe46zhp 2 года назад

#3 was the most helpful for me. I did get all of the methods to work, but #3 was best for me. Any idea how to refresh the prices or did I miss that in the video. Thank you for the video!

@tariosultan 2 года назад

Most welcome! Glad it’s helpful!

@UTO0O0B 2 года назад

I’m having the same problem. Prices don’t appear to update with method 2 and 3. Any ideas?

@steveshuffle Год назад

does #3 still work for you? I can't get it work

@HamzaKhan-vc3hm 4 месяца назад

Resource at URL contents exceeded maximum size. 3rd method says this

@gonshugaming8624 Год назад

bang itu formatnya text ya gua ubah ke angka atau currency tetep ga bisa, gimana solusinya bang ?

@maineventbone Год назад

Hey I would love to learn how to do the snapshotting of each price of each coin can you please make that video?

@tariosultan Год назад

Will do! Stay tuned!

@steveshuffle Год назад

@@tariosultan has this amazing video arrived by any chance??

@Nothakarn 2 года назад

Thanks for the great video. My IMPORTXML were working fine but from yesterday, it looks like all my IMPORTXML are not working anymore in my Google Sheets, even if I try to make simple one from Wikipedia. Would you know what can be the issue and how to fix it please? :)

@David-zu1ij 2 года назад

same here

@mmmfosters 2 года назад

Yup, unfortunately same problem here

@mmmfosters 2 года назад

… and now it’s back working! 🤔

@banamailat_BM 2 года назад

This looks to be a recent error on Google's end. And I think The google developers are working to resolve this currently.

@tariosultan 2 года назад

Thanks for letting us know Bana!

@Kiwalabyetimothyshsh Год назад

Works but my prices doesn’t update

@dimasajisantoso200 2 года назад

hi sir please share your google spreadsheet

@Timanator 5 месяцев назад

It is very buggy, high lows and volume do not always work with google finance.

@souvikghosh5087 4 месяца назад

IT IS NOT WORKING FOR OTHER COINS LIKE TRON, ANKR, FILE.

@basement5k-mw4fg 3 месяца назад

how to adjust how often it google sheets fetches the data

@basement5k-mw4fg 3 месяца назад

i got it to work using the 2nd method but the ive refreshed it a few times and the price hasnt changed in google sheets

@matiestrella510 6 месяцев назад

First method doesnt work with stablecoins

@AdrianFlude 3 месяца назад

Decent video in principle, but @Tario it needs an update. Thanks.

@nebojsa1976 Год назад

Here is the million dollar question. This is function from one of my cells: =if(ISNUMBER(B10), INDEX(B:B,10,1)) . It will return number and that works. But if text shows up in the same cell, it will show FALSE. Or if I put in formula " ", it will show nothing. Is it possible somehow that it doesn't return FALSE. If the statement is FALSE, just don't change anything, just exit, without changing contents of cell. I have one cell that sometimes shows text and sometimes numbers. I'd like it that it keeps the number, but if text shows up, it doesn't change anything (IT LEAVES THE PREVIOUS NUMBERS, IT DOESN'T CHANGE THE CONTENT OF CELL IN ANY WAY SHAPE OR FORM). I use importHTML in another cell, but sometimes it gives the correct price and sometimes it just says Exchange (text), and that's why it gives me FALSE result, which is not good. I need it for number to stay inside cell. If it is FALSE, ok, no problem, but just don't overwrite the number inside the cell, just exit.

@teviafeng5078 7 месяцев назад

Not working for me

@X_x_kingfisher_x_X 2 месяца назад

Bro how to impost historical price, like yesterday or last week?

@UTO0O0B 2 года назад

@eddievanrojas Год назад

I was wondering the same. Can not multiply with the data that is being generated.

@yassine.h3262 Год назад

you have to define each column as a string, then you should remake the data into a dataframe or as a xts (timeseries), and then you can perform statistical analysis you want

@user-uh4kb5wp8b Год назад

You can transform the data with =Value(Your data). Like this you can make calculation on it