← Back to Templates


Put Ratio Back-Spread
Description

Sells one put at a higher strike and buys two puts at a lower strike in the same expiration, leaving the position net long options and positioned for a large decline.
The three legs are quoted from bid and ask, the net premium is totalled, and the expiration payoff shows the trough at the long strike where the structure does worst before the two long puts take over further down. Adjust the strikes and the ratio in the input cells to see the entry cost trade off against how far the stock has to fall.
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