← Back to Templates


Bear Put Spread Option Strategy
Description

Buying a put and selling a lower strike put in the same expiration produces a bear put spread, a debit position that pays as the stock falls toward the short strike.
Both legs are quoted from bid and ask so the net debit reflects a realistic fill, and the short put caps the gain at the difference between the strikes while loss is limited to the premium paid. Company name and last price anchor the underlying, and the payoff table gives the breakeven along with the flat regions past each strike.
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