Get BTC prices on Google Sheets from Google Finance

Question

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:BTC

with the same query strings.

How can I can fix this?

Ed Nelson · Accepted Answer · 2017-07-14T13:07:11.907

26

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))

edited Jul 14 '17 at 13:07

answered Jul 13 '17 at 13:27

Ed Nelson

10,015
2
27
29

This doesn't work with other parameters of the function (e.g. close prices, for 7 days ago). How can I do this? – Filipe Ferminiano Jul 14 '17 at 12:49
@Filipe Ferminiano See addition to answer. – Ed Nelson Jul 14 '17 at 13:08
9

This stopped working today. Getting parameter 1 value is invalid. – iankit Jul 09 '18 at 20:26
"date is a text and cannot be coerced to a number" – endolith Apr 05 '21 at 23:25
1

=GoogleFinance("CURRENCY:USDBTC") or =GoogleFinance("CURRENCY:BTCUSD") does NOT return correct value anymore! only =GoogleFinance("BTCUSD") does ! – mojmir.novak Aug 10 '21 at 20:48

score 14 · Answer 2 · answered Aug 15 '20 at 11:13

14

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 '20 at 11:13

Bioinformix

149
2
5

Where is the full list of currencies? Solana (SOLUSD) doesn't seem to work. – MXMLLN Apr 06 '22 at 15:19

score 2 · Answer 3 · answered May 04 '22 at 10:34

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.

score -2 · Answer 4 · answered Aug 31 '17 at 05:27

-2

Another way to work with crypto currency is to use the add-on where you can extract data from other sources.

=CRYPTOFINANCE("BTCUSD")

Link below:

https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14

answered Aug 31 '17 at 05:27

Tuan Vu

708
7
15

1

this is buggy , doesn't work quite well with historic dates, dev said it's working on – Lincoln Feb 20 '18 at 09:56
4

The permissions required to access this formula, look super sketchy. – iankit Jul 09 '18 at 20:27

Get BTC prices on Google Sheets from Google Finance

4 Answers4