Portfolio to Hedge
$
Weighted average beta vs benchmark
Hedge Instrument
$
units
S&P 500 E-Mini = 50 | ETF = 1
Hedge Target
0 = full hedge | 0.5 = 50% hedged | 1 = no change
Hedge Ratio (Contracts / Units)
Enter portfolio and hedge instrument details
Hedge Ratio (Raw)
Hedge Notional Value
Hedge Coverage %
Beta Reduction
Effective Beta After Hedge
Contract Value (each)
Hedge Cost Estimate
Hedge Quality
Portfolio Exposure: Unhedged vs Hedged

What each tab calculates

01

Beta Hedge

Calculates the number of futures contracts or ETF shares to short using the beta hedge formula: N = (β_target − β_portfolio) × (Portfolio Value / Contract Value). Supports partial hedging (target beta ≠ 0). Shows hedge notional, coverage %, effective beta after hedge, and a bar chart comparing unhedged vs hedged exposure.

02

Min-Variance

Calculates the Minimum Variance Hedge Ratio (h* = ρ × σ_S / σ_F) from two return series using OLS regression. Shows correlation, asset and hedge volatility, hedge effectiveness (ρ²), variance reduction %, unhedged vs hedged variance. Scatter plot with MVHR regression line.

03

Options

Calculates the number of put option contracts needed for delta-neutral hedging: Contracts = (Shares × Hedge % / 100) / (Delta × Contract Size). Shows position delta, hedge delta, net delta after hedge, total hedge cost in dollars, hedge cost as % of position, and a P&L profile chart comparing hedged vs unhedged outcomes.

04

Portfolio

Enter up to 10 positions with shares, price, and individual betas. Calculates portfolio-level weighted average beta, total market value, required contracts to short, hedge notional, and a bar chart showing each position's beta contribution to total portfolio beta.

05

Scenarios

Runs sensitivity analysis varying either portfolio beta (0.5–2.0) or target beta across a user-defined range. Shows raw hedge ratio, contracts required, notional, coverage %, and effective beta at each step. Line chart and color-coded table reveal how the hedge requirement changes with portfolio risk level.