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

dots · Finance

How to Use CFTC commodity index trader positions in dots

Returns combined futures and options positions for selected agricultural markets, separating index traders from commercial and noncommercial traders. Use it to examine commodity index participation that the legacy report includes within broader categories.

Prompts to try with CFTC commodity index trader positions in dots

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

Every Monday, use CFTC commodity index trader positions to update a corn and soybean index participation brief with net positions and shares of open interest.

CFTC commodity index trader positionsdots
Try asking
  • Every Monday at 9am: use CFTC commodity index trader positions to look this up and give me the result as a table.

  • Pull the latest numbers from CFTC commodity index trader positions and tell me what changed since last week.

  • Check CFTC commodity index trader positions and summarize what you find in three bullet points.

  • Pull the newest data from CFTC commodity index trader positions and give me the result as a table.

How to set up CFTC commodity index trader positions in dots

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

Use the Spiral skill

  1. Send dots 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 Spiral's MCP server

  1. Create an API key

    In the console, open API keys and create a key for your dot. Copy it.

  2. Send your dot this message

    Your dot reads Spiral's skill and asks for your API key.

    set up https://spiral.ai/SKILL.md
  3. Give your dot the key

    When your dot asks for the key, add it where your dot keeps secrets, never in the chat itself.

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 index trader 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/supplemental",
        "input": {
          "to": "<to>"
        }
      }'

Then paste one of the prompts above: dots finds CFTC commodity index trader positions on Spiral, shows the price and runs it.

CFTC commodity index trader positions providers and prices

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

AlexandriaFinance
CFTC Commitments of Traders · Supplemental
cftc-gov/commitments-of-traders/supplemental

Settings you can ask for

Ask dots 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 · Supplemental is on its tool page: open its card above.

What can you do with CFTC commodity index trader positions in dots?

Maintain a weekly CFTC watchlist that shows the latest available reporting date and changes in the selected market data. A scheduled agent can refresh contract coverage or positioning summaries as new observations appear.

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.

Agricultural purchasing research

Find the relevant corn, wheat, or coffee contracts and prepare a positioning appendix for a purchasing review. Compare broad commercial activity, managed money, and index trader participation in separate tables.

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.

Agricultural index participation review

Compare index trader positions across selected agricultural contracts. Place the results beside legacy totals and disaggregated trader categories without treating those classifications as interchangeable.

Questions about CFTC commodity index trader positions in dots

Can dots use CFTC commodity index trader positions?

Yes. Add Spiral to dots as an MCP server, and dots can find and run CFTC commodity index trader positions like any built-in tool.

How much does CFTC commodity index trader positions cost in dots?

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

Do I need an Alexandria account to use CFTC commodity index trader positions in dots?

You need no Alexandria account. dots uses one Spiral API key for every tool, and Spiral runs CFTC commodity index trader positions on its own Alexandria account.

How long does it take to set up CFTC commodity index trader positions in dots?

About two minutes: create an API key, then send your dot this message, then give your dot the key.

Does dots wait while CFTC commodity index trader positions runs?

CFTC commodity index trader positions runs in the background. dots 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 commodity index trader positions in dots

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

Paste this into dots:

Set up dots

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