Spiral gives your agent every tool with one account. Browse the tools →

Claude Code · Finance

How to Use CFTC commodity futures and options positions in Claude Code

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.

Prompts to try with CFTC commodity futures and options positions in Claude Code

Copy an example into Claude Code, or ask in your own words.

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.

CFTC commodity futures and options positionsClaude Code
Try asking
  • 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 Claude Code

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

Use Spiral's MCP server

  1. Add the hosted server

    This adds Spiral to the current project. Add --scope user to use it in every project.

    claude mcp add --transport http spiral https://api.spiral.ai/mcp
  2. Sign in

    Start claude, type /mcp, choose spiral and Authenticate. Sign in to Spiral in the browser and click Authorize. No API key.

Use the Spiral skill

  1. Send Claude Code 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.

    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.

    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: Claude Code finds CFTC commodity futures and options positions on Spiral, shows the price and runs it.

CFTC commodity futures and options positions providers and prices

Spiral runs CFTC commodity futures and options positions through Alexandria. Open a card for today's price, with every fee included.

AlexandriaFinance

Settings you can ask for

Ask Claude Code for any of these in your prompt.

SettingAllowed valuesDefaultDescription
$limita number1000

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.

$offseta number

Rows to skip, for paging past $limit.

Every API field of CFTC · Disaggregated report, futures and options combined is on its tool page: open its card above.

What can you do with CFTC commodity futures and options positions in Claude Code?

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.

Questions about CFTC commodity futures and options positions in Claude Code

Can Claude Code use CFTC commodity futures and options positions?

Yes. Add Spiral to Claude Code as an MCP server, and Claude Code 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 Claude Code?

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

Do I need an Alexandria account to use CFTC commodity futures and options positions in Claude Code?

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 Claude Code?

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

Does Claude Code wait while CFTC commodity futures and options positions runs?

CFTC commodity futures and options positions runs in the background. Claude Code 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.

Get started

Start using CFTC commodity futures and options positions in Claude Code

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Claude Code:

Set up Claude Code

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options