← Back to Templates


Long Calendar Spread with Puts Option Strategy
Description

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

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