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

opencode · Finance

How to Use CFTC financial futures positions in opencode

Returns financial futures positions split among dealers, asset managers, leveraged funds, and other reportable traders. Use it to compare institutional categories in currency, interest rate, or equity index futures without options exposure.

Prompts to try with CFTC financial futures positions in opencode

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

Use CFTC financial futures positions to add a Euro FX chart to this project comparing asset manager and leveraged fund net positions throughout 2025.

CFTC financial futures positionsopencode
Try asking
  • Use CFTC financial 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 financial futures positions and tell me what changed since last week.

  • Check CFTC financial futures positions and summarize what you find in three bullet points.

  • Pull the newest data from CFTC financial futures positions and give me the result as a table.

How to set up CFTC financial 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.

    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.

    opencode mcp auth spiral
  3. Check it

    Spiral shows as connected.

    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.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run CFTC financial futures 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-gov/commitments-of-traders/tff_futures_only",
        "input": {
          "to": "<to>"
        }
      }'

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

CFTC financial futures positions providers and prices

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

AlexandriaFinance
CFTC Commitments of Traders · Tff futures only
cftc-gov/commitments-of-traders/tff_futures_only

Settings you can ask for

Ask opencode for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Sortrecent_first or oldest_firstrecent_first

Order by report date then id. The upstream default order is undefined, so an order is always sent.

Page size1 to 1000100

Rows per page (a legacy row is ~4.7 KB, a disaggregated row ~7 KB).

Every API field of CFTC Commitments of Traders · Tff futures only is on its tool page: open its card above.

What can you do with CFTC financial 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.

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.

Questions about CFTC financial futures positions in opencode

Can opencode use CFTC financial futures positions?

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

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

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

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

Does opencode wait while CFTC financial futures positions runs?

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

Get started

Start using CFTC financial futures positions in opencode

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

Paste this into opencode:

Set up opencode

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