← Back to Templates


Long Gut
Description

Buying an in the money call and an in the money put, with the call strike below the put strike, gives the long gut priced in this sheet. Most of the debit is intrinsic value that comes back at expiration, so the real cost is the extrinsic portion of the two legs, and the position profits on a move beyond either strike by more than that amount. Risk is limited to the premium paid.
Both legs pull bid, ask and previous close on demand from option symbols built out of your inputs.
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