📊 CFTC COT Reports Scraper

🚀 Pull cftc cot reports data in seconds. Pull CFTC Commitments of Traders reports: market name, contract code, report date, open interest, commercial long/short, non-commercial long/short and changes week over week. structured records for trading and macro research.

🕒 Last updated: 2026-05-27 · 📊 24 fields per record · Weekly futures positioning data · All US-regulated futures markets

The CFTC COT Reports Scraper extracts structured records from CFTC Public Reporting. Every record captures the canonical fields you would expect from the upstream source - ready for analytics, dashboards, BI tooling, or further enrichment.

The dataset spans all us-regulated futures markets and exposes the same data the official source publishes - normalised, paginated, and queryable.

Who uses this data?

Audience	Use Case
Researchers	Build longitudinal datasets for analysis
Compliance teams	Monitor regulated entities and filings
Journalists	Investigate public records at scale
Data analysts	Power BI dashboards and reports
Academic researchers	Run quantitative studies on public data
Product teams	Embed live cftc cot reports records into apps

📋 What the CFTC COT Reports Scraper does

• Queries CFTC Public Reporting for the latest records
• Supports targeted filtering via the input parameters (see below)
• Returns structured records with 24 fields, no scraping artifacts
• Handles pagination automatically up to your maxItems limit
• Cleans HTML entities and normalises dates and identifiers
• Delivers results as tabular, spreadsheet, structured, or structured via Apify dataset pull

💡 Why it matters: Public-data sources rarely offer bulk pull. This Actor turns the live source into a queryable dataset.

🎬 Full Demo

🚧 Coming soon

⚙️ Input

Field	Type	Required	Description
maxItems	integer	No	Free users: 10. Paid users: optional, max 1,000,000.
commodityName	string	No	Filter by commodity name substring (e.g. GOLD, CRUDE OIL, WHEAT).
startDate	string	No	Filter reports on/after this date (YYYY-MM-DD). Optional.

Example 1: Default run (preview)

{
  "maxItems": 10
}

Example 2: Targeted query

{
  "maxItems": 5,
  "commodityName": "GOLD"
}

⚠️ Good to Know: Free users are limited to 10 items per run. Upgrade to a paid plan to unlock up to 1,000,000 items.

📊 Output

Field	Type	Description
🖼 Image imageUrl	string	-
📋 Market title	string	-
🔗 URL url	string	-
🔑 ID id	string	-
📋 Contract contractMarketName	string	-
🔑 Code cftcContractMarketCode	string	-
🏛️ Mkt Code cftcMarketCode	string	-
🗺️ Region cftcRegionCode	string	-
🔑 Commodity Code cftcCommodityCode	string	-
🌾 Commodity commodityName	string	-
📅 Date reportDate	string	-
📅 Week reportWeek	string	-
📊 OI openInterestAll	string	-
📈 NC Long noncommPositionsLongAll	string	-
📉 NC Short noncommPositionsShortAll	string	-
📈 C Long commPositionsLongAll	string	-
📉 C Short commPositionsShortAll	string	-
📈 Rep Long totReptPositionsLongAll	string	-
📉 Rep Short totReptPositionsShort	string	-
📈 NR Long nonreptPositionsLongAll	string	-
📉 NR Short nonreptPositionsShortAll	string	-
📊 ΔOI changeInOpenInterestAll	string	-
🕒 Collected scrapedAt	string	-
❌ Error error	string	Error message if record could not be retrieved

✨ Why choose this Actor

Feature	Detail
🌐 No login required	Public data only - no credentials needed
🔍 Targeted filtering	Search and filter via input parameters
📊 Weekly futures positioning data	Comprehensive coverage of all us-regulated futures markets
🧹 Clean output	Dates normalised, HTML stripped, arrays flattened
⚡ Fast	Direct source access without browser overhead
🔄 Auto-pagination	Retrieves results up to your maxItems
💾 4 pull records	structured records all available
🛡️ Retry logic	Multi-attempt retry with backoff for reliability

📈 How it compares to alternatives

Method	Speed	Scale	Structured Output	Free
This Actor	Fast	1,000,000 records	Yes (24 fields)	10 free / unlimited paid
Manual site search	Slow	Limited per session	No	Yes
Bulk data retrieves	Slow setup	Variable	Partial	Variable
Custom API script	Variable	Unlimited	Requires dev work	Dev cost

🚀 How to use

1. Create a free Apify account - includes $5 free credit
2. Open the CFTC COT Reports Scraper actor page
3. Configure your input - set filters or leave defaults
4. Set maxItems (10 for a quick preview, higher for bulk extraction)
5. Click Run and wait for the dataset to populate
6. Retrieves your results as tabular, spreadsheet, structured, or structured

💼 Business use cases

Compliance and Due Diligence

Teams use cftc cot reports data to verify entities, monitor regulatory status, and feed downstream pipelines.

Market Research

Analysts map all us-regulated futures markets to understand market structure, competitive activity, or regulatory trends.

Lead Generation

Sales teams enrich CRM records with cftc cot reports data to identify prospects and qualify leads.

Investigative Journalism

Reporters use bulk extracts to find patterns, anomalies, and stories hidden in public records.

🔌 Automating CFTC COT Reports Scraper

Connect this Actor to your existing workflows using Apify integrations:

• Make (Integromat) - trigger a run on a schedule and push results to Google Sheets or a database
• Zapier - automatically pull new records to Airtable, Notion, or your CRM
• Slack - get notified when a monitored entity has new activity
• Webhooks - receive real-time notifications when a run completes

🌟 Beyond business use cases

Academic Research

Study trends, behaviours, and patterns in all us-regulated futures markets records across time.

Civic Tech and Transparency

Civic-tech projects build dashboards on top of bulk extracts to surface public-interest insights.

Education

Educators use real cftc cot reports data to teach data analysis and domain knowledge.

Personal Research

Individuals - researchers, hobbyists, family historians - use bulk pull to answer questions that no single web search can.

🤖 Ask an AI assistant about this scraper

Paste a few sample records into ChatGPT, Claude, or another AI assistant and ask it to summarise the dataset, explain fields, identify patterns, or suggest filter combinations.

❓ Frequently Asked Questions

🔍 What does this Actor do? It extracts cftc cot reports records from CFTC Public Reporting into a clean, queryable dataset.

📊 How many records are available? Weekly futures positioning data.

🔑 Do I need an account or API key? No. This Actor uses public sources that require no authentication.

📅 How up-to-date is the data? The Actor queries the source live on every run.

🔍 Can I filter by specific fields? Yes - see the Input section above for all supported filters.

⚡ How fast is the scraper? A typical 10-item preview completes in under 30 seconds.

📄 What records is the output? Records are stored in Apify's dataset storage and can be pulled as tabular, spreadsheet, structured, or structured.

🏆 Why are some fields null for certain records? Some fields are optional at the source. The Actor returns null rather than fabricating values.

📋 Can I run this on a schedule? Yes - use Apify's built-in scheduler or trigger via Make / Zapier / Webhooks.

💰 Is there a cost to use this Actor? Free users receive 10 records per run. Create a paid account to unlock up to 1,000,000 records per run.

🌍 Does it cover all us-regulated futures markets? Yes - see the coverage line above.

🛡️ Is this Actor compliant? The Actor accesses only publicly available data, in line with the source's published terms of service.

🔌 Integrate with any app

Pull data directly from the Apify platform to:

Spreadsheets & Databases Google Sheets - Microsoft spreadsheet - Airtable - Notion - PostgreSQL - MySQL - MongoDB

Automation & Workflows Make (Integromat) - Zapier - n8n - Pipedream - Activepieces

Cloud Storage AWS S3 - Google Cloud Storage - Azure Blob Storage - Dropbox

APIs & Webhooks REST API - Webhooks - Apify API

🔗 Recommended Actors

Actor	Description
OurAirports Global Airport Database Scraper	Pull worldwide airport data including ICAO/IATA codes
FINRA BrokerCheck Scraper	Extract broker and firm registration data from FINRA
Hacker News Stories Scraper	Pull live Hacker News top stories with score and comments

💡 Pro Tip: browse the complete ParseForge collection for more public-data scrapers.

---

Need help? Visit the Apify Discord community or open a support ticket.

Disclaimer: This Actor accesses publicly available data from CFTC Public Reporting in compliance with the source's terms of service. Data is provided as-is for informational purposes. Verify all records against the official source before relying on them for legal or business decisions.