← 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

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found