Does the add-on support cryptocurrencies?Last Updated: June 06, 2019
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:
If you would like the prices in a different currency, replace the USD above with the symbol for the currency of choice.
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