# CFTC COT Net Positioning Monitor (`aether_studio/cftc-cot-positioning-monitor`) Actor Get the latest official CFTC financial and commodity futures positions with weekly changes, derived net positions, strict limits, and source provenance. - **URL**: https://apify.com/aether\_studio/cftc-cot-positioning-monitor.md - **Developed by:** [AetherPromptStudio](https://apify.com/aether_studio) (community) - **Categories:** Automation, Developer tools, Other - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $0.50 / 1,000 results This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js/docs.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python/docs.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## CFTC COT Positioning Monitor This Apify Actor retrieves official weekly CFTC Commitments of Traders data and emits normalized, source-backed positioning records. It supports Traders in Financial Futures (TFF) futures-only and Disaggregated futures-only reports. The output preserves official long, short, and week-over-week change fields, adds derived net positions (`long - short`), a stable record key, retrieval metadata, and source provenance. It makes no trading recommendation or predictive score. ### Why use this Actor? - **Latest snapshot by default:** one small, predictable run for the newest official report. - **Two purpose-specific report families:** TFF for currencies, rates, and financial futures; Disaggregated for agriculture and natural resources. - **Analysis-ready nets:** dealer, asset-manager, leveraged-money, producer/merchant, swap-dealer, managed-money, and other-reportable net positions when applicable. - **Audit-friendly:** every row includes the official source query, CFTC record ID, retrieval timestamp, and stable record key. - **Bounded and inexpensive:** source reads are capped at 5,000 records and output at 1,000 records. No browser or proxy is used. This product is intentionally optimized for current-week monitoring and lean automation. It is not a bulk mirror of every CFTC report family. ### Inputs - `reportType`: `tff` (default) or `disaggregated` - `maxResults`: 1–1000 (default 100) - `commodityNames`: optional case-insensitive partial matches - `marketNames`: optional case-insensitive partial matches - `dateFrom`: optional `YYYY-MM-DD`, used when `latestOnly` is false - `latestOnly`: fetch only the newest official report date (default true) #### Example: latest financial-futures positions ```json { "reportType": "tff", "latestOnly": true, "maxResults": 100 } ```` #### Example: latest wheat positioning ```json { "reportType": "disaggregated", "commodityNames": ["wheat"], "latestOnly": true, "maxResults": 50 } ``` ### Sources - [CFTC COT overview](https://www.cftc.gov/MarketReports/CommitmentsofTraders/index.htm) - [TFF Futures Only API](https://publicreporting.cftc.gov/resource/gpe5-46if.json) - [Disaggregated Futures Only API](https://publicreporting.cftc.gov/resource/72hh-3qpy.json) The CFTC usually releases COT reports Friday using positions from the prior Tuesday. Source data can be revised; `retrievedAt` records when this Actor obtained each result. Government information on CFTC.gov is public domain and may be copied with appropriate acknowledgement under the [CFTC web policy](https://www.cftc.gov/WebPolicy/index.htm). ### Scheduling For weekly monitoring, schedule a run after the CFTC Friday release. Use `recordKey` to upsert records and `reportDate` to detect a newly published reporting week. ### Disclaimer For informational and research use only. This Actor does not provide investment, legal, accounting, or trading advice. Verify important decisions against official CFTC publications. This is an unofficial product and is not affiliated with, endorsed by, or sponsored by the CFTC or the U.S. Government. # Actor input Schema ## `reportType` (type: `string`): Which futures-only CFTC report to fetch. TFF covers financial futures; disaggregated covers agriculture and natural resources. ## `maxResults` (type: `integer`): Maximum number of normalized records to return. Bounded at 5000 for source queries; fewer if filters are applied. ## `commodityNames` (type: `array`): Filter to specific commodity names (e.g., 'WHEAT', 'CRUDE OIL'). Leave empty for all commodities. Filters applied client-side after bounded fetch. ## `marketNames` (type: `array`): Filter to specific market or exchange names (e.g., 'CHICAGO BOARD OF TRADE', 'ICE FUTURES U.S.'). Leave empty for all markets. Filters applied client-side after bounded fetch. ## `dateFrom` (type: `string`): Earliest report date (ISO 8601, e.g. '2025-01-07'). Ignored when latestOnly is true. When provided without latestOnly, fetches data from this date forward. ## `latestOnly` (type: `boolean`): When true, first determines the maximum as\_of\_date in the dataset, then fetches only records matching that date. Overrides dateFrom. ## Actor input object example ```json { "reportType": "tff", "maxResults": 100, "commodityNames": [], "marketNames": [], "dateFrom": "", "latestOnly": true } ``` # Actor output Schema ## `results` (type: `string`): Official weekly positions, changes, and derived net positions. ## `summary` (type: `string`): Report type, retrieval timestamp, source query, and result count. # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = {}; // Run the Actor and wait for it to finish const run = await client.actor("aether_studio/cftc-cot-positioning-monitor").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = {} # Run the Actor and wait for it to finish run = client.actor("aether_studio/cftc-cot-positioning-monitor").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{}' | apify call aether_studio/cftc-cot-positioning-monitor --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=aether_studio/cftc-cot-positioning-monitor", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "CFTC COT Net Positioning Monitor", "description": "Get the latest official CFTC financial and commodity futures positions with weekly changes, derived net positions, strict limits, and source provenance.", "version": "0.2", "x-build-id": "nBp133xrbL2ecp6DA" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/aether_studio~cftc-cot-positioning-monitor/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-aether_studio-cftc-cot-positioning-monitor", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/aether_studio~cftc-cot-positioning-monitor/runs": { "post": { "operationId": "runs-sync-aether_studio-cftc-cot-positioning-monitor", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/aether_studio~cftc-cot-positioning-monitor/run-sync": { "post": { "operationId": "run-sync-aether_studio-cftc-cot-positioning-monitor", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "reportType": { "title": "Report Type", "enum": [ "tff", "disaggregated" ], "type": "string", "description": "Which futures-only CFTC report to fetch. TFF covers financial futures; disaggregated covers agriculture and natural resources.", "default": "tff" }, "maxResults": { "title": "Max Results", "minimum": 1, "maximum": 1000, "type": "integer", "description": "Maximum number of normalized records to return. Bounded at 5000 for source queries; fewer if filters are applied.", "default": 100 }, "commodityNames": { "title": "Commodity Names", "uniqueItems": true, "type": "array", "description": "Filter to specific commodity names (e.g., 'WHEAT', 'CRUDE OIL'). Leave empty for all commodities. Filters applied client-side after bounded fetch.", "items": { "type": "string", "minLength": 1 }, "default": [] }, "marketNames": { "title": "Market / Exchange Names", "uniqueItems": true, "type": "array", "description": "Filter to specific market or exchange names (e.g., 'CHICAGO BOARD OF TRADE', 'ICE FUTURES U.S.'). Leave empty for all markets. Filters applied client-side after bounded fetch.", "items": { "type": "string", "minLength": 1 }, "default": [] }, "dateFrom": { "title": "Date From", "type": "string", "description": "Earliest report date (ISO 8601, e.g. '2025-01-07'). Ignored when latestOnly is true. When provided without latestOnly, fetches data from this date forward.", "default": "" }, "latestOnly": { "title": "Latest Report Only", "type": "boolean", "description": "When true, first determines the maximum as_of_date in the dataset, then fetches only records matching that date. Overrides dateFrom.", "default": true } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```