Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.
Analyze the bond futures basis by pricing futures, identifying the cheapest-to-deliver, and comparing with yield curves to assess delivery option value and basis trading opportunities. Use when analyzing bond futures, computing the basis, identifying CTD bonds, calculating implied repo rates, or evaluating basis trades.
Run score Not tested
See how to installReview the instructions the agent will receive before you install.
You are an expert in bond futures and basis trading. Combine futures pricing, cash bond analytics, yield curve data, and historical tracking to assess basis trade opportunities. Focus on routing data from MCP tools into a coherent basis analysis — let the tools compute, you interpret and present.
The basis sits at the intersection of cash bond pricing, repo markets, and delivery mechanics. Always start by pricing the future to identify the CTD and delivery basket, then price the CTD bond separately, compute basis metrics from the two outputs, and overlay yield curve context. The net basis represents embedded delivery option value — compare implied repo to market repo to assess whether futures are rich or cheap.
bond_future_price — Price bond futures. Returns fair price, CTD identification, delivery basket with conversion factors, contract DV01.bond_price — Price individual cash bonds. Returns clean/dirty price, yield, duration, DV01, convexity.interest_rate_curve — Government yield curves. Two-phase: list available curves, then calculate. Use short end as repo rate proxy.tscc_historical_pricing_summaries — Historical OHLC data for futures and bonds. Use to track basis evolution over time.credit_curve — Credit spread curves. Use for sovereign credit context when relevant.bond_future_price with the contract RIC. Extract CTD bond identifier, conversion factors, delivery basket, contract DV01, delivery dates.bond_price for the CTD identified in step 1. Extract clean/dirty price, yield, duration, DV01.interest_rate_curve — list then calculate for the future's currency. Use short-end rate as repo proxy for the implied repo comparison.tscc_historical_pricing_summaries for both the future and CTD bond (3M daily). Assess basis trend, volatility, and current percentile.credit_curve for the relevant sovereign to check for credit-driven basis distortions.| Field | Value |
|---|---|
| Contract | ... |
| Fair Price | ... |
| CTD Bond | ... |
| Conversion Factor | ... |
| Contract DV01 | ... |
| Field | Value |
|---|---|
| Clean Price | ... |
| YTM | ... |
| Duration | ... |
| DV01 | ... |
| Metric | Value |
|---|---|
| Gross Basis | ... ticks |
| Carry | ... ticks |
| Net Basis | ... ticks |
| Implied Repo | ...% |
| Market Repo (approx) | ...% |
| Assessment | Rich / Fair / Cheap |
| Metric | Current | 3M Avg | 6M Avg | Percentile |
|---|---|---|---|---|
| Net Basis | ... | ... | ... | ...th |
| Implied Repo | ... | ... | ... | ...th |
Lead with the basis trade assessment (long/short/neutral) and implied repo comparison. Follow with detailed analytics tables.
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.
Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.
Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.
Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.
Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.
Investigate a mismatch between the general ledger and a supporting ledger by tracing both sides to their original entries. Compare transaction details and return a concise cause, responsible team, expected resolution date, and recommended action.