2

As well as Stocks, my portfolio in Sheets also contains Cryptocurrencies. Is there an updated list of cryptos supported using the GoogleFinance() function anywhere, or do I need to resort to trial and error?

maxhugen
  • 1,870
  • 4
  • 22
  • 44
  • https://www.reddit.com/r/googlesheets/wiki/featured/cryptocurrency-spreadsheet-utils – MattKing Nov 17 '21 at 13:55
  • Thanks Matt. I ended up getting spot prices from CoinGecko. Hopefully I'll be able to figure out the code to get historical prices from them eventually. – maxhugen Nov 18 '21 at 20:02
  • 1
    You might also want to check out the API from AlphaVantage.co – MattKing Nov 19 '21 at 16:37

2 Answers2

1

As of December, 2022, the IMPORTDATA function works with the cryptoprices.cc site, as described in this article:

https://www.spreadsheetclass.com/pulling-cryptocurrency-prices-into-google-sheets-2-methods/

This worked for me, where a previous solution I used (IMPORTXML) stopped working.

Hope this works for anyone who's been looking for a solution.

Vince Mongiardo
  • 49
  • 3
0

The list of cryptocurrencies which are currently available is the following:

  • Currency prices provided by Morningstar
  • BCH, BTC, ETH, LTC cryptocurrency prices provided by Coinbase, Inc.
  • Additional cryptocurrency prices provided by Morningstar

Reference

ale13
  • 5,679
  • 3
  • 10
  • 25