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

[@mmmfosters]

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

[@tariosultan]

Most welcome Timothy! Glad it worked for you.

[@jorwegs]

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

[@jamesnduka3913]

same issue for me

[@HadyAkiki]

same here

[@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

[@HadyAkiki]

same here

[@steffenclerc9118]

Hey, nice video! Is there a way to color daily price % in red or green after every update? Thanks :D

[@UTO0O0B]

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?

[@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

[@vipersnow]

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

[@vice7774]

use the function =split("cell whit the number in ; "$") it will delete the $ cause it's in text, normally now you only have number so you can calculate whit

[@tolgaybeytekin]

as a function for IMPORTXML you must parse a equal a sign in fron it. eg. =IMPORTXML. If this helps...

[@ensomining]

Exactly what I was looking for, thanks!!

[@tariosultan]

No problem!

[@PTR2K]

How often does google sheets pull the data across? Just curious if I have to manually refresh the data or not or if there is a refresh data button similar to excel

[@portable7789]

Unfortunalty, importXML not working ...

[@yowaway]

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

[@DougASAP]

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

[@bigmufff]

Awesome... the xpath method works like a charm

[@jjaybeardedbarber]

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.

[@PBz420]

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

[@tariosultan]

You're very welcome!

[@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???

[@vipersnow]

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

[@Dawggo]

Thanks the last one worked for me!

[@tariosultan]

You're welcome!

[@steveshuffle]

does it still work?

[@8brands]

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

[@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

[@steveshuffle]

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

[@LucioTorresZ]

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

[@vovaeh]

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..

[@Nothakarn]

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]

same here

[@mmmfosters]

Yup, unfortunately same problem here

[@mmmfosters]

… and now it’s back working! 🤔

[@banamailat_BM]

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

[@tariosultan]

Thanks for letting us know Bana!

[@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??

[@vishalpawar8.6.86]

Is there any option to grab from Trading View ?

[@rmo6404]

Great video, Thank you!

[@tariosultan]

You are welcome!

[@blastav]

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

[@tariosultan]

Most welcome! Glad you enjoyed it!

[@therethose]

Best Lesson too hard find video like this.

[@bmwe46zhp]

#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]

Most welcome! Glad it’s helpful!

[@UTO0O0B]

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

[@OlosLife]

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!!! 🙏🙏

[@tolgaybeytekin]

use the output cell for further calculations

[@dd981p1]

This was very usefull. Thanks a lot!

[@moeisthis1490]

this was extremely helpful, thank you

[@tariosultan]

You’re very welcome!

[@Joshua-kj2hc]

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

[@mister_maxwell]

Very good videos - thanx for this

[@brittanyw9107]

SO HELPFUL!

[@tariosultan]

Glad to hear that!

[@cryptony3298]

thank you for this video!🥰so good

[@tariosultan]

You’re welcome 😊

[@Atteraxy]

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.

[@ZakBoxer]

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

[@frapelloso]

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!

[@yogiesetia1]

Awesome🔥🔥, it work very well. Thankyou 👍

[@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 !

[@X_x_kingfisher_x_X]

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

[@MRbuchek100]

The best tutorial!

[@juanignaciox_]

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]

You’re very welcome Juan! Enjoy!

[@Gragento]

Do you know how to get the close price?

[@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

[@risteaalin]

Why didn’t you create a Google and already configure it so I can just change the APIs myself?

[@basement5k]

how to adjust how often it google sheets fetches the data

[@basement5k]

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

[@SteveJobs777]

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

[@dimasajisantoso200]

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

[@TheNJB]

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

[@WaqasRehmanSpeaks]

Very Helpful

[@666kgb666]

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

[@Kiwalabyetimothyshsh]

Works but my prices doesn’t update

[@souvikghosh5087]

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

[@dimasajisantoso200]

hi sir please share your google spreadsheet

[@HamzaKhan-vc3hm]

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

[@veli-pekkahiltunen8262]

same here

[@gonshugaming8624]

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

[@matiestrella510]

First method doesnt work with stablecoins

[@giovanniharry-qm9fq]

Excellent

[@nuovovideo]

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

[@Timanator]

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

[@mrkyn]

Thanks!

[@RJBrothers-lb2sd]

LIFE SAVER

[@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.

[@AdrianFlude]

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

[@teviafeng5078]

Not working for me

[@NestorBits]

Gracias

[@BenjaminCaudillo-x3g]

Hola y Gracia

[@HrvojePelin]

Unforunately not working anymore.

[@chaimasolli6318]

Coin tracking looks so old and full of bugs ;(

[@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]

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

[@CryptoPal-c7p]

@@OlosLife Hi, did you fix it? please share

[@husseinalrobaiay9761]

Only works with BTC and ETH did not work with LINK and other crypto