I’ve been trying to pull Bitcoin pricing information into my Google Sheets using the GOOGLEFINANCE function but keep running into issues.
Here’s what I’m using:
=GOOGLEFINANCE("CURRENCY:BTCUSD")
The error message I get is:
GOOGLEFINANCE has no data available for the symbol 'CURRENCY:BTCUSD'
What’s weird is that when I check Google Finance directly in my browser, I can see Bitcoin prices just fine using similar search terms. The data is definitely there on the website.
I’ve tried different variations of the symbol but nothing seems to work. Has anyone successfully imported cryptocurrency data into Google Sheets? What’s the correct syntax or is there some other method I should be using instead?
Unfortunately, GOOGLEFINANCE dropped crypto support, even though the symbols still show up in some docs. Hit the same wall last year building a portfolio tracker. The function used to work for crypto but Google quietly killed it. Your syntax is fine - the data source just isn’t there anymore. I switched to IMPORTXML with Yahoo Finance URLs to pull live crypto prices. Try something like =IMPORTXML("https://finance.yahoo.com/quote/BTC-USD", "//span[@data-symbol='BTC-USD'][@data-field='regularMarketPrice']") though you might need to tweak the xpath depending on how Yahoo’s structured their page.
Google killed crypto support for GOOGLEFINANCE months ago - barely announced it. Hit the same wall updating my trading sheet. CoinGecko’s API through IMPORTDATA saved me. Way more reliable than scraping Yahoo Finance (breaks every time they tweak their layout). Just build URLs like https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd and grab the JSON. More work than the old GOOGLEFINANCE trick, but you get tons more coins and historical data. Free API with decent limits, updates all day.
yeah, google finance stopped support for crypto a while ago. i switched to using coinbase’s api with this importjson script, and the data is way better now! hope that helps ya!