Married Put: Complete Options Strategy Guide with Excel & MarketXLS

M
MarketXLS Team
Published
Married Put options strategy payoff diagram and setup in Excel using MarketXLS option chain data

Married put is a bullish options strategy where an investor simultaneously buys shares of a stock and purchases a put option on the same stock. Think of it as buying insurance for your stock position—the put option protects against downside risk while allowing you to participate in unlimited upside potential. This makes the married put one of the most straightforward risk management strategies available to investors.

In this comprehensive guide, you will learn everything about the married put strategy—what it is, how to set it up, how to analyze costs and breakeven points, how it compares to the protective put and other alternatives, and how to use MarketXLS in Excel to pull real-time data for building and managing married put positions.

What Is a Married Put?

A married put consists of two simultaneous transactions:

  1. Buy 100 shares of the underlying stock
  2. Buy 1 put option on the same stock (each contract covers 100 shares)

The term "married" comes from the fact that the stock purchase and put purchase are paired together from the start. The put option acts as a floor price—no matter how far the stock falls, you can sell your shares at the put's strike price.

Key Characteristics

FeatureDescription
DirectionBullish (you expect the stock to rise)
Maximum ProfitUnlimited (stock can rise indefinitely)
Maximum LossLimited: (Stock Price − Strike Price) + Premium Paid
BreakevenStock Purchase Price + Premium Paid
Time Decay (Theta)Works against you (put loses value over time)
Volatility ImpactRising volatility increases put value (beneficial)
When to UseBullish on a stock but want downside protection

Married Put Payoff Diagram

The payoff profile of a married put looks like a long call option:

  • Below the strike price: Losses are capped because the put protects your stock position
  • Above the breakeven: Profits increase dollar-for-dollar with the stock price
  • Between strike and breakeven: Partial loss (cost of the insurance)

Setting Up a Married Put with MarketXLS

Let us walk through setting up a married put position using real-time data from MarketXLS in Excel.

Step 1: Check the Current Stock Price

First, get the current price of the stock you want to buy:

=Last("AAPL")

Suppose this returns $228.50. You plan to buy 100 shares.

Step 2: Pull the Option Chain

To find available put options, use:

=QM_GetOptionChain("AAPL")

This returns all active option contracts for AAPL, including calls and puts at various strike prices and expirations. Filter the data in Excel to show only put options at your desired expiration.

Step 3: Select the Put Strike Price

The strike price of your put determines the level of protection:

Strike SelectionProtection LevelCostTrade-Off
At-the-Money (ATM)Maximum protectionHighest premiumHigher breakeven, lower max loss
Slightly OTMGood protectionModerate premiumBalanced cost/protection
Deep OTMMinimal protectionLowest premiumCheapest insurance, but less coverage

For a married put, ATM or slightly OTM puts are most common because they provide meaningful downside protection.

Step 4: Build the Option Symbol

Once you have chosen a put contract, create the option symbol:

=OptionSymbol("AAPL", "2026-06-19", "P", 225)

This returns the standardized symbol (e.g., @AAPL 260619P00225000).

Step 5: Get the Put Premium

Check the current price of the put option:

=QM_Last("@AAPL 260619P00225000")

Suppose this returns $8.50 per share ($850 per contract).

Step 6: Review Greeks

For a deeper analysis, pull the full Greeks:

=QM_GetOptionQuotesAndGreeks("AAPL")

Filter for your specific contract to see Delta, Gamma, Theta, Vega, and implied volatility.

Cost Analysis and Risk/Reward

Total Investment

The total cost of a married put position is:

Total Cost = (Stock Price × 100) + (Put Premium × 100)

Using our example:

  • Stock cost: $228.50 × 100 = $22,850
  • Put cost: $8.50 × 100 = $850
  • Total investment: $23,700

Breakeven Point

Breakeven = Stock Purchase Price + Put Premium

$228.50 + $8.50 = $237.00

The stock needs to rise above $237.00 for the position to be profitable at expiration. This is the "cost of insurance."

Maximum Loss

Max Loss = (Stock Purchase Price − Put Strike Price + Put Premium) × 100

($228.50 − $225 + $8.50) × 100 = $1,200

No matter how far the stock falls—even to zero—your maximum loss is capped at $1,200. This is because you can always exercise the put and sell your shares at $225.

Maximum Profit

Max Profit = Unlimited

As the stock rises above the breakeven point ($237.00), your profit increases dollar for dollar. The put option expires worthless, and you only lose the premium paid.

Married Put Payoff Table

Stock Price at ExpiryStock P&LPut ValuePut P&LNet P&L
$180−$4,850$45.00+$3,650−$1,200
$200−$2,850$25.00+$1,650−$1,200
$220−$850$5.00−$350−$1,200
$225−$350$0.00−$850−$1,200
$228.50$0$0.00−$850−$850
$237+$850$0.00−$850$0
$250+$2,150$0.00−$850+$1,300
$270+$4,150$0.00−$850+$3,300
$300+$7,150$0.00−$850+$6,300

Notice how the max loss remains $1,200 regardless of how far the stock drops, while profits grow without limit as the stock rises.

Married Put vs. Protective Put

These two strategies are frequently confused because they are mechanically similar. The key difference is timing.

FeatureMarried PutProtective Put
TimingStock and put bought simultaneouslyPut bought on an existing stock position
IntentProtection from the start of a new positionAdding protection to an already-owned stock
Tax TreatmentPut is linked to stock for tax purposesMay have different holding period implications
Cost BasisPremium included in stock cost basisPremium separate from stock cost basis
Strategy Name"Married" because purchased together"Protective" because added after the fact

From a payoff perspective, both strategies have identical risk/reward profiles. The distinction is primarily relevant for tax treatment and portfolio accounting.

Married Put vs. Long Call

Interestingly, the married put has a payoff profile very similar to a long call option:

FeatureMarried PutLong Call
Max Loss(Stock Price − Strike) + PremiumPremium paid
Max ProfitUnlimitedUnlimited
BreakevenStock Price + Put PremiumStrike Price + Premium
Capital RequiredHigh (buy shares + put)Low (premium only)
DividendsYes (you own shares)No
Voting RightsYesNo
Time DecayHurts (put loses value)Hurts (call loses value)

The married put requires significantly more capital because you must buy the shares. However, you receive dividends and voting rights, and if the stock stays flat, you still own the shares (minus the put premium cost). A long call expires worthless if the stock does not rise above the strike.

When to Use a Married Put

Ideal Conditions

  1. Bullish outlook with uncertainty: You believe the stock will rise but want protection against a potential short-term decline.
  2. Around earnings announcements: Buying shares of a company you are bullish on long-term while protecting against an earnings miss.
  3. Volatile markets: When overall market conditions are uncertain, the put provides a safety net.
  4. New positions in volatile stocks: Buying shares of a high-volatility stock with put protection limits worst-case scenarios.
  5. Concentrated positions: When you must hold a large position (e.g., company stock) and want to cap downside risk.

When NOT to Use

  1. Strong conviction with no concern about downside: The put premium reduces returns unnecessarily.
  2. Low-volatility stocks: The insurance cost may not be justified.
  3. Frequent use: Continuously buying married puts is expensive and erodes returns over time.
  4. Short-term trades: For very short holding periods, the put premium may be too expensive relative to expected gains.

Managing a Married Put Position

Once you have established your married put, here are the key management decisions:

If the Stock Rises (Position Profitable)

  1. Hold and let the put expire: Accept the premium as the cost of insurance. You keep your shares and profits.
  2. Sell the put before expiration: If significant time value remains, you can recover some of the premium by selling the put.
  3. Roll the put up: Sell the current put and buy a higher-strike put to lock in gains and raise the floor.

If the Stock Falls (Put Protects You)

  1. Exercise the put: Sell your shares at the strike price, limiting your loss to the calculated maximum.
  2. Sell the put for profit: If the put has gained significant value, you can sell it and keep your shares—effectively using the put profit to offset the stock loss.
  3. Roll the put down and out: If you remain bullish long-term, sell the current put (at a profit) and buy a cheaper put at a lower strike for a later expiration.

If the Stock Is Flat

  1. Let the put expire: You lose the premium, but you still own your shares.
  2. Sell covered calls: To recover some of the put premium cost, sell an out-of-the-money call against your shares (creating a collar).

The Collar Strategy: Reducing the Cost of a Married Put

A common refinement of the married put is to add a short call, creating a collar:

  • Buy 100 shares of stock
  • Buy 1 ATM or OTM put (downside protection)
  • Sell 1 OTM call (generates premium to offset put cost)

The short call premium reduces the net cost of protection, but it caps your upside at the call's strike price. This is essentially a married put with a cost-reduction feature.

Collar Example Using MarketXLS

Stock: =Last("AAPL") → $228.50
Put (225 strike): =QM_Last("@AAPL 260619P00225000") → $8.50
Call (250 strike): =QM_Last("@AAPL 260619C00250000") → $5.00

Net protection cost: $8.50 − $5.00 = $3.50 per share (vs. $8.50 for the married put alone)

Trade-off: Your upside is now capped at $250.

Cost of Protection: How to Evaluate

The cost of the married put protection can be evaluated several ways:

As a Percentage of Stock Price

Protection Cost % = (Put Premium / Stock Price) × 100

$8.50 / $228.50 × 100 = 3.72%

This means you are paying 3.72% of the stock price for downside protection. Compare this to the expected return to determine if it is worthwhile.

Annualized Cost

If the put has 6 months to expiration:

Annualized Cost = (Put Premium / Stock Price) × (12 / Months to Expiry) × 100

($8.50 / $228.50) × (12/6) × 100 = 7.44% annualized

Cost vs. Deductible

Think of the married put like car insurance:

  • Premium = Put premium (the insurance cost)
  • Deductible = Stock price − Strike price (the loss you absorb before protection kicks in)
  • Coverage limit = The strike price (the minimum price you can sell for)
Put StrikePut PremiumDeductibleTotal CostMax Loss
$230 (ATM)$12.00$0$12.00$1,200
$225 (slightly OTM)$8.50$3.50$12.00$1,200
$220 (OTM)$5.80$8.50$14.30$1,430
$210 (deep OTM)$3.20$18.50$21.70$2,170

Notice the trade-off: cheaper premiums come with higher deductibles (wider gap between stock price and strike).

Alternative Strategies to Consider

StrategyVs. Married PutKey Difference
Long CallLower capital requiredNo stock ownership, no dividends
CollarReduced insurance costUpside capped by short call
Protective PutSame payoffPut added to existing position, not simultaneous
Bull Call SpreadDefined risk, lower costNo stock ownership, limited upside
Cash-Secured Put SellingGenerates incomeNo stock ownership until assigned, profit limited
Stop-Loss OrderNo premium costNo guaranteed exit price; gaps can cause larger losses

Step-by-Step: Building a Married Put Dashboard in Excel

Step 1: Input Section

CellLabelFormula
B1TickerAAPL
B2Stock Price=Last(B1)
B3Shares100
B4Stock Cost=B2*B3

Step 2: Put Selection

CellLabelFormula
B6Put Strike225
B7Put Expiry2026-06-19
B8Option Symbol=OptionSymbol(B1, B7, "P", B6)
B9Put Premium=QM_Last(B8)
B10Put Cost=B9*100

Step 3: Risk/Reward Calculations

CellLabelFormula
B12Total Investment=B4+B10
B13Breakeven=B2+B9
B14Max Loss=(B2-B6+B9)*100
B15Protection Cost %=B9/B2*100
B16Days to Expiry=DATEVALUE(B7)-TODAY()

Step 4: Greeks Monitoring

Use =QM_GetOptionQuotesAndGreeks("AAPL") in a separate section to monitor how your put's Greeks change daily.

Impact of Time and Volatility

Time Decay (Theta)

The put option loses value every day due to time decay. This works against the married put holder because the insurance becomes less valuable as expiration approaches. The rate of decay accelerates in the final 30 days.

Management tip: If the stock has risen significantly and you no longer need the protection, sell the put before expiration to recover remaining time value.

Implied Volatility (Vega)

Rising implied volatility increases the put's value, which benefits the married put holder. Conversely, falling volatility (volatility crush) reduces the put's value.

This is why married puts are particularly useful before events (earnings, FDA decisions, etc.)—if the stock drops, both the put's intrinsic value and its volatility premium increase, providing better protection.

Frequently Asked Questions

What is the difference between a married put and a protective put?

A married put involves buying shares and a put option simultaneously as a single combined position. A protective put involves buying a put on shares you already own. The payoff profiles are identical, but the distinction matters for tax treatment and cost basis calculation. In a married put, the put premium may be added to the stock's cost basis.

Is a married put the same as buying a call option?

The payoff diagram of a married put looks very similar to a long call, and the risk/reward profile is comparable. However, a married put requires significantly more capital (you buy shares plus the put), while a call only costs the premium. The trade-off is that with a married put, you own the actual shares—receiving dividends and voting rights.

How do I choose the right strike price for a married put?

Choose based on how much loss you can tolerate. An at-the-money put provides maximum protection but costs more. An out-of-the-money put is cheaper but leaves a gap between the stock price and strike where you absorb losses. Many investors choose a put strike 3-5% below the stock purchase price as a compromise.

Can I write covered calls against a married put?

Yes, adding a short call to a married put creates a collar strategy. The call premium offsets some of the put cost, reducing your insurance expense. However, the short call caps your upside. This is a popular modification for cost-conscious investors who are willing to limit their upside potential.

How long should the put expiration be?

Match the put expiration to your risk horizon. If you are concerned about a specific event (earnings in 30 days), buy a put that expires after that event. For ongoing portfolio protection, 3-6 month puts offer a balance between cost and duration. Longer-dated puts (LEAPS) provide extended protection but cost more.

Is the married put strategy expensive?

The put premium is essentially an insurance cost that reduces your net return. For a typical at-the-money put with 3 months to expiration, expect to pay 3-6% of the stock price. This cost is justified when the potential downside risk is significant. To reduce costs, consider using a collar (adding a short call) or selecting a lower strike price.

Conclusion

The married put strategy is a powerful risk management tool for bullish investors who want downside protection without sacrificing unlimited upside potential. By buying shares and a put option simultaneously, you create a position with defined maximum loss and unlimited profit potential—essentially an insurance policy for your stock investment.

Using MarketXLS in Excel, you can build a complete married put analysis workbook. Pull current stock prices with =Last(), browse the full option chain with =QM_GetOptionChain(), construct option symbols with =OptionSymbol(), get live put pricing with =QM_Last(), and analyze Greeks with =QM_GetOptionQuotesAndGreeks(). This gives you everything you need to evaluate, execute, and manage married put positions without leaving your spreadsheet.

Ready to protect your stock positions with married puts? Explore MarketXLS pricing plans and start building your options analysis workbook today.

Disclaimer

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein. The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made.

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.

#1 Excel Solution for Investors

Get Market data in Excel easy to use formulas

  • Real-time Live Streaming Option Prices & Greeks in your Excel
  • Historical (intraday) Options data in your Excel
  • All US Stocks and Index options are included
  • Real-time Option Order Flow
  • Real-time prices and data on underlying stocks and indices
  • Works on Windows, MAC or even online
  • Implement MarketXLS formulas in your Excel sheets and make them come alive
  • Save hours of time, streamline your option trading workflows
  • Easy to use with formulas and pre-made templates
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets