Import Cryptocurrency Price In Real Time In Google Sheets

Google Sheets has very limited support when it comes to pulling cryptocurrency live price. In this tutorial, I will share a workaround how you can use the IMPORTXML function to import cryptocurrency price in real time.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#Sheets #GoogleSheets #Cryptocurrency #Crypto

[MarcusKannberg]

@jiejenn Can you help me with a problem? I wrote the same formula but it says "Error
Imported Xml content can not be parsed." What can I do?

[Gozelis]

Hey thanks for info, code works fine, but it adds a column beyond with 24h volume numbers, although i did everything as you did, any suggestions how to get rid of it?

[timo]

Very easy to follow, straight to the Point. Great Tutorial helped a Lot in my spreadsheet

[qeebod]

Finally. I've found the real working tutorial on this. Subscribed! 🙂👍

[syedaffifahmed]

It's just amazing to learn crypto industry about rising and down 0:45 fall of this industry

[ukcryptogal]

Ok so I watched more of your videos, which are great BTW, and I had the same issue of the text to number value as everyone has commented, and so on one of your videos you issued a free spreadsheet which I got, and then copied the code from the extract just the number cell, changing the cell to my first bitcoin cell, which for me was B6, and as I am useless at excel, and even after reading 20 times, couldn't get the substitute thing to work to change the dollar column text to a number to multiply, I have just copied and pasted this and then created my column to multiply my holdings, by the current price as a number. So for everyone, here is what I pasted =SUBSTITUTE(SUBSTITUTE(B6, "$", ""), "%", "") hope that's ok to put here :) Please keep doing more videos, I'm really getting into this a lot now. Thank you.

[PeteBuchwald]

I got error too. Complete code at 3:24. thank you for your help with this! I'll watch the updated video.

[Kazerilo]

Hi, anyone know why the value is not refreshing for me? I changed the calculations settings to update every minute, but it is not recalculating.

[MLS.]

what if I need more details like:
Circulating supply
how many watchlist
marketcap
etc...

[hamsta]

Thanks, can I use a similar formula to get the 24hr % / 7 day % values from the website onto google sheets?

[Sean-xrxj]

Amazing a clear tutorial - thanks! How can I get I can get in another currency, such as AUD rather than USD?

[wiseman]

i'm using google sheet and i copied paste the formula exact like you but i got this msg:
Error Imported content is empty.

[hartikan]

Hello man.
Everything clear and great but I don't see any update that was mentioned in the video. It is not working

[feherzsombi]

Hi there. I`ve managed to to do it, but im getting some array results too below each listed price. How do I get rid of them?

[denyssamsonov]

If someone has issue like FORMULA PARSE ERROR, try to change separator to ; instead of,

[jordimargalef]

Can you help me to extract data token from alcor exchange for wax tokens. Please

[MATHIEUCHEVALIERweb]

Awesome !
Had to play with the replace functions and locales to clean the result and perfectly works ! Many thanks !

[EverythingWildNZ]

Hi - Sorry for the noob question - But the result is text, which I cant use in an equation. How do I convert it into a number?

[WoodyHertzogIII]

I have two numbers that display for me. The correct bitcoin price in your cell C5. But a second number populates below automatically in your cell D5. How can we fix that so the second number doesn't display automatically in D5?

[vistazopimp]

is there a way to log BTC price at a specific time in the day? (say 12am)