- Home
- Skills
- Trading & Investing
- Futures Rollover & Basis Analyst
Works with the AI Agents you already use
Futures Rollover & Basis Analyst
Evaluates futures expiry cycles, rollover activity, open-interest shifts, and futures-cash basis from market data.
$50
Futures Rollover & Basis Analyst
Example session with this skill installed
Analyze the rollover for ES Z4 and ES H5. ES Z4: Price 5920, OI 2.1M. ES H5: Price 5985, OI 850k. Cash Index: 5915. Current OI change: Z4 down 150k, H5 up 200k. Volume split is 70/30.
- Read your context and instructions
- Compiled the futures rollover
I have analyzed the provided data for the E-mini S&P 500 (ES) December (Z4) and March (H5) contracts.
Futures Rollover & Basis Analysis Report
Data overview
- Underlying and exchange: E-mini S&P 500 (ES)
- Expiring contract: Dec 2024 (Z4)
- Next contract: Mar 2025 (H5)
- Cash/spot price: 5915.00
- Futures prices: Z4 @ 5920.00 | H5 @ 5985.00
- OI units: Contracts
- Data quality notes: Snapshot provided; historical comparison window not specified.
Rollover analysis
- Expiring (Z4) OI: 2,100,000 (-150,000 change)
- Next-month (H5) OI: 850,000 (+200,000 change)
- Total OI (Z4+H5): 2,950,000
- Rollover Percentage: 28.81%
- Volume Split: 70% (Z4) / 30% (H5)
- Formula: H5 OI / (Z4 OI + H5 OI)
Futures-cash basis
- Z4 Basis: +5.00 points (0.08%)
- H5 Basis: +70.00 points (1.18%)
- Status: Markets in Contango (Premium to cash).
OI and price interpretation
Z4 (Expiring): Price is flat/up while OI is down 150k. This is consistent with long liquidation or position closing ahead of expiry.
- H5 (Next-month): OI is up 200k on higher price, suggesting new position established in the forward month.
Combined: Total OI across both months increased by 50k, suggesting a net increase in market participation despite the rollover.
Key insights
The rollover is currently at 28.81%, indicating early-to-mid stage migration. H5 is gaining OI faster than Z4 is losing it, resulting in a net OI build of 50k contracts. The significant 70-point basis in H5 reflects the cost of carry/dividend expectations for the Q1 period.
Conditional scenarios
- Bullish: Continuation of H5 OI build with widening basis would suggest aggressive long positioning.
- Neutral: Rollover stabilizes at 30% volume with narrow price range.
- Bearish: A sharp contraction in total OI (Z4+H5) while price declines would suggest broad market deleveraging.
Next steps
- Monitor the 50% rollover threshold to identify the liquidity "crossover" point.
- Verify if the 50k net OI build aligns with historical volume trends for this expiry week.
- Compare the 70-point H5 basis against the theoretical fair value based on current interest rates.
Connects securely to your tools. The creator never sees your data.
About this skill
Manual tracking of futures rollover is prone to calculation errors and missed signals during the expiry window. This skill automates the evaluation of contract migration, open interest (OI) shifts, and the basis relationship between futures and cash markets.
What it does
- Rollover calculation determines the percentage of liquidity migration from expiring to next-month contracts.
- Basis tracking monitors the price delta between futures and spot prices to identify premiums or discounts.
- OI sentiment mapping interprets price and open interest changes to flag potential long liquidation or short covering.
- Expiry context analysis evaluates time remaining and liquidity concentration across the curve.
- Comparative reporting generates structured summaries of volume distribution and contract-specific volatility.
How it works
- Data intake starts when you provide contract months, prices, OI snapshots, and cash prices via text or CSV.
- Validation checks for unit consistency, timestamp alignment, and contract specification matches.
- Metric generation calculates the rollover ratio, basis points, and OI deltas using explicit formulas.
- Conditional interpretation maps data combinations to market heuristics and historical comparisons.
Frameworks & tools
This skill operates as a logic-driven analytical layer for futures market data. It processes raw exchange data, CSV exports, or pasted terminal tables. It is designed for use within LLM environments that support quantitative reasoning and structured reporting.
Why this beats prompting it yourself
Generic prompts often hallucinate rollover formulas or fail to distinguish between OI lots and contracts. This skill enforces strict arithmetic checks, ensures timestamp alignment, and requires explicit formula disclosure to prevent misleading basis interpretations.
Use cases
- Analyze liquidity migration patterns during quarterly futures expiry cycles.
- Monitor the futures-cash basis for contango or backwardation shifts.
- Screen OI and price divergence to identify potential trend exhaustion.
- Compare current rollover velocity against historical benchmarks.
Known limitations
Does not provide real-time data feeds or trade execution. Requires manual data input or connected data tools. Cannot infer trader intent or predict market direction with certainty.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Trading & Investing.
Requires manual data input or external tool access for prices/OI. Does not execute trades. Analysis is limited to user-supplied contract windows.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 16 days ago
Permissions
No special permissions declared or detected