Dollar-Duration-Neutral Butterfly Trading Strategy Analysis
Analyze dollar-duration-neutral butterfly spreads with Sourcetable AI. Calculate position ratios, hedge duration risk, and visualize complex payoff profiles automatically—no manual formulas required.
Andrew Grosser
February 24, 2026 • 16 min read
Introduction
October 2023: The yield curve shows 2-year at 5.08%, 5-year at 4.65%, 10-year at 4.93%. The belly is 43bps rich to the wings. Classic butterfly setup. The dollar-duration-neutral butterfly is an advanced options strategy that combines the limited-risk profile of a traditional butterfly spread with precise hedging against interest rate movements. Unlike standard butterfly spreads where you buy equal quantities at each strike, this approach adjusts position sizes based on each option's dollar duration to create a portfolio that's neutral to parallel yield curve shifts.
This strategy appeals to sophisticated traders who want to profit from volatility changes or time decay while eliminating directional interest rate risk. You're essentially betting on the shape of the volatility smile or the passage of time, not on whether rates will rise or fall. The challenge? Calculating the precise ratios requires understanding option Greeks, dollar duration calculations, and continuous rebalancing as market conditions change sign up free.
Why Sourcetable for Dollar-Duration-Neutral Butterfly Analysis
Excel forces you to build everything from scratch. You need separate calculations for Black-Scholes pricing, numerical differentiation for Greeks, duration formulas that account for each option's sensitivity to rate changes, and then complex algebra to solve for neutral ratios. When rates move 25 basis points or implied volatility shifts 2 points, you're recalculating everything manually. One formula error in your rho calculation cascades through your entire hedge ratio, potentially exposing you to thousands in unintended rate risk.
Sourcetable's AI understands options mathematics natively. It recognizes that dollar duration equals option price times rho times 0.01 (for a 1 basis point move), and that a duration-neutral position requires the sum of (quantity × dollar duration) across all legs to equal zero. Instead of writing formulas, you describe what you need: 'Show me the position sizes that make this butterfly duration-neutral' or 'What happens to my hedge if volatility increases 5%?'
The platform handles the computational complexity automatically. Upload an options chain with strikes from 90 to 110, specify your butterfly center at 100, and ask for duration-neutral ratios. Sourcetable calculates rho for each strike using current market data, computes dollar duration per contract, and solves the system of equations to find position sizes where duration exposure nets to zero. You see results in seconds, not hours.
Real-time scenario analysis becomes effortless. Ask 'How does my hedge perform if the 10-year yield rises 50 basis points?' and the AI instantly recalculates all Greeks under the new rate environment, shows P&L impact, and tells you whether your neutral positioning holds or needs adjustment. With Excel, this scenario would require manually updating rate inputs across dozens of cells and verifying that all formulas recalculated correctly.
Sourcetable also excels at portfolio-level analysis. Managing five different duration-neutral butterflies across various underlyings means tracking 15 option positions with different durations, deltas, and vegas. Ask 'What's my total portfolio duration exposure?' and the AI aggregates across all positions, identifying any unintended rate bets. This holistic view is nearly impossible to maintain accurately in Excel without significant manual effort and constant vigilance against formula errors.
Benefits of Dollar-Duration-Neutral Butterfly Analysis with Sourcetable
The dollar-duration-neutral butterfly offers sophisticated traders a way to isolate specific market views—betting on volatility changes, time decay, or volatility skew shifts—while eliminating unwanted interest rate exposure. This precision requires accurate calculations that Sourcetable delivers automatically, transforming complex quantitative analysis into conversational queries.
Automated Greek Calculations with Rate Sensitivity
Every option's sensitivity to interest rates (rho) varies based on strike price, time to expiration, and moneyness. An at-the-money call with 90 days to expiration might have a rho of 0.15, meaning its value changes $0.15 per contract for each 1% rate change. Out-of-the-money options have lower rho values, perhaps 0.08 or 0.05. Calculating these manually requires implementing the Black-Scholes rho formula with partial derivatives—a process prone to errors.
Sourcetable computes all Greeks instantly from your options data. Upload a chain showing strikes, premiums, implied volatilities, and time to expiration. Ask 'Calculate rho for all strikes' and receive a complete table showing each option's rate sensitivity. The AI applies industry-standard models automatically, ensuring accuracy without requiring you to remember or implement complex formulas. This foundation enables the critical next step: determining duration-neutral ratios.
- Dollar Duration (DV01): Price change per 1bp move in yield; a 5-year Treasury note with modified duration 4.6 and price 98.50 has DV01 = $98.50 × 4.6 × 0.0001 × 1,000,000 = $4,531 per $1M face value.
- Butterfly DV01 Construction: Long wings + short belly, all legs sized to zero net DV01; if short $10M of 5-year (DV01 $4,531), offset with $2.5M 2-year (DV01 $1,800 each = $4,500) and $14M 10-year (DV01 $320 each ≈ $4,480 total).
- Convexity of Butterfly: Long-maturity bonds have higher convexity than short-maturity; a barbell (wings) has higher convexity than a bullet (belly) at the same duration—the butterfly effectively sells convexity premium.
- Dollar Convexity: Second-order DV01 change; the butterfly position gains convexity as the wings lengthen in a rate rally and shortens in a rate sell-off—tracking dollar convexity daily prevents unexpected sensitivity buildup.
Instant Duration-Neutral Ratio Calculations
A standard butterfly buys one lower strike, sells two middle strikes, and buys one upper strike—a 1:2:1 ratio. But this creates duration exposure because each leg has different rho. Consider a butterfly on a $100 underlying with 95-100-105 strikes, 60 days to expiration, and current rates at 4%. The 95 call might have rho of 0.18, the 100 call rho of 0.14, and the 105 call rho of 0.09.
With a 1:2:1 ratio, your duration exposure would be: (1 × $100 × 0.18 × 0.01) + (-2 × $100 × 0.14 × 0.01) + (1 × $100 × 0.09 × 0.01) = $0.18 - $0.28 + $0.09 = -$0.01 per basis point rate change. That seems small, but with 100 butterflies, you have $1 exposure per basis point, or $100 for a typical 100 basis point rate move—unintended directional risk.
Sourcetable solves for true neutral ratios automatically. Ask 'What position sizes make this butterfly duration-neutral?' and the AI determines that you might need to buy 1.2 of the 95 strike, sell 2.0 of the 100 strike, and buy 0.8 of the 105 strike to achieve zero net duration. These fractional ratios, scaled up to actual contract quantities, eliminate rate exposure while maintaining the butterfly's core profit profile. This calculation, which would take 20 minutes in Excel with multiple formula iterations, happens in seconds.
- 2s5s10s Butterfly Ratio: Determine weights so that DV01_short_5yr = DV01_long_2yr + DV01_long_10yr; typical ratio is 0.5 : -1.0 : 0.5 in notional for near-equal maturity spacing but must be recalculated when yields shift.
- Curvature Measure: 2 × yield_5yr - yield_2yr - yield_10yr; in October 2023, this equals 2×4.65 - 5.08 - 4.93 = -0.71%, meaning the belly is 71bps cheap to the wings (a negative butterfly).
- Carry of Butterfly: The butterfly P&L from time passing (roll-down) is the steepening of both wings minus the change in the belly; a positively-sloped curve earns carry on the wings but pays on the belly—net carry depends on exact slope differentials.
- Rebalancing Frequency: DV01 drifts as yields change; at 50bp yield moves, butterfly ratios deviate by 5–8% from target; rebalancing monthly keeps tracking error below 0.3% annualized, while weekly rebalancing reduces it to 0.1%.
Real-Time Rebalancing Recommendations
Duration neutrality isn't static. As time passes, underlying price moves, or rates change, each option's rho shifts, throwing your carefully balanced position out of alignment. A butterfly that was perfectly neutral at initiation might develop $500 of rate exposure after just a 2% move in the underlying or a 25 basis point rate change. Professional traders rebalance regularly, but calculating when and how much to adjust is computationally intensive.
Sourcetable monitors your positions continuously. Upload updated market data daily or even intraday, then ask 'Is my butterfly still duration-neutral?' The AI recalculates all Greeks with current prices and rates, compares your actual position to the theoretically neutral ratios, and tells you exactly what adjustments to make. 'Your position now has +$0.15 duration per basis point. Sell 3 more contracts of the 95 strike to rebalance.' This ongoing guidance keeps your strategy aligned with your intended market view.
- Yield Curve Regime: Butterflies perform best when yield curve curvature is mean-reverting; flat or trending curvature regimes cause repeated stop-outs—test for stationarity before committing to butterfly positions.
- Fed Meeting Timing: FOMC meetings create parallel shifts that don't help the butterfly; but surprise rate paths (hawkish or dovish pivots) cause non-parallel curve moves that generate butterfly P&L—position sizing should increase around uncertain Fed meetings.
- Transaction Costs: Executing three legs in Treasuries costs 0.3–0.8bps per leg = 1–2.4bps total; the butterfly curvature target should exceed 3x this threshold to be worth entering.
- Correlation to Rates: Dollar-duration-neutral butterflies have near-zero sensitivity to parallel rate shifts but full sensitivity to curvature changes; use them to isolate a curvature view without taking directional rate risk.
Comprehensive Scenario Analysis
Understanding how your duration-neutral butterfly performs under various market conditions is crucial for risk management. What happens if rates rise 100 basis points while volatility drops 3 points? What if the underlying rallies 10% while rates stay flat? Excel scenario analysis requires copying your entire model, changing inputs, and comparing results—a tedious process that limits the number of scenarios you'll actually test.
With Sourcetable, scenario testing is conversational. Ask 'Show P&L if rates increase 50 bps and underlying moves to $105' and receive instant results showing how each leg revalues, whether your neutral positioning holds, and your net profit or loss. Run dozens of scenarios in minutes: 'Test rate changes from -50 to +100 bps in 25 bp increments with underlying from $95 to $110.' The AI generates a complete sensitivity matrix showing exactly where your strategy profits and where it struggles.
Visual Risk Profile Generation
Duration-neutral butterflies have complex payoff profiles that change with time and market conditions. Unlike simple long stock or covered calls, visualizing the profit/loss across different underlying prices, rate environments, and time horizons requires sophisticated charting. Excel users spend hours formatting charts, ensuring data ranges update correctly, and creating multiple views for different scenarios.
Sourcetable generates professional visualizations automatically. Ask 'Show me the payoff diagram at expiration' and receive a chart displaying P&L across the underlying price range, with your maximum profit zone clearly marked. Request 'Graph P&L versus time for current underlying price' to see how theta decay affects your position daily. Want to see rate sensitivity? Ask 'Chart P&L versus interest rate changes' and instantly visualize how your supposedly neutral position performs if rates move unexpectedly—helping you verify your hedge is working as intended.
How Dollar-Duration-Neutral Butterfly Analysis Works in Sourcetable
Implementing a dollar-duration-neutral butterfly in Sourcetable follows a streamlined workflow that eliminates manual calculations while maintaining complete analytical rigor. The platform handles the quantitative complexity, letting you focus on strategy and risk management decisions.
Step 1: Import Options Chain Data
Start by uploading your options chain data into Sourcetable. This typically includes strike prices, call and put premiums, bid-ask spreads, implied volatilities, open interest, and time to expiration. You can import directly from your broker's CSV export, paste from another spreadsheet, or connect to live market data feeds if available. The AI recognizes standard options data formats automatically, identifying which columns contain strikes, premiums, and Greeks.
Include current market context: underlying price, current risk-free rate, and dividend yield if applicable. For a stock trading at $98.50 with 3-month Treasury rates at 4.25% and no dividends, enter these parameters once. Sourcetable uses them across all subsequent calculations, ensuring consistency. If you're analyzing multiple underlyings, create separate sheets or tables for each, and the AI tracks context appropriately.
- Start by uploading your options chain data into Sourcetable.
- Include current market context: underlying price, current risk-free rate, and di.
Step 2: Define Your Butterfly Structure
Tell Sourcetable which butterfly you want to analyze using natural language. 'Create a call butterfly with strikes at 95, 100, and 105' or 'Analyze a put butterfly centered at 100 with 5-point wings.' The AI identifies the relevant options from your data and sets up the basic structure—buying the lower strike, selling two middle strikes, buying the upper strike for a call butterfly (or the inverse for puts).
You can specify expiration dates if working with multiple expirations. 'Use the March 17 expiration calls' ensures the AI selects the correct options from your chain. The platform displays your selected strikes, their current premiums, and the standard 1:2:1 cost basis for reference. This baseline helps you understand how the duration-neutral adjustment will modify position sizes and costs.
Step 3: Calculate Duration-Neutral Ratios
Now request the critical calculation: 'Make this butterfly dollar-duration-neutral.' Sourcetable's AI computes rho for each strike using the Black-Scholes model or other pricing models appropriate for your options type. It calculates dollar duration for each leg (option price × rho × 0.01 × contract multiplier), then solves the system of equations to find position quantities where the sum of (quantity × dollar duration) equals zero.
The AI presents results clearly: 'To achieve duration neutrality, use ratios of 1.18 : 2.00 : 0.82 for the 95-100-105 strikes.' It shows the dollar duration of each leg and confirms the net exposure is zero or within acceptable tolerance (typically under $0.01 per basis point). You see both the theoretical fractional ratios and practical whole-number contract quantities. For a 10-lot butterfly, that might translate to buying 12 of the 95 strike, selling 20 of the 100 strike, and buying 8 of the 105 strike.
- "Make this butterfly dollar-duration-neutral."
- The AI presents results clearly: 'To achieve duration neutrality, use ratios of .
Step 4: Analyze Cost and Risk Metrics
With position sizes determined, Sourcetable calculates your total investment and risk metrics. 'What's the cost to enter this position?' returns the net debit or credit based on current market prices and your duration-neutral quantities. If the 95 call costs $6.20, the 100 call $3.50, and the 105 call $1.80, the AI computes: (12 × $6.20) - (20 × $3.50) + (8 × $1.80) = $74.40 - $70.00 + $14.40 = $18.80 per butterfly, times the $100 contract multiplier = $1,880 total cost.
Request comprehensive Greeks: 'Show me delta, gamma, vega, and theta for this position.' The AI aggregates across all legs, displaying net position Greeks. You might see delta of +0.05 (near-neutral directional exposure), gamma of +0.08 (positive convexity), vega of -0.12 (short volatility exposure), and theta of +0.03 (positive time decay). These metrics reveal your actual market exposures beyond just interest rate neutrality, helping you understand the complete risk profile.
Step 5: Run Scenario Analysis and Visualization
Test how your strategy performs under various conditions. Ask 'What's my P&L if the underlying closes at $102 at expiration?' Sourcetable calculates intrinsic values for each leg at that price, multiplies by your duration-neutral quantities, and returns your profit or loss. For a butterfly centered at 100, closing at 102 captures significant value—perhaps $800 profit on your $1,880 investment, a 42% return.
Expand analysis with multi-variable scenarios: 'Show P&L across underlying prices from $90 to $110 and rate changes from -50 to +50 basis points.' The AI generates a matrix showing how your position performs in each combination, confirming that rate changes have minimal impact (validating your duration hedge) while underlying price drives returns. This comprehensive view, which would require hours of Excel work, appears in seconds.
Request visualizations for clearer understanding: 'Create a payoff diagram at expiration' produces a chart showing your classic butterfly profit profile—maximum gain at the $100 center strike, declining to breakeven around $97 and $103, and maximum loss (your initial debit) outside those points. 'Graph how P&L changes with time' shows theta decay working in your favor as expiration approaches, assuming the underlying stays near your target.
Step 6: Monitor and Rebalance
As markets move, update your data and reassess neutrality. Upload new options prices after a week or whenever significant moves occur. Ask 'Is my position still duration-neutral?' and Sourcetable recalculates all Greeks with current data, comparing your actual holdings to the theoretically neutral ratios under new market conditions.
If rebalancing is needed, the AI provides specific instructions: 'Your position now has -$0.22 duration per basis point due to the underlying moving to $103 and rates increasing 30 basis points. Buy 4 additional contracts of the 105 strike to restore neutrality.' This ongoing guidance ensures your strategy maintains its intended risk profile throughout the trade's life, adapting to market changes without requiring you to rebuild models or recalculate ratios manually.
Real-World Use Cases for Dollar-Duration-Neutral Butterflies
Dollar-duration-neutral butterflies serve specific trading objectives where isolating particular market factors is crucial. These use cases demonstrate when this advanced strategy provides advantages over simpler alternatives and how Sourcetable facilitates implementation.
Volatility Skew Trading
Options traders often identify mispricings in the volatility skew—the pattern of implied volatilities across different strikes. You might observe that out-of-the-money puts are trading at 22% implied volatility while at-the-money options trade at 18% IV, suggesting puts are overpriced relative to calls. A standard butterfly profits if volatility at the center strike increases relative to the wings, but it also carries unwanted rate exposure that could overwhelm your volatility bet.
With Sourcetable, structure a duration-neutral butterfly to isolate the skew trade. Upload your options chain showing the volatility skew, then ask 'Create a duration-neutral butterfly to profit from skew flattening.' The AI calculates position sizes that eliminate rate risk, letting your P&L depend purely on whether the skew changes as you anticipate. If the skew flattens (wing IVs decrease relative to center), you profit regardless of whether rates rise or fall. Track this by asking 'Show my vega exposure by strike' to confirm you're long vega at the center and short at the wings—the exact profile for a skew flattening bet.
Earnings Announcement Volatility Plays
Before major earnings announcements, implied volatility typically increases as uncertainty rises, then collapses immediately after results are released—a phenomenon called volatility crush. Traders sell options to capture this collapse, but directional risk is significant since earnings can move stocks 10% or more. A butterfly limits directional risk while profiting from volatility decline, but standard butterflies still carry rate exposure that's undesirable during volatile periods.
Use Sourcetable to implement a duration-neutral butterfly centered at the current stock price before earnings. If a $150 stock has earnings in two weeks, create a 145-150-155 butterfly with duration-neutral ratios. Ask 'What's my P&L if the stock stays at $150 and volatility drops 8 points post-earnings?' The AI shows you capturing significant theta and vega gains—perhaps $1,200 on a $2,500 investment—while rate changes during the holding period have minimal impact. This precision lets you focus on your volatility view without worrying about concurrent Fed announcements or rate market movements.
Range-Bound Market Income Generation
When technical analysis suggests a stock will trade in a tight range, butterflies generate income from time decay while limiting risk if you're wrong about the range. A stock consolidating between $98 and $102 for three weeks is a perfect candidate. However, if interest rates are volatile—perhaps during a period of frequent Fed communications—you want to eliminate rate sensitivity so your range-bound bet isn't disrupted by macro factors.
Sourcetable helps you structure this precisely. Create a duration-neutral butterfly centered at $100, the midpoint of your expected range. Ask 'Show daily P&L if the underlying stays between $99 and $101 for 30 days.' The AI projects your theta gains accumulating steadily—perhaps $40-50 per day on a 20-lot position—while confirming that rate movements during this period won't significantly impact results. Request 'Alert me if duration exposure exceeds $0.50' to monitor whether rebalancing is needed, ensuring your income strategy stays focused on time decay rather than inadvertently becoming a rate bet.
Portfolio Hedging with Defined Risk
Institutional traders managing large portfolios sometimes use butterflies as tactical hedges with defined risk. Unlike buying puts (expensive) or selling calls (unlimited risk), butterflies offer asymmetric payoffs with known maximum loss. But when hedging a portfolio that's already duration-managed, adding rate exposure through a standard butterfly defeats the purpose of your existing hedging program.
With Sourcetable, implement duration-neutral butterflies that provide directional protection without disrupting your interest rate positioning. If your portfolio has $2 million of duration exposure that's intentionally hedged to zero, ask 'Create a duration-neutral butterfly on SPY to hedge against a 5% decline.' The AI structures a put butterfly—perhaps 440-450-460 strikes with adjusted ratios—that profits if markets decline into that range while maintaining your portfolio's overall duration neutrality. Query 'What's my combined portfolio duration including this hedge?' to verify the butterfly doesn't create unintended rate exposure, keeping your risk management framework intact.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsWhat is a duration-neutral butterfly trade in fixed income?
How do you size the three legs of a butterfly trade?
What market conditions make a long-wing butterfly profitable?
What is the 'Nelson-Siegel' framework for butterfly trade analysis?
What is the difference between a bond butterfly and a duration-weighted butterfly?
How do you determine whether the current yield curve curvature represents value?
What is a typical holding period and expected return for a butterfly trade?
