A married put is a bullish options strategy in which you buy 100 shares of a stock and one put option on the same stock at the same time. The put sets a floor: your maximum loss is (purchase price minus put strike plus put premium) times 100, while upside stays unlimited above a breakeven of purchase price plus premium. In the example below, buying AAPL at $228.50 with a $225 put costing $8.50 caps the loss at $1,200 per 100 shares and puts breakeven at $237.
This guide covers setup, cost and breakeven math, how the married put compares with the protective put, long call, and collar, and how to pull the stock price, option chain, and put premium into Excel with MarketXLS. MarketXLS options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans.
What Is a Married Put?
A married put consists of two simultaneous transactions:
- Buy 100 shares of the underlying stock
- 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
| Feature | Description |
|---|---|
| Direction | Bullish (you expect the stock to rise) |
| Maximum Profit | Unlimited (stock can rise indefinitely) |
| Maximum Loss | Limited: (Stock Price − Strike Price) + Premium Paid |
| Breakeven | Stock Purchase Price + Premium Paid |
| Time Decay (Theta) | Works against you (put loses value over time) |
| Volatility Impact | Rising volatility increases put value (beneficial) |
| When to Use | Bullish 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
A married put takes six steps in Excel with MarketXLS. On Mac or Excel for the web, prefix each function with mxls..
Step 1: Check the Current Stock Price
First, get the current price of the stock you want to buy:
=Last("AAPL")
Formula documentation: Last
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")
Formula documentation: QM_GetOptionChain
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 Selection | Protection Level | Cost | Trade-Off |
|---|---|---|---|
| At-the-Money (ATM) | Maximum protection | Highest premium | Higher breakeven, lower max loss |
| Slightly OTM | Good protection | Moderate premium | Balanced cost/protection |
| Deep OTM | Minimal protection | Lowest premium | Cheapest 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)
Formula documentation: OptionSymbol
This returns the QuoteMedia option symbol (e.g., @AAPL 260619P00225000, with the ticker padded to six characters). Reference the cell rather than retyping the symbol.
Step 5: Get the Put Premium
Check the current price of the put option:
=QM_Last(OptionSymbol("AAPL", "2026-06-19", "P", 225))
Formula documentation: QM_Last, OptionSymbol
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")
Formula documentation: QM_GetOptionQuotesAndGreeks
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 Expiry | Stock P&L | Put Value | Put P&L | Net 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.
| Feature | Married Put | Protective Put |
|---|---|---|
| Timing | Stock and put bought simultaneously | Put bought on an existing stock position |
| Intent | Protection from the start of a new position | Adding protection to an already-owned stock |
| Tax Treatment | Put is linked to stock for tax purposes | May have different holding period implications |
| Cost Basis | Premium included in stock cost basis | Premium 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:
| Feature | Married Put | Long Call |
|---|---|---|
| Max Loss | (Stock Price − Strike) + Premium | Premium paid |
| Max Profit | Unlimited | Unlimited |
| Breakeven | Stock Price + Put Premium | Strike Price + Premium |
| Capital Required | High (buy shares + put) | Low (premium only) |
| Dividends | Yes (you own shares) | No |
| Voting Rights | Yes | No |
| Time Decay | Hurts (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
- Bullish outlook with uncertainty: You believe the stock will rise but want protection against a potential short-term decline.
- Around earnings announcements: Buying shares of a company you are bullish on long-term while protecting against an earnings miss.
- Volatile markets: When overall market conditions are uncertain, the put provides a safety net.
- New positions in volatile stocks: Buying shares of a high-volatility stock with put protection limits worst-case scenarios.
- Concentrated positions: When you must hold a large position (e.g., company stock) and want to cap downside risk.
When NOT to Use
- Strong conviction with no concern about downside: The put premium reduces returns unnecessarily.
- Low-volatility stocks: The insurance cost may not be justified.
- Frequent use: Continuously buying married puts is expensive and erodes returns over time.
- 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)
- Hold and let the put expire: Accept the premium as the cost of insurance. You keep your shares and profits.
- Sell the put before expiration: If significant time value remains, you can recover some of the premium by selling the put.
- 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)
- Exercise the put: Sell your shares at the strike price, limiting your loss to the calculated maximum.
- 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.
- 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
- Let the put expire: You lose the premium, but you still own your shares.
- 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(OptionSymbol("AAPL","2026-06-19","P",225)) → $8.50
Call (250 strike): =QM_Last(OptionSymbol("AAPL","2026-06-19","C",250)) → $5.00
Formula documentation: Last, QM_Last, OptionSymbol
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 Strike | Put Premium | Deductible | Total Cost | Max Loss |
|---|---|---|---|---|
| $230 (slightly ITM) | $12.00 | −$1.50 | $10.50 | $1,050 |
| $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
| Strategy | Vs. Married Put | Key Difference |
|---|---|---|
| Long Call | Lower capital required | No stock ownership, no dividends |
| Collar | Reduced insurance cost | Upside capped by short call |
| Protective Put | Same payoff | Put added to existing position, not simultaneous |
| Bull Call Spread | Defined risk, lower cost | No stock ownership, limited upside |
| Cash-Secured Put Selling | Generates income | No stock ownership until assigned, profit limited |
| Stop-Loss Order | No premium cost | No guaranteed exit price; gaps can cause larger losses |
Step-by-Step: Building a Married Put Dashboard in Excel
Step 1: Input Section
| Cell | Label | Formula |
|---|---|---|
| B1 | Ticker | AAPL |
| B2 | Stock Price | =Last(B1) |
| B3 | Shares | 100 |
| B4 | Stock Cost | =B2*B3 |
Step 2: Put Selection
| Cell | Label | Formula |
|---|---|---|
| B6 | Put Strike | 225 |
| B7 | Put Expiry | 2026-06-19 |
| B8 | Option Symbol | =OptionSymbol(B1, B7, "P", B6) |
| B9 | Put Premium | =QM_Last(B8) |
| B10 | Put Cost | =B9*100 |
Step 3: Risk/Reward Calculations
| Cell | Label | Formula |
|---|---|---|
| B12 | Total Investment | =B4+B10 |
| B13 | Breakeven | =B2+B9 |
| B14 | Max Loss | =(B2-B6+B9)*100 |
| B15 | Protection Cost % | =B9/B2*100 |
| B16 | Days 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.
Before events (earnings, FDA decisions, etc.) implied volatility is usually elevated, so puts cost more. After the event, implied volatility often falls sharply, which reduces the put's value unless the stock moves down enough to offset it.
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. A put strike 3-5% below the stock purchase price is a common 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 an at-the-money put with 3 months to expiration on a moderately volatile stock, the cost is often a few percent of the stock price; it rises with implied volatility. 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
A married put gives a bullish investor defined maximum loss and unlimited upside by buying shares and a put at the same time. The put premium is the cost of that protection.
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 put prices with =QM_Last(), and analyze Greeks with =QM_GetOptionQuotesAndGreeks(). Execution happens at your broker; the workbook is for analysis.
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.
