Metadata

Use these helper reference pages to see what different types of Metadata the Cryptosheets platform supports

UPDATE

You can now specify your default pricing source using the PRICEA custom function with support for CoinGecko, CryptoCompare & Messari in addition to the 331+ exchanges or default global VWAP pricing

You can also use the dedicated utility and reference custom functions to pull in all available assets, symbols, exchanges, providers and endpoints using simple formulas.

Assets & Symbols

Excel: =CS.SYMBOLS("exchange","coinbase")

Googlesheets: =CSSYMBOLS("exchange","coinbase")

All supported assets & exchanges from CoinGecko, CryptoCompare & Messari can be found by using their respective names as the exchange name

Excel: =CS.SYMBOLS("exchange","coingecko")

Googlesheets: =CSSYMBOLS("exchange","cryptocompare")

Exchanges

Excel: =CS.EXCHANGES(,{"_limit","350"})

Googlesheets: =CSEXCHANGES(,{"_limit","350"})

Providers

Excel: =CS.PROVIDERS("~",{"_limit","350"})

Googlesheets: =CSPROVIDERS("~",{"_limit","350"})

Because there are hundreds or thousands of results for these resources you will need to adjust the limit using global parameter arguments above the default limit of 10.

Examples:

  • Excel =CS.EXCHANGES(,{"_limit","350"})
  • Googlesheets =CSEXCHANGES(,{"_limit","350"})