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

# How to Use CFTC commodity futures and options positions in opencode

Returns weekly commodity positions by trader category, combining futures with options converted to futures-equivalent exposure. Use it to include options when comparing managed money, swap dealers, producers, and other reportable traders.

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

## Prompts to try with CFTC commodity futures and options positions in opencode

- Use CFTC commodity futures and options positions to fetch the latest 52 reports for COMEX silver and build a table showing all four trader categories, their longs and shorts, and weekly changes.
- Use CFTC commodity futures and options positions to retrieve three years of COMEX copper observations and add a chart of managed-money net positions as a percentage of open interest.
- Use CFTC commodity futures and options positions to look this up and give me the result as a table. Save the result in ./assets.
- Pull the latest numbers from CFTC commodity futures and options positions and tell me what changed since last week.
- Check CFTC commodity futures and options positions and summarize what you find in three bullet points.

## How to set up CFTC commodity futures and options 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 commodity futures and options 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/disaggregated/combined",
    "input": {
      "$limit": 1000
    }
  }'
```

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

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

## CFTC commodity futures and options positions tools and prices

- [CFTC · Disaggregated report, futures and options combined](https://spiral.ai/tools/alexandria/cftc/disaggregated/combined) (Alexandria): $0.001746 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| $limit |  | 1000 | Rows to return. The default is 1,000; the datasets hold hundreds of thousands, so a date or market filter is what keeps a page useful rather than this. |
| $where |  | — | A SoQL filter for anything the column filters cannot say: `report_date_as_yyyy_mm_dd > '2026-01-01' AND commodity_name = 'GOLD'`, `open_interest_all > 100000`, `market_and_exchange_names like '%CRUDE%'`. An unknown column answers HTTP 400 with the failing query echoed back. |
| $offset |  | — | Rows to skip, for paging past `$limit`. |
| $select |  | — | Columns to return, comma-separated, in place of all of them. `count(*)` on its own answers how many rows match. A selected subset no longer matches the declared fields, so read the declared list as what the full row carries. |
| commodity_name |  | — | Commodity name, `GOLD` or `CRUDE OIL`. Exact match, upper case. One commodity can span several markets. |
| cftc_market_code |  | — | Exchange code: `CBT`, `CME`, `NYME`, `CMX`, `ICUS`, `ICEU`. Exact match, and unreliable on its own: a quarter of the rows store the code with trailing spaces (`CMX ` beside `CMX`, the latest gold row among them), and equality on `CMX` misses every one of those. Filter on `cftc_contract_market_code` instead, or use `$where=cftc_market_code like 'CMX%'`. |

## What can you do with CFTC commodity futures and options positions in opencode?

Build a commodity positioning dashboard with category longs, shorts, weekly changes, and open interest. A coding agent can turn CFTC observations into charts and historical research features in your project.

### Write a weekly commodity positioning brief

Summarize changes in managed-money longs, shorts, and net positions for gold, silver, and copper. Include each market's open interest and identify the report basis used.

### Put current positioning in historical context

Calculate where the latest managed-money net position sits within five years of observations for a selected commodity market.

### Compare producers with managed money

Chart producer and merchant longs and shorts alongside managed-money positions in corn or wheat. Show how the category totals changed over the same reporting dates.

### Compare positioning across commodity markets

Express managed-money net positions as a percentage of each market's open interest to compare gold, silver, and copper without ranking raw contract counts alone.

### Monitor spreading positions

Track reported spreading positions for managed money, swap dealers, and other reportable traders. Compare their weekly changes with changes in outright longs and shorts.

### Review concentration in a commodity market

Compare the open-interest concentration measures for the largest four and eight traders over time. Highlight weeks when concentration rises alongside a change in total open interest.

### Build positioning features for research

Create weekly series of category net positions, weekly changes, and open-interest shares for a commodity research model. Apply the publication lag when deciding when each observation becomes available.

### Check how options change the positioning picture

Compare futures-only and combined positions for the same market and reporting dates. Show whether including delta-adjusted options changes the size or direction of a category's net exposure.

## Overview

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

## CFTC commodity futures and options positions in other agents

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

## More opencode guides

- [CFTC Financial futures report, futures only](https://spiral.ai/integrations/opencode/cftc-financial-futures-report-futures-only)
- [CFTC commodity futures positions](https://spiral.ai/integrations/opencode/cftc-commodity-futures-positions)
- [CFTC Financial futures report, futures and options combined](https://spiral.ai/integrations/opencode/cftc-financial-futures-report-futures-and-options-combined)
- [CFTC commodity index trader positions](https://spiral.ai/integrations/opencode/cftc-commodity-index-trader-positions)
- [Benzinga withdrawn calendar records](https://spiral.ai/integrations/opencode/benzinga-withdrawn-calendar-records)
- [CFTC contract market directory](https://spiral.ai/integrations/opencode/cftc-contract-market-directory)

## Questions about CFTC commodity futures and options positions in opencode

**Can opencode use CFTC commodity futures and options positions?**

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

**How much does CFTC commodity futures and options positions cost in opencode?**

$0.001746 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 commodity futures and options positions in opencode?**

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

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

**Does opencode wait while CFTC commodity futures and options positions runs?**

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

**Which markets do the disaggregated reports cover?**

They cover agriculture and natural resource contracts. Reportable positions are divided into four categories: Producer/Merchant, Swap Dealers, Managed Money, and Other Reportables.

**How fresh are the positions?**

CFTC generally publishes reports Friday at 3:30 p.m. Eastern using the preceding Tuesday's positions. A newly published report is a weekly snapshot with a reporting lag.

**How far back does disaggregated history go?**

The Public Reporting Environment offers disaggregated data back to 2006. That boundary applies to disaggregated reports even though CFTC's Legacy report history starts earlier.

**Why can a market disappear from a weekly report?**

CFTC removes a contract market when its number of reportable large traders falls below 20. It can appear again once that number reaches at least 20.

**Why can positions appear without a trader count?**

CFTC suppresses a category's trader count when it has fewer than four active traders. The associated position sizes remain public.

