CFTC Commitments of Traders: Weekly Net Positions by Market
Pricing
from $2.00 / 1,000 weekly cot report row returneds
CFTC Commitments of Traders: Weekly Net Positions by Market
CFTC Commitments of Traders (COT) Disaggregated data for futures markets: weekly net positions for managed money, producers, swap dealers, and open interest. Export to Sheets or n8n.
Pricing
from $2.00 / 1,000 weekly cot report row returneds
Rating
0.0
(0)
Developer
Adriana Voss
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
10 days ago
Last modified
Categories
Features
Share
Get official CFTC Commitments of Traders (COT) weekly positioning data by market, commodity, or contract code. One call fetches disaggregated futures positioning straight from the Commodity Futures Trading Commission (publicreporting.cftc.gov) and returns structured weekly rows: total open interest, commercial hedger positions (producer/merchant and swap dealers), speculative managed money (hedge funds, CTAs), other reportables, and non-reportables (retail). Turn on monitoring and run on a weekly schedule (Friday afternoon) to receive only new weekly reports as soon as they are published, billed per row and free on quiet runs.
Who uses it:
- Commodity and macro traders tracking institutional money flow and commercial hedging in gold, crude oil, natural gas, silver, and grains.
- Quantitative analysts and quants building sentiment, positioning velocity, or crowding indicators.
- Newsletter authors and financial researchers generating automated weekly COT positioning tables and charts.
- Automation workflows (Make, n8n, Google Sheets) alerting on extreme hedge fund net longs or net shorts.
What is covered
Sourced directly from the official CFTC Disaggregated Futures Commitments of Traders dataset:
- Managed Money: long, short, spread, net positioning, and weekly net change (the key speculative positioning metric).
- Producer / Merchant / Processor / User: commercial physical hedgers.
- Swap Dealers: institutional swap and derivative dealers.
- Total Commercial Net: combined producer/merchant and swap dealer net positioning.
- Other Reportables & Non-Reportables: active large non-commercial traders and small retail traders.
- Open Interest: total market open interest and weekly contract changes.
- Trader Concentration: percentage of open interest held by top 4 and top 8 largest traders.
How to use
- In the Apify Console. Open the actor page and click Start — the
marketsfield is already pre-filled with a working example. Results land in the run's dataset as soon as each item is found. - Via the API. Call it directly with a POST request — no Console needed once you have an API token:
curl "https://api.apify.com/v2/acts/accountable_eel~cftc-commitments-of-traders-lookup/run-sync-get-dataset-items?token=<YOUR_TOKEN>" \-X POST \-H "Content-Type: application/json" \-d '{"markets":["GOLD","CRUDE OIL"]}'
- On a schedule. Save this actor as an Apify Task with the input you want, then add a Schedule (hourly, daily, weekly) so it runs on its own — no server of your own required.
Input
{"markets": ["GOLD","CRUDE OIL"]}
One market name, commodity, or CFTC contract code per line. For example: GOLD, CRUDE OIL, SILVER, SOYBEANS, or 088691. Sourced from the CFTC Disaggregated Futures Commitments of Traders dataset. Accepted formats: GOLD, CRUDE OIL, SILVER, SOYBEANS, 088691.
{"markets": ["GOLD", "CRUDE OIL"],"weeks": 4,"maxItems": 20}
markets: list of commodities, contract names, or CFTC codes (e.g.GOLD,CRUDE OIL,SOYBEANS,SILVER, or code088691).weeks: how many weekly historical reports to fetch per market (default: 4, up to 52).maxItems: maximum weekly report rows per market (default: 20, up to 100).onlyNewSinceLastRun: optional boolean (default: false). When true, only reports published since your previous run are returned.deltaName: optional string to name your watchlist memory.
Output
One row per weekly report for each matching futures contract:
| query | found | status | market | reportCount | monitorStatus | reports | reportId | reportDate | reportWeek | contractMarketName | marketAndExchange | cftcMarketCode | cftcContractCode | commodityName | commodityGroup | commoditySubgroup | contractUnits | openInterest | openInterestChange | openInterestPct | managedMoneyLong | managedMoneyShort | managedMoneySpread | managedMoneyNet | managedMoneyNetChange | managedMoneyLongPct | managedMoneyShortPct | managedMoneySpreadPct | prodMercLong | prodMercShort | prodMercNet | prodMercLongPct | prodMercShortPct | swapDealersLong | swapDealersShort | swapDealersSpread | swapDealersNet | swapDealersLongPct | swapDealersShortPct | commercialNet | otherReportablesLong | otherReportablesShort | otherReportablesSpread | otherReportablesNet | nonReportablesLong | nonReportablesShort | nonReportablesNet | totalReportableLong | totalReportableShort | totalTraders | concentrationNet4LongPct | concentrationNet4ShortPct | concentrationNet8LongPct | concentrationNet8ShortPct | isNew | sourceUrl | scrapedAt |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GOLD | true | OK | <all reports (full list)> | <managed money long %> | <managed money short %> | <managed money spread %> | <producer/merchant long> | <producer/merchant short> | <producer/merchant net position> | <producer/merchant long %> | <producer/merchant short %> | <swap dealers long %> | <swap dealers short %> | <top 4 traders net long %> | <top 4 traders net short %> | <top 8 traders net long %> | <top 8 traders net short %> | <is this report new?> | 1970-01-01T00:00:00.000Z |
Every row includes:
market: queried market name.reportDate: Tuesday as-of date (YYYY-MM-DD).contractMarketName: contract name (e.g.GOLD,WTI FINANCIAL CRUDE OIL).commodityName&commodityGroup: category classifications.openInterest&openInterestChange: total open interest and weekly change.managedMoneyNet&managedMoneyNetChange: net managed money contracts and weekly change.commercialNet: combined net commercial positions.sourceUrl: direct link to the CFTC record.scrapedAt: ISO timestamp.
Missing values return null (never 0 or empty string). A query matching no markets returns a single found: false row and is never charged.
Monitoring & Alerts
Turn on onlyNewSinceLastRun to run this actor as an automated weekly alert (e.g. scheduled for Friday 4:00 PM US Eastern, right after CFTC releases new data):
- The first run establishes the baseline and returns all matching reports.
- Subsequent runs return only newly published weekly reports.
- Quiet runs (no new release) return a status row with
reportCount: 0,monitorStatus: "NO_NEW_REPORTS", and cost $0 (never charged).
Limits
- CFTC updates Commitments of Traders data once a week, normally on Friday at 3:30 PM Eastern Time, reflecting positioning as of the previous Tuesday.
- Disaggregated reports cover physical commodities (precious metals, energies, agriculture, livestock) and select financial contracts.
- Rate limits: requests honor CFTC's crawl-delay policy.
Pricing
- Weekly COT report row returned: $4 per 1,000 reports
Plus a $0.00005 start fee per run. Each event above is billed independently, only when it actually returns data — misses (found:false) are never charged.
Use it from Clay, n8n, Make, or an AI agent
This actor runs synchronously over plain HTTP — call it directly from a script, a workflow tool, or an AI agent, no Apify Console needed once you have an API token.
curl "https://api.apify.com/v2/acts/accountable_eel~cftc-commitments-of-traders-lookup/run-sync-get-dataset-items?token=<YOUR_TOKEN>" \-X POST \-H "Content-Type: application/json" \-d '{"markets":["GOLD","CRUDE OIL"]}'
n8n. Add an HTTP Request node: Method POST, URL https://api.apify.com/v2/acts/accountable_eel~cftc-commitments-of-traders-lookup/run-sync-get-dataset-items?token=<YOUR_TOKEN>, Body Content Type JSON, JSON Body {"markets":["GOLD","CRUDE OIL"]} (swap in an expression from an earlier node for a real value).
Clay. Add an "HTTP API" column: Method POST, URL https://api.apify.com/v2/acts/accountable_eel~cftc-commitments-of-traders-lookup/run-sync-get-dataset-items?token=<YOUR_TOKEN>, Body {"markets":["{{market}}"]}, mapping the row's market into the markets array.
MCP. In Claude, Cursor, or any MCP client with the Apify MCP server, ask for "cftc commitments of traders data" — the agent will find and run this actor.
Example runs
Paste any of these into the Input tab and press Start. All three run keyless with no tokens, keys, or external setup required.
1. Gold and Crude Oil positioning (last 4 weeks)
{"markets": ["GOLD", "CRUDE OIL"],"weeks": 4,"maxItems": 20}
2. Precious metals watch (Gold, Silver, Platinum)
{"markets": ["GOLD", "SILVER", "PLATINUM"],"weeks": 8,"maxItems": 30}
3. Weekly Friday COT monitor (alerts only on newly released reports)
{"markets": ["GOLD", "CRUDE OIL", "NATURAL GAS", "SOYBEANS"],"weeks": 1,"onlyNewSinceLastRun": true,"deltaName": "weekly-commodities-alert"}