← Back to Templates


Box Spread
Description

A box spread combines a bull call spread with a bear put spread on the same underlying, same two strikes and same expiration: long the lower strike call, short the higher strike call, long the higher strike put and short the lower strike put. The payoff at expiration is fixed at the difference between the strikes, which is why the trade is priced as an interest rate position.
Option symbols resolve from your inputs and bring bid, ask and previous close on demand, beside the underlying's last price, so the net debit can be compared against the locked settlement value.
Template Screenshots

Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found