Does the add-on support cryptocurrencies?

The Sheets Market Data add-on does support cryptocurrencies! 

All you have to do get cryptocurrency data into your spreadsheets is by adding the particular asset you want pricing information for as the symbol in one of our custom functions.

For example, if you wanted to find out what the price of Bitcoin was in USD, you would use the following function:

=STOCK_FUNDAMENTALS("BTC-USD", "regularMarketPrice")

If you would like the prices in a different currency, replace the USD above with the symbol for the currency of choice.

Note: Not every cryptocurrency is supported though many popular ones are. Also, most data points outside of prices will not return any information.

Below is a list of some of the most common cryptocurrencies and their symbols:

  • Bitcoin: BTC-USD
  • Ethereum: ETH-USD
  • Ripple: XRP-USD
  • Bitcoin Cash: BCH-USD
  • Litecoin: LTC-USD

Did this help answer your question?

thumbs up
thumbs down

Thanks for the feedback! 🙏🏽

Help by drift