SheetLink
Search…
CoinMarketCap
Showcasing the crypto revolution to +270M monthly visitors!
Review the official CoinMarketCap Documentation πŸ“–
Note that "options" are optional, other variables are required πŸ‘
Formula
=CoinMarketCap( "options")
Interact with the CoinMarketCap API using only the SheetLink "options"​
=CoinMarketCap_QuotesLatest( "options")
Returns the latest market quote for 1 or more cryptocurrencies.
=CoinMarketCap_QuotesLatestQuerySymbol( "symbol", "options")
Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency symbol such as "BTC".
=CoinMarketCap_QuotesLatestQuerySlug( "slug", "options")
Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency slug such as "bitcoin".
=CoinMarketCap_QuotesLatestQueryId( "id", "options")
Returns the latest market quote for 1 or more cryptocurrencies by querying a CoinMarketCap id such as "1".
=CoinMarketCap_MarketPairsLatest( "options")
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency.
=CoinMarketCap_MarketPairsLatestQuerySymbol( "symbol", "options")
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency symbol.
=CoinMarketCap_MarketPairsLatestQuerySlug( "slug", "options")
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency slug.
=CoinMarketCap_MarketPairsLatestQueryId( "id", "options")
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency id.
=CoinMarketCap_Airdrops( "options")
Returns a list of past, present, or future airdrops which have run on CoinMarketCap.
=CoinMarketCap_Airdrop( "id", "options")
Returns information about a single airdrop available on CoinMarketCap. Includes the cryptocurrency metadata.
=CoinMarketCap_TrendingGainersLosers( "options")
Returns a paginated list of all trending cryptocurrencies, determined and sorted by the largest price gains or losses.
Missing a formula? Suggest one here πŸ’‘

Navigation

Page
πŸš€ Quick Start​
60 second getting started guide.
​❓ FAQ​
Answers to frequently asked SheetLink questions.
πŸ› οΈ Functions​
Powerful functions unique to SheetLink.
πŸ’ͺ "options"​
Control the request to and response from any application.

πŸš‘ Need Help?

You can always contact us via [email protected] or by messaging us on Twitter @SheetLink​
Last modified 22d ago