How to Use CFTC contract market directory in opencode
Returns contract markets with exchange codes, commodity classifications, available report dates, and row counts. Use it to distinguish similarly named contracts and check their available history before requesting positions.
Prompts to try with CFTC contract market directory in opencode
Copy an example into opencode, or ask in your own words.
Use CFTC contract market directory to create a reference table in this project for wheat markets, including exchange, contract code, earliest report date, and latest report date.
Use CFTC contract market directory to look this up and give me the result as a table. Save the result in ./assets.
Pull the latest numbers from CFTC contract market directory and tell me what changed since last week.
Check CFTC contract market directory and summarize what you find in three bullet points.
Pull the newest data from CFTC contract market directory and give me the result as a table.
How to set up CFTC contract market directory 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 contract market directory
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/markets", "input": { "report": "legacy_futures_only" } }'
Then paste one of the prompts above: opencode finds CFTC contract market directory on Spiral, shows the price and runs it.
CFTC contract market directory providers and prices
Spiral runs CFTC contract market directory 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 |
|---|---|---|---|
| Report | legacy_futures_only, legacy_combined, disaggregated_futures_only, disaggregated_combined, tff_futures_only, tff_combined, or supplemental | Which dataset to list contract markets for. | |
| Page size | 1 to 500 | 100 | page_size |
Every API field of CFTC Commitments of Traders · Markets is on its tool page: open its card above.
What can you do with CFTC contract market directory 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.
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.
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.
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 contract market directory and opencode
Overview
CFTC contract market directory in other agents
Questions about CFTC contract market directory in opencode
Can opencode use CFTC contract market directory?
Yes. Add Spiral to opencode as an MCP server, and opencode can find and run CFTC contract market directory like any built-in tool.
How much does CFTC contract market directory 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 contract market directory in opencode?
No. Spiral runs CFTC contract market directory 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 contract market directory in opencode?
About two minutes: add the server, then sign in, then check it.
Does opencode wait while CFTC contract market directory runs?
CFTC contract market directory 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 contract market directory 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


