[Integrations](https://spiral.ai/integrations) › [Gemini CLI](https://spiral.ai/integrations/gemini-cli) › [CFTC commodity futures positions](https://spiral.ai/integrations/gemini-cli/cftc-commodity-futures-positions)

# How to Use CFTC commodity futures positions in Gemini CLI

Returns weekly commodity futures positions by trader category, including longs, shorts, open interest, and weekly changes. Use it to study futures positioning without the options exposure included in the combined report.

|  |  |
| --- | --- |
| Model | CFTC commodity futures 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 positions in Gemini CLI

- Use CFTC commodity futures positions to fetch five years of COMEX gold observations and add a chart of managed-money longs, shorts, and net positions to this project's dashboard.
- Use CFTC commodity futures positions to retrieve CBOT corn observations for 2024 and 2025, then create a CSV in this project with producer and merchant positions, managed-money positions, and open interest.
- Use CFTC commodity futures positions to retrieve two years of COMEX gold concentration measures and add a view comparing the largest four and eight traders on gross long and gross short positions.
- Use CFTC commodity 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 commodity futures positions and tell me what changed since last week.

## How to set up CFTC commodity futures positions in Gemini CLI

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

### Use Spiral's MCP server

1. **Add the server**: Or add it to `~/.gemini/settings.json` yourself:

```bash
gemini mcp add --scope user --transport http spiral https://api.spiral.ai/mcp
```

2. **Sign in**: Start `gemini` and run:

```text
/mcp auth spiral
```

3. **Check it**: In Gemini CLI, run `/mcp`. From your shell:

```bash
gemini mcp list
```

### Use the Spiral skill

1. **Send Gemini CLI 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 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/futures-only",
    "input": {
      "$limit": 1000
    }
  }'
```

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

Setup guide in the docs: https://spiral.ai/docs/quickstarts/gemini-cli

## CFTC commodity futures positions tools and prices

- [CFTC · Disaggregated report, futures only](https://spiral.ai/tools/alexandria/cftc/disaggregated/futures-only) (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 positions in Gemini CLI?

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 Gemini CLI guides](https://spiral.ai/integrations/gemini-cli)

## CFTC commodity futures positions in other agents

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

## More Gemini CLI guides

- [CFTC commodity futures and options positions](https://spiral.ai/integrations/gemini-cli/cftc-commodity-futures-and-options-positions)
- [CFTC commodity index trader positions](https://spiral.ai/integrations/gemini-cli/cftc-commodity-index-trader-positions)
- [CFTC Financial futures report, futures only](https://spiral.ai/integrations/gemini-cli/cftc-financial-futures-report-futures-only)
- [CFTC contract market directory](https://spiral.ai/integrations/gemini-cli/cftc-contract-market-directory)
- [CFTC Financial futures report, futures and options combined](https://spiral.ai/integrations/gemini-cli/cftc-financial-futures-report-futures-and-options-combined)
- [CFTC disaggregated futures and options positions](https://spiral.ai/integrations/gemini-cli/cftc-disaggregated-futures-and-options-positions)

## Questions about CFTC commodity futures positions in Gemini CLI

**Can Gemini CLI use CFTC commodity futures positions?**

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

**How much does CFTC commodity futures positions cost in Gemini CLI?**

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

**Do I need an Alexandria account to use CFTC commodity futures positions in Gemini CLI?**

No. Spiral runs CFTC commodity 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 commodity futures positions in Gemini CLI?**

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

**Does Gemini CLI wait while CFTC commodity futures positions runs?**

CFTC commodity futures positions runs in the background. Gemini CLI 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.

