[Integrations](https://spiral.ai/integrations) › [opencode](https://spiral.ai/integrations/opencode) › [CFTC disaggregated futures positions](https://spiral.ai/integrations/opencode/cftc-disaggregated-futures-positions)

# How to Use CFTC disaggregated futures positions in opencode

Returns commodity futures positions and open interest split among producers, swap dealers, managed money, and other reportable traders. Use it to study managed money and commercial activity without options exposure.

|  |  |
| --- | --- |
| Model | CFTC disaggregated futures positions |
| Available through | Alexandria |
| Category | Finance |
| Price | $0.00873 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with CFTC disaggregated futures positions in opencode

- Use CFTC disaggregated futures positions to build a gold research table for 2025 with managed money long, short, net, and weekly net changes.
- Use CFTC disaggregated futures positions to look this up and give me the result as a table. Save the result in ./assets.
- Pull the latest numbers from CFTC disaggregated futures positions and tell me what changed since last week.
- Check CFTC disaggregated futures positions and summarize what you find in three bullet points.
- Pull the newest data from CFTC disaggregated futures positions and give me the result as a table.

## How to set up CFTC disaggregated futures positions in opencode

Pick the way that suits you. Each takes about two minutes.

### Use Spiral's MCP server

1. **Add the server**: Leave out `--global` to add Spiral to the current project only. No header and no client ID or secret: opencode registers itself with Spiral.

```bash
opencode mcp add spiral --global --url https://api.spiral.ai/mcp
```

2. **Sign in**: Your browser opens. Sign in to Spiral, pick the organization and click Authorize, then return to the terminal. No API key. Inside opencode, `/mcps` starts the same sign-in.

```bash
opencode mcp auth spiral
```

3. **Check it**: Spiral shows as connected.

```bash
opencode mcp list
```

### Use the Spiral skill

1. **Send opencode this message**: Your agent reads Spiral's skill and sets itself up.

```
set up https://spiral.ai/SKILL.md
```

2. **Sign in or paste a key**: Approve Spiral in the browser, or give the agent a key from the console.

### Use the Spiral CLI

1. **Install and sign in**: Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

```bash
npx -y spiral-cli@latest init
```

### Call the Spiral API

1. **Create an API key**: In the console, under API keys.

2. **Run CFTC disaggregated futures positions**: One request; the result comes back by polling or a webhook.

```bash
curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "cftc-gov/commitments-of-traders/disaggregated_futures_only",
    "input": {
      "to": "<to>"
    }
  }'
```

Then paste one of the prompts above: opencode finds CFTC disaggregated futures positions on Spiral, shows the price and runs it.

Setup guide in the docs: https://spiral.ai/docs/quickstarts/opencode

## CFTC disaggregated futures positions tools and prices

- [CFTC Commitments of Traders · Disaggregated futures only](https://spiral.ai/tools/alexandria/cftc-gov/commitments-of-traders/disaggregated_futures_only) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| to |  | — | Latest report date to include, YYYY-MM-DD (inclusive). Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. |
| from |  | — | Earliest report date to include, YYYY-MM-DD (inclusive). Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. |
| sort | recent_first, oldest_first | recent_first | Order by report date then id. The upstream default order is undefined, so an order is always sent. |
| query |  | — | SODA full-text search ($q) over the text columns, e.g. `gold` or `chicago board of trade`. |
| cursor |  | — | next_cursor from the previous page of the same query (the SODA $offset). |
| fields |  | — | Projection: SODA column names to return (open_interest_all, noncomm_positions_long_all, m_money_positions_long_all, ...). The identity columns id, market_and_exchange_names, report_date_as_yyyy_mm_dd and cftc_contract_market_code are always included. An unknown column is invalid_input. Omit for every column. |

## What can you do with CFTC disaggregated futures positions in opencode?

Build a CFTC research table that pairs contract coverage with weekly positioning for selected markets. A coding agent can add report-specific calculations and charts to your project while keeping futures-only and combined observations separate.

### Weekly positioning brief

Identify the relevant contract markets, then summarize open interest and changes in aggregate trader positions. Keep physical commodity and financial market classifications clearly labeled.

### Historical positioning ranges

Check each contract's available dates, then calculate where its current net position sits within its own historical range. Compare like trader categories within the same report type.

### Futures and combined exposure comparison

Match the same contract and reporting week across futures-only and combined reports. Show how including futures-equivalent options changes each trader category's reported position.

### Agricultural purchasing research

Find the relevant corn, wheat, or coffee contracts and prepare a positioning appendix for a purchasing review. Compare broad commercial activity, managed money, and index trader participation in separate tables.

### Research dataset coverage review

Use contract identities and available date ranges to select a study period. Inspect the resulting weekly position series for gaps before calculating changes or historical percentiles.

### Publication date monitoring

Check the latest available report dates for a contract watchlist and refresh its positioning tables when a new reporting week appears. Show the position date prominently in the resulting brief.

## Overview

- [Alexandria](https://spiral.ai/providers/alexandria)
- [All opencode guides](https://spiral.ai/integrations/opencode)

## CFTC disaggregated futures positions in other agents

- [Amp](https://spiral.ai/integrations/amp/cftc-disaggregated-futures-positions)
- [ChatGPT](https://spiral.ai/integrations/chatgpt/cftc-disaggregated-futures-positions)
- [Claude](https://spiral.ai/integrations/claude-desktop/cftc-disaggregated-futures-positions)
- [Claude Code](https://spiral.ai/integrations/claude-code/cftc-disaggregated-futures-positions)
- [Cline](https://spiral.ai/integrations/cline/cftc-disaggregated-futures-positions)
- [Codex](https://spiral.ai/integrations/codex/cftc-disaggregated-futures-positions)
- [Cursor](https://spiral.ai/integrations/cursor/cftc-disaggregated-futures-positions)
- [Devin](https://spiral.ai/integrations/devin/cftc-disaggregated-futures-positions)
- [dots](https://spiral.ai/integrations/dots/cftc-disaggregated-futures-positions)
- [Factory Droid](https://spiral.ai/integrations/factory-droid/cftc-disaggregated-futures-positions)
- [Gemini](https://spiral.ai/integrations/gemini/cftc-disaggregated-futures-positions)
- [Gemini CLI](https://spiral.ai/integrations/gemini-cli/cftc-disaggregated-futures-positions)
- [Google Antigravity](https://spiral.ai/integrations/antigravity/cftc-disaggregated-futures-positions)
- [goose](https://spiral.ai/integrations/goose/cftc-disaggregated-futures-positions)
- [Grok](https://spiral.ai/integrations/grok/cftc-disaggregated-futures-positions)
- [Grok Build](https://spiral.ai/integrations/grok-build/cftc-disaggregated-futures-positions)
- [Hermes](https://spiral.ai/integrations/hermes/cftc-disaggregated-futures-positions)
- [Instinct](https://spiral.ai/integrations/instinct/cftc-disaggregated-futures-positions)
- [Manus](https://spiral.ai/integrations/manus/cftc-disaggregated-futures-positions)
- [Muse](https://spiral.ai/integrations/muse/cftc-disaggregated-futures-positions)
- [Muse Code](https://spiral.ai/integrations/muse-code/cftc-disaggregated-futures-positions)
- [n8n](https://spiral.ai/integrations/n8n/cftc-disaggregated-futures-positions)
- [Notion](https://spiral.ai/integrations/notion/cftc-disaggregated-futures-positions)
- [OpenClaw](https://spiral.ai/integrations/openclaw/cftc-disaggregated-futures-positions)
- [Perplexity](https://spiral.ai/integrations/perplexity/cftc-disaggregated-futures-positions)
- [Raycast](https://spiral.ai/integrations/raycast/cftc-disaggregated-futures-positions)
- [VS Code](https://spiral.ai/integrations/vscode/cftc-disaggregated-futures-positions)
- [Windsurf](https://spiral.ai/integrations/windsurf/cftc-disaggregated-futures-positions)
- [Zapier](https://spiral.ai/integrations/zapier/cftc-disaggregated-futures-positions)

## More opencode guides

- [CFTC disaggregated futures and options positions](https://spiral.ai/integrations/opencode/cftc-disaggregated-futures-and-options-positions)
- [CFTC financial futures and options positions](https://spiral.ai/integrations/opencode/cftc-financial-futures-and-options-positions)
- [CFTC contract market directory](https://spiral.ai/integrations/opencode/cftc-contract-market-directory)
- [CFTC financial futures positions](https://spiral.ai/integrations/opencode/cftc-financial-futures-positions)
- [CFTC commodity index trader positions](https://spiral.ai/integrations/opencode/cftc-commodity-index-trader-positions)
- [CFTC futures and options positioning](https://spiral.ai/integrations/opencode/cftc-futures-and-options-positioning)

## Questions about CFTC disaggregated futures positions in opencode

**Can opencode use CFTC disaggregated futures positions?**

Yes. Add Spiral to opencode as an MCP server, and opencode can find and run CFTC disaggregated futures positions like any built-in tool.

**How much does CFTC disaggregated futures positions cost in opencode?**

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your opencode plan is separate.

**Do I need an Alexandria account to use CFTC disaggregated futures positions in opencode?**

No. Spiral runs CFTC disaggregated futures positions on its own Alexandria account. You sign in to Spiral once and never paste a key.

**How long does it take to set up CFTC disaggregated futures positions in opencode?**

About two minutes: add the server, then sign in, then check it.

**Does opencode wait while CFTC disaggregated futures positions runs?**

CFTC disaggregated futures positions runs in the background. opencode starts the run, checks on it and gives you the json when it's ready.

**How current is CFTC positioning data?**

Reports normally appear Friday at 3:30 p.m. Eastern time and describe positions from the preceding Tuesday. Federal holidays can delay publication by one or two days.

**Why can a contract disappear from COT reporting?**

A contract market drops out when it has fewer than 20 reportable large traders. CFTC adds it again once it reaches at least 20.

**Can I see how a specific fund is classified?**

CFTC does not publish individual traders' COT classifications because of confidentiality restrictions. The reports describe aggregate trader categories.

**How are options counted in combined reports?**

CFTC converts options into futures-equivalent positions using delta factors supplied by exchanges. Combined positions therefore include delta-adjusted options exposure alongside futures.

**How far back does CFTC's historical archive go?**

The source archives reach 1986 for legacy futures-only reports, 1995 for legacy combined reports, and 2006 for Supplemental reports. Individual contracts can have shorter histories.

