Married Put Options Strategy

A married put is a name given to an options trading strategy where an investor, holding a long position in a stock, purchases an at-the-money put option on the same stock to protect against depreciation in the stock’s price. This strategy fits when your near-term outlook on the stock or index is positive but you want to cap the downside. A married put has limited risk and unlimited profit potential:

See it in actionMarketXLS video

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos
Married Put Options Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS
  • Maximum loss = stock purchase price minus put strike, plus the put premium paid
  • Breakeven at expiration = stock purchase price plus the put premium paid
  • Upside = unlimited, reduced by the cost of the put

The put works like insurance: it costs a premium, and it pays off only if the stock falls below the strike. This article is educational, not investment advice.

Use the Married Put Excel template to model the strategy, model the payoff with the MarketXLS options profit calculator, or browse strategy spreadsheets in the MarketXLS templates library.

About the authors
Robin

About Robin

Co-Founder & COO, MarketXLS

Robin is a co-founder and the COO of MarketXLS. He works with Ankur and Anagh on the MarketXLS blog, creating articles together about market data and spreadsheet workflows.

Written collaboratively by Robin, Ankur and Anagh.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

The Professional Investment Platform Inside Excel

Market data and options research tools in Excel

  • Option prices and Greeks in Excel
  • Historical options data in Excel
  • US stock and index options data
  • Prices and data on underlying stocks and indices
  • Use MarketXLS formulas in your Excel worksheets
  • Explore options research workflows in Excel
  • Excel formulas and sample worksheets

See MarketXLS in action

Bring this workflow into Excel.

Book a demo with our team to see how MarketXLS supports your market research.

Ankur
AnkurFounder & CEO, MarketXLS
Book a demo