Hey everyone, I’m having trouble getting Bitcoin prices in my Google Sheets. I’m using the GoogleFinance function like this:
=GoogleFinance("CURRENCY:BTC")
But it’s not working. I keep getting an error that says the query returned no data. What’s weird is that I can see the BTC prices on the Google Finance website when I search for CURRENCY:BTC.
Does anyone know why this is happening or how to fix it? Is there another way to pull Bitcoin prices into Google Sheets? I’d really appreciate any help or suggestions. Thanks!
I’ve been wrestling with this problem too, and I found a workaround that’s been pretty reliable. Instead of relying on GoogleFinance, I created a custom function using Google Apps Script to fetch Bitcoin prices from a crypto API. I went to Tools > Script editor, pasted a function that leverages UrlFetchApp to get the data, and then used that function directly in my sheet. It requires a bit of coding, but this method provides greater control over the data source and refresh rate. If scripting isn’t your thing, the CRYPTOFINANCE add-on is also a fine alternative.
hey mate, i feel ya. GoogleFinance can be a pain sometimes. have you tried using the CRYPTOFINANCE add-on? its pretty solid for grabbing crypto prices. just install it from the google workspace marketplace and use =CRYPTOFINANCE(“BTC”) in your sheet. works like a charm for me!
I’ve encountered this issue before. Unfortunately, GoogleFinance doesn’t support cryptocurrency data directly. For Bitcoin prices, you’ll need to use an alternative method. One approach is to use the IMPORTDATA function with a reliable cryptocurrency API. For example, you could try:
=IMPORTDATA(“https://api.coindesk.com/v1/bpi/currentprice/BTC.json”)
This pulls data from CoinDesk’s API. You’ll then need to parse the JSON response to extract the price. It’s a bit more complex than GoogleFinance, but it’s reliable. Just be mindful of API rate limits. If you need help parsing the data, let me know, and I can provide more details on that step.