Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Futures Rollover & Basis Analyst

    1

    Evaluates futures expiry cycles, rollover activity, open-interest shifts, and futures-cash basis from market data.

    $50

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Futures Rollover & Basis Analyst

    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

    1. Monitor the 50% rollover threshold to identify the liquidity "crossover" point.
    2. Verify if the 50k net OI build aligns with historical volume trends for this expiry week.
    3. 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

    1. Data intake starts when you provide contract months, prices, OI snapshots, and cash prices via text or CSV.
    2. Validation checks for unit consistency, timestamp alignment, and contract specification matches.
    3. Metric generation calculates the rollover ratio, basis points, and OI deltas using explicit formulas.
    4. 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.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    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

    Listed16 days ago

    What's inside

    Frequently Asked Questions

    This skill automates the tracking of contract migration, open interest shifts, and price basis, eliminating the manual calculation errors and missed signals common during volatile expiry windows.

    The skill is designed for use within LLM environments that support quantitative reasoning and structured data processing; you simply need to provide contract data via text or CSV to begin the analysis.

    The skill calculates the rollover ratio (liquidity migration %), basis points (futures-cash delta), and OI deltas, mapping these against market heuristics to identify trends like long liquidation or short covering.

    The skill includes the specialized logic-driven analytical layer, structured reporting templates, and the specific arithmetic frameworks required to interpret futures curve dynamics accurately.

    No, this skill is a logic-driven analytical tool that requires you to input raw exchange data, CSV exports, or terminal tables to perform its evaluations.

    By enforcing strict arithmetic checks and explicit formula disclosure, this skill prevents the common 'hallucinations' and unit errors that occur when using generic AI prompts for complex futures math.

    New in Trading & Investing