> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/finance-and-accounting/coinmarketcap.md).
# CoinMarketCap
Pull CoinMarketCap crypto listings, quotes, and exchange data into Google Sheets, BigQuery, or AI tools via Coupler.io.
CoinMarketCap is the world's most referenced cryptocurrency data platform, tracking prices, market caps, trading volumes, and rankings for thousands of digital assets. It also provides fiat exchange rates, exchange-level data, and category classifications.
Connecting CoinMarketCap to Coupler.io lets you:
* **Monitor crypto prices automatically** — pull live or historical quotes into spreadsheets or dashboards without manual copy-pasting
* **Track market rankings** — keep tabs on the latest listings and market cap movements across assets
* **Combine with other financial data** — join crypto quotes with fiat rates or exchange data using Coupler.io's Join and Aggregate transformations
* **Feed AI tools** — send market data directly to ChatGPT, Claude, Gemini, or other AI destinations for analysis and commentary
## Prerequisites
* A CoinMarketCap account with an active API key (available on the [CoinMarketCap Developer Portal](https://coinmarketcap.com/api/))
* The free Basic plan provides access to the core endpoints used by Coupler.io; higher-tier plans unlock historical data
{% hint style="warning" %}
Historical OHLCV data requires a paid CoinMarketCap API plan. The free tier covers latest market data only.
{% endhint %}
## Quick start
{% hint style="success" %}
Start with the **Listings** entity to get a ranked overview of all cryptocurrencies, then add a **Quotes** entity filtered to your specific symbols for focused tracking.
{% endhint %}
{% stepper %}
{% step %}
**Create a new data flow in Coupler.io.** Go to your Coupler.io workspace and click **Add data flow**. Search for and select **CoinMarketCap** as your source.
{% endstep %}
{% step %}
**Enter your CoinMarketCap API key.** In the source settings, paste your API key from the CoinMarketCap Developer Portal into the API key field.
{% endstep %}
{% step %}
**Select an entity.** Choose from Categories, Listings, Quotes, Fiats, or Exchanges depending on the data you need.
{% endstep %}
{% step %}
**Configure data type and symbols.** Set the data type to **latest** or **historical**. If you selected Quotes, enter the cryptocurrency symbols you want to track (one per line, e.g., BTC, ETH, SOL).
{% endstep %}
{% step %}
**Choose your destination.** Select where to send the data — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like ChatGPT, Claude, or Gemini.
{% endstep %}
{% step %}
**Run the data flow.** Click **Run** to execute a manual sync and confirm your data loads correctly before setting up a schedule.
{% endstep %}
{% endstepper %}
## Entities overview
| Entity | Description |
| -------------- | ------------------------------------------------------------------------------------ |
| **Listings** | Full ranked list of cryptocurrencies with price, market cap, volume, and supply data |
| **Quotes** | Current market quotes for specific coins — filter by symbol for targeted tracking |
| **Categories** | Thematic groupings of cryptocurrencies (e.g., DeFi, Layer 1, Gaming) |
| **Fiats** | Fiat currency reference data and exchange rates |
| **Exchanges** | Exchange-level market data including volume and trading pairs |
## CoinMarketCap data overview
CoinMarketCap provides structured market data across five entities in Coupler.io. You can pull live snapshots or historical intervals depending on your API plan and the data type you select.
## Entities
| Entity | Best for |
| ---------- | --------------------------------------------------- |
| Listings | Market-wide ranking tables and cap/volume overviews |
| Quotes | Targeted price monitoring for specific coins |
| Categories | Sector-level analysis (DeFi, NFT, Layer 2, etc.) |
| Fiats | Fiat reference rates for currency conversion |
| Exchanges | Exchange volume comparisons and market structure |
## Available data fields
#### Listings
| Field | Description |
| ------------------------------ | ------------------------------ |
| id | CoinMarketCap internal coin ID |
| name | Full cryptocurrency name |
| symbol | Ticker symbol (e.g., BTC, ETH) |
| cmc\_rank | Current CoinMarketCap ranking |
| price | Current price in USD |
| market\_cap | Total market capitalization |
| volume\_24h | 24-hour trading volume |
| percent\_change\_1h / 24h / 7d | Price change percentages |
| circulating\_supply | Coins currently in circulation |
| total\_supply | Total issued supply |
| last\_updated | Timestamp of last data update |
#### Quotes
| Field | Description |
| ------------------------------------ | ------------------------------- |
| symbol | Requested cryptocurrency symbol |
| price | Current price |
| volume\_24h | 24-hour volume |
| market\_cap | Market capitalization |
| percent\_change\_1h / 24h / 7d / 30d | Multi-timeframe price changes |
| fully\_diluted\_market\_cap | Market cap at max supply |
| last\_updated | Data freshness timestamp |
#### Categories
| Field | Description |
| ----------------------- | ---------------------------------------------- |
| id | Category ID |
| name | Category name (e.g., DeFi, Metaverse) |
| title | Display title |
| description | Category description |
| num\_tokens | Number of tokens in category |
| market\_cap | Aggregate market cap for the category |
| volume\_24h | Aggregate 24h volume |
| avg\_price\_change\_24h | Average price change across tokens in category |
#### Fiats
| Field | Description |
| ------ | ------------------------------------ |
| id | Fiat currency ID |
| name | Currency name |
| symbol | ISO currency symbol (e.g., USD, EUR) |
| sign | Currency sign |
#### Exchanges
| Field | Description |
| ------------------ | ------------------------------ |
| id | Exchange ID |
| name | Exchange name |
| slug | URL-friendly identifier |
| num\_market\_pairs | Number of active trading pairs |
| volume\_24h | Total 24h exchange volume |
| last\_updated | Timestamp of last update |
## Common data combinations
* **Listings + Quotes** — use Coupler.io's **Join** transformation to enrich ranked listing data with real-time price quotes for your target coins
* **Quotes + Fiats** — combine quote prices with fiat rates to convert USD values into local currencies
* **Quotes (multiple symbols)** — use **Append** to pull quotes from multiple separate data flows (e.g., by asset class) into one unified table
* **Categories + Listings** — join category tags onto individual coin listings for sector-level filtering in your dashboard
## Use cases by role
{% tabs %}
{% tab title="Crypto analysts" %}
* Pull **Listings** daily into a Google Sheet to track rank movements and identify coins gaining or losing momentum
* Use **Quotes** with specific symbols to monitor a custom watchlist and compare 1h/24h/7d changes side by side
* Feed quotes data into ChatGPT or Claude for automated market commentary
{% endtab %}
{% tab title="Finance teams" %}
* Use **Fiats** to maintain up-to-date conversion rates alongside crypto holdings
* Pull **Listings** into BigQuery to build historical snapshots of market cap and volume over time
* Combine exchange data with internal trading records to reconcile volumes
{% endtab %}
{% tab title="Researchers & developers" %}
* Use **Categories** to segment the market by sector and track aggregate DeFi or Layer 2 performance
* Pull **historical** data type for OHLCV analysis and backtesting (requires paid API plan)
* Send structured market data to Cursor or Perplexity for research summaries and trend detection
{% endtab %}
{% endtabs %}
## Platform-specific notes
* The **Quotes** entity requires at least one cryptocurrency symbol — leave it blank and the sync will fail
* Symbol input is case-insensitive but must match CoinMarketCap's recognized tickers exactly
* The **historical** data type returns OHLCV interval data and is only available on paid CoinMarketCap API plans
* CoinMarketCap data is quoted in USD by default; use **Fiats** data to handle multi-currency conversion in your destination
* The free Basic API tier has strict call limits — avoid scheduling very frequent refreshes if you're on this plan
## CoinMarketCap common issues
### Connection issues
My API key is rejected during setup
Double-check that you copied the full API key from the CoinMarketCap Developer Portal without any leading or trailing spaces. Keys are long strings — partial copies are a common mistake.
Also confirm the key is active. Log into your CoinMarketCap developer account and check that your API key status shows as **Active**, not disabled or pending.
The data flow connects but returns no data
This usually happens when the Quotes entity is selected but no symbols are entered. The Quotes entity requires at least one ticker symbol (e.g., BTC) to return data. Go back to your source settings and add symbols under the **Cryptocurrency symbols** field.
### Missing data
Historical data is empty or unavailable
Historical OHLCV data requires a paid CoinMarketCap API plan. If you're on the free Basic tier, set the **Data type** to **latest** — historical will always return empty results on a free key.
{% hint style="warning" %}
Upgrade your CoinMarketCap plan before switching to historical data type, or your data flow will consistently return no rows.
{% endhint %}
Some coins I entered are missing from Quotes results
CoinMarketCap's API rejects symbols it doesn't recognize — and it won't return partial results. Check each symbol against the CoinMarketCap website to confirm the exact ticker. Some tokens share similar names but have different official symbols (e.g., LUNA vs LUNC).
### Permission errors
I'm getting a 401 or "API key missing" error
This means Coupler.io cannot authenticate with CoinMarketCap. Re-enter your API key in the source settings. If the problem persists, regenerate your key in the CoinMarketCap Developer Portal and update it in Coupler.io.
I'm getting a 403 "access forbidden" error on a specific endpoint
Certain entities or data types (especially historical) are restricted to higher-tier API plans. A 403 error means your current plan doesn't include access to that endpoint. Review your plan permissions on the CoinMarketCap Developer Portal.
### Data discrepancies
Prices in Coupler.io don't match what I see on the CoinMarketCap website
CoinMarketCap prices update frequently. If you're comparing data pulled a few minutes ago to the live website, you'll see differences. The **last\_updated** field in your data shows exactly when the snapshot was taken — use this to verify freshness.
Market cap or volume numbers look different from other sources
CoinMarketCap uses its own methodology for calculating market cap (circulating supply × price) and aggregating volume. Other platforms may use different supply figures or volume weighting. These differences are expected — they're not a sync error.
### Rate limits
My data flow fails with a rate limit or 429 error
The free CoinMarketCap API plan has a monthly call credit limit. Each sync run consumes credits — more entities and larger datasets use more credits. Reduce your sync frequency or narrow your symbol list to stay within limits. Upgrading your CoinMarketCap plan will increase your credit allowance.
{% hint style="danger" %}
Running multiple data flows pulling the same CoinMarketCap entity simultaneously will exhaust your monthly credits faster. Consolidate entities into a single data flow where possible.
{% endhint %}
## CoinMarketCap FAQ
Does CoinMarketCap support historical OHLCV data in Coupler.io?
Yes — set the **Data type** parameter to **historical** when configuring your source. However, historical data is only available on paid CoinMarketCap API plans. If you're on the free Basic tier, this option will return empty results.
How do I specify which cryptocurrencies to pull for Quotes?
In the source settings, enter each symbol on a new line in the **Cryptocurrency symbols** field. Use the official CoinMarketCap ticker (e.g., BTC, ETH, SOL). You must enter at least one symbol — the Quotes entity won't return data without one.
Can I pull data for all cryptocurrencies at once?
For a full market list, use the **Listings** entity — it returns all ranked cryptocurrencies in one call without requiring symbol input. The Quotes entity is better suited for a targeted watchlist of specific coins.
What's the difference between Listings and Quotes?
Listings returns the full CoinMarketCap ranked table with market cap, volume, supply, and price change data for every tracked coin. Quotes returns detailed pricing data for specific coins you define by symbol. Use Listings for market overviews and Quotes for monitoring a custom set of assets.
Can I combine data from multiple CoinMarketCap entities in one destination?
Yes. Add multiple entities within the same data flow and use Coupler.io's **Join** transformation to merge them (e.g., join Listings with Quotes on the symbol field), or use **Append** to stack data from different entities or multiple data flows into one table.
Can I send CoinMarketCap data to an AI tool for analysis?
Absolutely. Coupler.io supports AI destinations including ChatGPT, Claude, Gemini, Perplexity, Cursor, and OpenClaw. Pull your Quotes or Listings data and route it to any of these tools for automated market summaries, trend detection, or portfolio commentary.
How often can I refresh CoinMarketCap data?
You can schedule refreshes as frequently as your CoinMarketCap API plan allows. The free Basic plan has monthly credit limits — each sync run consumes credits. Hourly refreshes are a practical balance for most use cases on a free plan.
Why is my CoinMarketCap data slightly different from the website?
CoinMarketCap prices update continuously. Any data you've pulled reflects the moment of the last sync, not the real-time price. Check the **last\_updated** field in your data to see exactly when the snapshot was taken.
{% hint style="info" %}
For a full list of available fields and metric definitions, see the [Data Overview](#coinmarketcap-data-overview) article. If you're hitting API errors or missing data, check [Common Issues](#coinmarketcap-common-issues) for fixes.
{% endhint %}
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.
Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:
```
GET https://docs.coupler.io/sources/category/finance-and-accounting/coinmarketcap.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.