How to Use CFTC commodity index trader positions in opencode
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 opencode
Copy an example into opencode, or ask in your own words.
Use CFTC commodity index trader positions to build a 2025 corn and soybean comparison showing index trader net positions as a percentage of open interest.
Use CFTC commodity index trader 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 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 opencode
Pick the way that suits you. Each takes about two minutes.
Use Spiral's MCP server
- 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
- 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
- Check it
Spiral shows as connected.
opencode mcp list
Use the Spiral skill
- Send opencode this message
Your agent reads Spiral's skill and sets itself up.
set up https://spiral.ai/SKILL.md
- Sign in or paste a key
Approve Spiral in the browser, or give the agent a key from the console.
Use the Spiral CLI
- 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
- Create an API key
In the console, under API keys.
- 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: opencode 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.
Settings you can ask for
Ask opencode for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Sort | recent_first or oldest_first | recent_first | Order by report date then id. The upstream default order is undefined, so an order is always sent. |
| Page size | 1 to 1000 | 100 | 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 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.
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.
More on CFTC commodity index trader positions and opencode
Overview
CFTC commodity index trader positions in other agents
Questions about CFTC commodity index trader positions in opencode
Can opencode use CFTC commodity index trader positions?
Yes. Add Spiral to opencode as an MCP server, and opencode can find and run CFTC commodity index trader positions like any built-in tool.
How much does CFTC commodity index trader 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 commodity index trader positions in opencode?
No. Spiral runs CFTC commodity index trader 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 index trader positions in opencode?
About two minutes: add the server, then sign in, then check it.
Does opencode wait while CFTC commodity index trader positions runs?
CFTC commodity index trader 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.
Start using CFTC commodity index trader positions in opencode
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into opencode:
set up https://spiral.ai/SKILL.md


