Cryptosheets provides a unique and globally unified crypto asset symbols & metadata catalog to make it easy for users to quickly find the proper symbol, name or syntax for any given asset or derivative instrument.
👉 Using the Cryptosheets Docs Portal
https://docs.cryptosheets.com/metadata
https://docs.cryptosheets.com/metadata/assets
https://docs.cryptosheets.com/metadata/exchanges
https://docs.cryptosheets.com/metadata/providers
👉 Using the =CS.SYMBOLS or =CSSYMBOLS custom function
NOTE: The SYMBOLS function is the only way to access the entire symbol instrument catalog for supported derivatives
https://docs.cryptosheets.com/functions/symbols
👉 Using the SYMBOLS function inside the UniConsole
The UniConsole is a game changer for quickly building, testing and fine tuning formulas including basic reference and lookup formulas
👉 Read the blog post on how to use CS.SYMBOLS
https://medium.com/cryptosheets/how-to-use-the-cryptosheets-cs-symbols-ee7b29398fbf
👉 Try the Crypto Symbol Data Finder Template
https://docs.cryptosheets.com/templates/crypto-symbol-data-finder-v-1/
IMPORTANT
👉 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 by simply adding the source
parameter like this:
Excel: =CS.PRICEA("base","UNI","quote","USD","source","coingecko")
Google Sheets: =CSPRICEA("base","UNI","quote","USD","source","coingecko")
👉 That means in addition to the 331+ default exchanges you can also get pricing data directly from other exchanges supported by for example CoinGecko which supports over 470+ total exchanges including popular defi, dex and other emerging exchanges/platforms
👉 You can easily find their symbol asset naming conventions by using either
The unified global SYMBOLS function and specifying the provider as the exchange
Excel:=CS.SYMBOLS("symbol","cat","exchange","coingecko","_limit","100")
Google Sheets:=CSSYMBOLS("symbol","cat","exchange","coingecko","_limit","100")
Use the QUERYA function for the given provider to call their native supported coins list endpoints
Excel:=CS.QUERYA("CoinGecko","Coins List")
Google Sheets:=CSQUERYA("CoinGecko","Coins List")
TAGS: #symbols, #assets, #exchanges, #supported symbols, #supported exchanges, #supported pairs, #messari, #coingecko, #cryptocompare, #gecko