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.
📺 Follow Up Video (Part 2):
📑 Download Crypto template Google Sheets and app script here:
► Buy Me a Coffee? Your support is much appreciated!
——————————————————————————————-
☕ Paypal:
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we’ll both get a free stock:
► Support my channel so I can continue making free contents
—————————————————————————————————————
🌳 Becoming a Patreon supporter:
🛒 By shopping on Amazon →
📘 Facebook Page →
📘 More tutorial videos on my website →
✉️ Business Inquiring: YouTube@LearnDataAnalysis.org
#Sheets #GoogleSheets #Cryptocurrency #Crypto
Source link
I made a follow up video to address some of the limitations were brought to my attention 1) trigger didn't update the price, 2) how to pull the rest of information from CoinMarketCap currency page
Video Link: https://youtu.be/LC00b7TYVQc
Also, depending on your region settings, for U.S. the formula separator is a comma (,), but for some of the countries (European for example), the formula separator is a semi-colon (;).
Thanks for this tutorial, I will like to add the price of btc in realtime against other coins
Amazing a clear tutorial – thanks! How can I get I can get in another currency, such as AUD rather than USD?
Amazing dude, amazing explanation, amazing English, amazing tutorial = amazing video experience. Nailed it, officially subscribed
Wow thanks man!
how to convert pulled data into numbers? the importxml function import it as text
amazing tutorial – how do I change the price to a different currency like GBP?
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.
Best!
anyone else getting NA?
Awesome! Thank You!
Ugh error code every time I come back to this what am I doing wrong
Awesome !
Had to play with the replace functions and locales to clean the result and perfectly works ! Many thanks !
anyone know how I can get the value in £ instead of $. Brilliant video!
Wow. Fantastic stuff, thank you kindly
super helpful thanks bro!
This method quit working for me a few days ago. It has been working for months then suddenly stopped. Anyone else having issues?
Hi really good tutorial. I have a problem, this IMPORTXML was working till 3 or 4 days ago, now it's stopped. Any idea of what could have happened? Thanks!
Wow – so easy. Thanks!
//, we cannot parse this operator in this context
great video! But How can I add the market cap?
is there also the possibility to add the remaining criteria like: 24h%, marketcap, volume, circulatin supply etc.?? or is this formula only for `priceValue` available? anyway great video 👍
Great tutorial, thanks
Not working