17 нояб. 2021 г. · As of December, 2022, the IMPORTDATA function works with the cryptoprices.cc site, as described in this article:.

28 апр. 2021 г. · Answer. You can use the built-in funcion GOOGLEFINANCE. Examples. Bitcoin: =GOOGLEFINANCE("CURRENCY:BTCUSD") : $54,348.20 ...

13 июл. 2017 г. · 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).

14 авг. 2022 г. · I am trying to create a google sheet showing various crypto prices for a few set times (but lets just use BTC-USD for the moment).

2 сент. 2021 г. · If anyone is interested, I found an API that offers a free key, although limited in the number of daily calls you can make: CoinAPI.

8 февр. 2021 г. · This request will give you all the price of SNX coin in GBP (using Google Sheets native function to convert USD to GBP)

15 мар. 2022 г. · I created a crypto portfolio tracker with googlesheets to see it together with my stock portfolio.For stocks, googlesheets has a built-in formula to show the ...

2 янв. 2021 г. · On a google sheets cell I want to get only the current cryptocurrency price with this formula: =ValueCrypto(A1)

With Google Finance, I'm trying to calculate the 12-month moving average of a ticker. For example, I want to retrieve end-of-month closing price for a ticker ...

3 июн. 2024 г. · It is supposed to combine two GOOGLEFINANCE queries into one table (where S27 refers to a stock ticker, R27 refers to a date).