CFTC Commitments of Traders: Weekly Net Positions by Market avatar

CFTC Commitments of Traders: Weekly Net Positions by Market

Pricing

from $2.00 / 1,000 weekly cot report row returneds

Go to Apify Store
CFTC Commitments of Traders: Weekly Net Positions by Market

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

Adriana Voss

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

10 days ago

Last modified

Features

Limited permissions

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

  1. In the Apify Console. Open the actor page and click Start — the markets field is already pre-filled with a working example. Results land in the run's dataset as soon as each item is found.
  2. 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"]}'
  3. 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 code 088691).
  • 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:

queryfoundstatusmarketreportCountmonitorStatusreportsreportIdreportDatereportWeekcontractMarketNamemarketAndExchangecftcMarketCodecftcContractCodecommodityNamecommodityGroupcommoditySubgroupcontractUnitsopenInterestopenInterestChangeopenInterestPctmanagedMoneyLongmanagedMoneyShortmanagedMoneySpreadmanagedMoneyNetmanagedMoneyNetChangemanagedMoneyLongPctmanagedMoneyShortPctmanagedMoneySpreadPctprodMercLongprodMercShortprodMercNetprodMercLongPctprodMercShortPctswapDealersLongswapDealersShortswapDealersSpreadswapDealersNetswapDealersLongPctswapDealersShortPctcommercialNetotherReportablesLongotherReportablesShortotherReportablesSpreadotherReportablesNetnonReportablesLongnonReportablesShortnonReportablesNettotalReportableLongtotalReportableShorttotalTradersconcentrationNet4LongPctconcentrationNet4ShortPctconcentrationNet8LongPctconcentrationNet8ShortPctisNewsourceUrlscrapedAt
GOLDtrueOK<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"
}