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

# How to Use CFTC legacy futures positions in opencode

Returns commercial, noncommercial, and nonreportable futures positions alongside open interest. Use it for traditional COT analysis and historical comparisons that exclude options.

|  |  |
| --- | --- |
| Model | CFTC legacy 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 legacy futures positions in opencode

- Use CFTC legacy futures positions to add a corn positioning chart to this project for 2024 and 2025, showing commercial net positions, noncommercial net positions, and open interest.
- Use CFTC legacy 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 legacy futures positions and tell me what changed since last week.
- Check CFTC legacy futures positions and summarize what you find in three bullet points.
- Pull the newest data from CFTC legacy futures positions and give me the result as a table.

## How to set up CFTC legacy 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 legacy 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/legacy_futures_only",
    "input": {
      "to": "<to>"
    }
  }'
```

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

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

## CFTC legacy futures positions tools and prices

- [CFTC Commitments of Traders · Legacy futures only](https://spiral.ai/tools/alexandria/cftc-gov/commitments-of-traders/legacy_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 legacy 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.

### Institutional financial market comparison

Identify currency, Treasury, or equity index contracts and compare asset manager and leveraged fund positioning. Add traditional commercial and noncommercial totals as separately labeled context.

## Overview

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

## CFTC legacy futures positions in other agents

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

## More opencode guides

- [CFTC legacy futures and options positions](https://spiral.ai/integrations/opencode/cftc-legacy-futures-and-options-positions)
- [CME FedWatch meeting probabilities](https://spiral.ai/integrations/opencode/cme-fedwatch-meeting-probabilities)
- [CFTC index trader positions](https://spiral.ai/integrations/opencode/cftc-index-trader-positions)
- [CME FedWatch probability history](https://spiral.ai/integrations/opencode/cme-fedwatch-probability-history)
- [CFTC futures positioning](https://spiral.ai/integrations/opencode/cftc-futures-positioning)
- [CME Group trading hours search](https://spiral.ai/integrations/opencode/cme-group-trading-hours-search)

## Questions about CFTC legacy futures positions in opencode

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

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

**How much does CFTC legacy 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 legacy futures positions in opencode?**

No. Spiral runs CFTC legacy 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 legacy futures positions in opencode?**

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

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

CFTC legacy 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.

