SheetLink
  • 👋Welcome
  • 🚀Quickstart
  • ❓FAQ
  • 🔒Security
  • Formulas
    • 🔗Apps
      • Webflow
      • HubSpot
      • OpenAI
      • Memberstack
      • Slack
      • Twitter
      • Gmail
      • Respond.io
      • Airtable
      • bit.io
      • MetaWeather
      • CoinMarketCap
      • Bannerbear
      • NFTPort
      • OpenSea
      • Stripe
      • Moralis
    • 🛠️Functions
    • 💪"options"
Powered by GitBook
On this page
  • Navigation
  • 🚑 Need Help?

Was this helpful?

  1. Formulas
  2. Apps

CoinMarketCap

Showcasing the crypto revolution to +270M monthly visitors!

PreviousMetaWeatherNextBannerbear

Last updated 3 years ago

Was this helpful?

Review the official 📖

Note that are optional, other variables are required 👍

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? 💡

Navigation

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.

🚑 Need Help?

=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

🔗
CoinMarketCap Documentation
"options"
Suggest one here
@SheetLink
"options"
CoinMarketCap
"options"
"options"
"options"
"options"
"options"
"options"
"options"
"options"
"options"
"options"
"options"
"options"
Quick Start
❓ FAQ
Functions
"options"