← Back to Templates

Long Calendar Spread with Puts Option Strategy

Description

Long Calendar Spread with Puts Option Strategy thumbnail

Selling a near dated put and buying a longer dated put at the same strike is the calendar this workbook prices. The front leg decays faster than the back leg, which is the source of the gain when the underlying stays near the strike, and what remains after the short leg expires is simply the longer put.

Fifteen day volatility sits beside the quotes because a calendar is long vega: rising implied volatility helps the longer contract more than it hurts the shorter one. Both legs price from on demand bid, ask and previous close.

Template Screenshots

Long Calendar Spread with Puts Option Strategy screenshot 1

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?
▶
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found