[Integrations](https://spiral.ai/integrations) › [Gemini](https://spiral.ai/integrations/gemini) › [CFTC futures positioning](https://spiral.ai/integrations/gemini/cftc-futures-positioning)

# How to Use CFTC futures positioning in Gemini

Returns futures-only open interest and positions split into commercial, non-commercial, and nonreportable categories. Use it for futures positioning studies and historical comparisons using CFTC archives extending back to 1986.

|  |  |
| --- | --- |
| Model | CFTC futures positioning |
| 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 futures positioning in Gemini

- Use CFTC futures positioning to summarize the latest COMEX gold report with commercial and non-commercial long and short positions, net positions, and open interest.
- Use CFTC futures positioning to compare the latest CBOT corn non-commercial net position with its range over the last three years.
- Use CFTC futures positioning to make a table of NYMEX WTI crude oil open interest and reportable trader counts for the last 12 available report dates.
- Use CFTC futures positioning to look this up and give me the result as a table.
- Pull the latest numbers from CFTC futures positioning and tell me what changed since last week.

## How to set up CFTC futures positioning in Gemini

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

### Use the Gemini connector

1. **Open Connected Apps**: On your computer, go to gemini.google.com. At the bottom, click Settings › Connected Apps. If you don't see Connected Apps, click Personal Intelligence first, then Connected Apps.

2. **Add Spiral as a custom app**: Under Custom apps, click Add a custom app and paste this MCP server URL:

```text
https://api.spiral.ai/mcp
```

3. **Sign in to Spiral and approve**: Follow the on-screen instructions. Spiral opens: sign in, pick the organization and click Authorize. No API key.

### Use the Spiral skill

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

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

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

## CFTC futures positioning tools and prices

- [CFTC · Legacy report, futures only](https://spiral.ai/tools/alexandria/cftc/legacy/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 futures positioning in Gemini?

Get a weekly positioning brief for gold, crude oil, or corn with the underlying long and short totals. A chat app can calculate net positions and explain how the latest observation compares with earlier reports.

### Weekly gold positioning brief

Summarize COMEX gold commercial and non-commercial long and short positions, their changes, and open interest for the latest two report dates.

### Historical positioning range

Calculate where the latest non-commercial net position sits within five years of observations for the same gold market and reporting basis.

### Crude oil positioning monitor

Follow commercial and non-commercial long-minus-short positions in NYMEX WTI crude oil and flag changes that exceed a chosen threshold.

### Concentration review

Compare the reported concentration of positions held by the largest four and eight traders in COMEX gold across recent report dates.

### Corn crop-year comparison

Compare old-crop and other-crop positions for CBOT corn where those breakdowns are available, keeping them separate from the all-contract totals.

### Market participation review

Compare open interest and reportable trader counts for a selected market over a year to describe changes in participation.

### Options contribution comparison

Compare combined and futures-only positions for the same COMEX gold market and date. Describe the difference as a futures-equivalent comparison rather than an options contract count.

## Overview

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

## CFTC futures positioning in other agents

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

## More Gemini guides

- [CFTC futures and options positioning](https://spiral.ai/integrations/gemini/cftc-futures-and-options-positioning)
- [CFTC index trader positions](https://spiral.ai/integrations/gemini/cftc-index-trader-positions)
- [CFTC financial futures positions](https://spiral.ai/integrations/gemini/cftc-financial-futures-positions)
- [CFTC legacy futures and options positions](https://spiral.ai/integrations/gemini/cftc-legacy-futures-and-options-positions)
- [CFTC financial futures and options positions](https://spiral.ai/integrations/gemini/cftc-financial-futures-and-options-positions)
- [CFTC legacy futures positions](https://spiral.ai/integrations/gemini/cftc-legacy-futures-positions)

## Questions about CFTC futures positioning in Gemini

**Can Gemini use CFTC futures positioning?**

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

**How much does CFTC futures positioning cost in Gemini?**

$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 plan is separate.

**Do I need an Alexandria account to use CFTC futures positioning in Gemini?**

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

About two minutes: open Connected Apps, then add Spiral as a custom app, then sign in to Spiral and approve.

**Does Gemini wait while CFTC futures positioning runs?**

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

**How fresh are CFTC positions?**

Reports generally publish Friday at 3:30 p.m. Eastern and describe positions from the preceding Tuesday. Holidays can move publication, so the latest report is a dated snapshot.

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

CFTC drops a market when the number of reportable large traders falls below 20. It can appear again when that number returns to at least 20.

**What do the commercial and non-commercial categories mean?**

Legacy reports split reportable traders into these two categories and organize the data by exchange. They describe trader classifications rather than identifying individual trades.

**Does the combined report count options contracts directly?**

It converts options positions into futures equivalents using delta factors supplied by exchanges. A combined position therefore measures a different basis from a count of futures contracts alone.

**What concentration data is available?**

Long-format reports include concentration measures for the largest four and eight traders. They also include crop-year breakdowns where appropriate.

