CFTC COT Report API (Legacy — Commercials vs Non-Commercials)

Weekly CFTC Commitments of Traders positioning for any futures market, any date range — Commercial vs Non-Commercial net positions.

Query the CFTC Commitments of Traders (Legacy) report by market and date range and get the weekly positioning: open interest, Commercial and Non-Commercial longs/shorts, and computed net positions. No account, no API key, and no proxies — this Actor reads a stable public API and returns clean, structured data you can download as JSON, CSV, or Excel, or pull straight from the Apify API.

Features

• ⚡ Fast & reliable — hits a stable public endpoint, so runs don't get blocked or break on layout changes.
• 🎯 Clean structured output — every result is a flat record with consistent fields (date, market, openInterest, commNet, nonCommNet).
• 🔁 Batch & schedulable — pass multiple queries in one run, or schedule it for a always-fresh feed.
• 🔌 Integrates everywhere — export JSON/CSV/Excel or connect via the API, webhooks, Zapier, Make, Google Sheets, and 5,000+ integrations.

Who it's for

Futures & commodities traders, quant researchers, and market analysts who trade the COT signal.

Common use cases

• Market, competitor, and trend research
• Feeding dashboards, spreadsheets, and internal tools
• Enriching datasets and powering AI / RAG / automation workflows

Input

Field	Type	Description
markets	array	Market/commodity search terms (e.g. 'GOLD', 'CRUDE OIL', 'EURO FX'). Required.
fromDate	string	Start date YYYY-MM-DD.
toDate	string	End date YYYY-MM-DD (default today).
maxItems	integer	Cap the number of records returned (0 = provider default).

Example input

{
  "markets": [
    "GOLD",
    "WTI"
  ],
  "fromDate": "2015-01-01",
  "toDate": "",
  "maxItems": 25
}

Output

One record per result. Example output:

{
  "date": "2024-01-15",
  "market": "...",
  "openInterest": "...",
  "commNet": "...",
  "nonCommNet": "..."
}

Fields: date, market, openInterest, commNet, nonCommNet. Download as JSON, CSV, XML, or Excel — or fetch programmatically from the dataset API.

Pricing

This Actor uses pay-per-result: you're billed only for the records you actually get. No monthly fee, and empty runs cost nothing — so it's dramatically cheaper than manual research or bloated data subscriptions.

FAQ

Do I need an API key or login? No — it uses a public endpoint. How fresh is the data? It's fetched live on every run, so it's as current as the source. Can I run it automatically? Yes — schedule it (hourly / daily / weekly) or trigger it via API or webhook. How do I get more results? Increase maxItems, or pass several queries in a single run. What formats can I export? JSON, CSV, Excel, XML, RSS, or via the API.

Notes

This Actor reads a public API. Please use it responsibly and within the data provider's terms of service.