CoinMarketCap
Showcasing the crypto revolution to +270M monthly visitors!
Last updated
Was this helpful?
Showcasing the crypto revolution to +270M monthly visitors!
Last updated
Was this helpful?
Review the official 📖
Formula
Returns the latest market quote for 1 or more cryptocurrencies.
Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency symbol such as "BTC".
Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency slug such as "bitcoin".
Returns the latest market quote for 1 or more cryptocurrencies by querying a CoinMarketCap id such as "1".
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency.
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency symbol.
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency slug.
Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency id.
Returns a list of past, present, or future airdrops which have run on CoinMarketCap.
Returns information about a single airdrop available on CoinMarketCap. Includes the cryptocurrency metadata.
Returns a paginated list of all trending cryptocurrencies, determined and sorted by the largest price gains or losses.
Missing a formula? 💡
Page
60 second getting started guide.
Answers to frequently asked SheetLink questions.
Powerful functions unique to SheetLink.
Control the request to and response from any application.
=CoinMarketCap( )
Interact with the API using only the SheetLink
=CoinMarketCap_QuotesLatest( )
=CoinMarketCap_QuotesLatestQuerySymbol( "symbol", )
=CoinMarketCap_QuotesLatestQuerySlug( "slug", )
=CoinMarketCap_QuotesLatestQueryId( "id", )
=CoinMarketCap_MarketPairsLatest( )
=CoinMarketCap_MarketPairsLatestQuerySymbol( "symbol", )
=CoinMarketCap_MarketPairsLatestQuerySlug( "slug", )
=CoinMarketCap_MarketPairsLatestQueryId( "id", )
=CoinMarketCap_Airdrops( )
=CoinMarketCap_Airdrop( "id", )
=CoinMarketCap_TrendingGainersLosers( )
🚀
🛠️
💪
You can always contact us via support@sheet.link or by messaging us on Twitter