> For the complete documentation index, see [llms.txt](https://docs.sheet.link/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sheet.link/formulas/apps/coinmarketcap.md).

# CoinMarketCap

Review the official [CoinMarketCap Documentation](https://coinmarketcap.com/api/documentation/v1/) 📖

{% hint style="info" %}
Note that ["options"](/formulas/options.md) are optional, other variables are required 👍
{% endhint %}

| Formula                                                                                                                                                                                                                                                                                                               |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><strong>=CoinMarketCap(</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Interact with the <a href="https://coinmarketcap.com/api">CoinMarketCap</a> API using only the SheetLink <a href="/pages/-Mj_8hkrybUtkpITWTcT">"options"</a></p>                     |
| <p><strong>=CoinMarketCap\_QuotesLatest(</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Returns the latest market quote for 1 or more cryptocurrencies.</p>                                                                                                    |
| <p><strong>=CoinMarketCap\_QuotesLatestQuerySymbol( "symbol",</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency symbol such as "BTC".</p>                             |
| <p><strong>=CoinMarketCap\_QuotesLatestQuerySlug( "slug",</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Returns the latest market quote for 1 or more cryptocurrencies by querying a cryptocurrency slug such as "bitcoin".</p>                               |
| <p><strong>=CoinMarketCap\_QuotesLatestQueryId( "id",</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Returns the latest market quote for 1 or more cryptocurrencies by querying a CoinMarketCap id such as "1".</p>                                            |
| <p><strong>=CoinMarketCap\_MarketPairsLatest(</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency.</p>                                                          |
| <p><strong>=CoinMarketCap\_MarketPairsLatestQuerySymbol( "symbol",</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency symbol.</p> |
| <p><strong>=CoinMarketCap\_MarketPairsLatestQuerySlug( "slug",</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency slug.</p>       |
| <p><strong>=CoinMarketCap\_MarketPairsLatestQueryId( "id",</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency by querying a cryptocurrency id.</p>             |
| <p><strong>=CoinMarketCap\_Airdrops(</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Returns a list of past, present, or future airdrops which have run on CoinMarketCap.</p>                                                                                   |
| <p><strong>=CoinMarketCap\_Airdrop( "id",</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Returns information about a single airdrop available on CoinMarketCap. Includes the cryptocurrency metadata.</p>                                                      |
| <p><strong>=CoinMarketCap\_TrendingGainersLosers(</strong> <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>)</strong></p><p>Returns a paginated list of all trending cryptocurrencies, determined and sorted by the largest price gains or losses.</p>                                    |

{% hint style="success" %}
Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡
{% endhint %}

### Navigation <a href="#where-to" id="where-to"></a>

| Page                                                                                                                                                               |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| <p>🚀 <a href="/pages/-MjtZY-40yRn97o3WpS0"><strong>Quick Start</strong></a>​</p><p>60 second getting started guide.</p>                                           |
| <p><strong>​</strong><a href="/pages/-MjtX5XgEZMTHrXWxuJv"><strong>❓ FAQ</strong></a><strong>​</strong></p><p>Answers to frequently asked SheetLink questions.</p> |
| <p>🛠️ <a href="/pages/-MjdlTO1gwme--tVTlRW"><strong>Functions</strong></a><strong>​</strong></p><p>Powerful functions unique to SheetLink.</p>                    |
| <p>💪 <a href="/pages/-Mj_8hkrybUtkpITWTcT"><strong>"options"</strong></a><strong>​</strong></p><p>Control the request to and response from any application.</p>   |

## 🚑 Need Help?

You can always contact us via <support@sheet.link> or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink)