Comment
Author: Admin | 2025-04-27
I'm trying to get data from Google Finance in Google Sheets with this formula:=GoogleFinance("CURRENCY:BTC")But I'm getting this error:GOOGLEFINANCE, the query for the symbol: 'CURRENCY:BTC' returned no data.Although on Google Finance itself, I can get BTC prices:https://www.google.com/finance?q=CURRENCY:BTCwith the same query strings.How can I can fix this? asked Jul 13, 2017 at 12:51 Filipe FerminianoFilipe Ferminiano8,80127 gold badges113 silver badges180 bronze badges You need to have a from and to currency like this:=GoogleFinance("CURRENCY:USDBTC")For historic close price use:=GoogleFinance("CURRENCY:USDBTC","close","07/07/2017")If you want only the price returned use:=iferror(index(GoogleFinance("CURRENCY:USDBTC","close","07/07/2017"),2,2)) answered Jul 13, 2017 at 13:27 5 As of 2020-08-15 the following formula works well (without any add-ons):=GOOGLEFINANCE("BTCUSD")Seems like it works only for BTC and ETH though. answered Aug 15, 2020 at 11:13 BioinformixBioinformix1682 silver badges6 bronze badges 1 2022-05-04, the following works on Google Sheets:=googlefinance("CURRENCY:USDBTC") as well as most combinations of currency and BTC (and ETH, LTC, BNB, XRP, XLM, and ADA), for example GBPBTC and JPYBTC.=googlefinance("CURRENCY:BTCUSD") works too, in the same combinations of coin and currency.Although finance.google.com has DOGE and LINK pricing, they don't seem to work the same way in the Sheet's googlefinance function. answered May 4, 2022 at 10:34 As of Feb 2025, the following works for Google Finance=GOOGLEFINANCE("Currency:BTC/USD")=GOOGLEFINANCE("Currency:ETH/USD") defcondefcon1337 bronze badges
Add Comment