Selling weekly put options is one of the most popular income-generation strategies among options traders. By writing short-term put contracts, sellers collect premium with the expectation that the option will expire worthless — allowing them to keep the entire premium as profit. This comprehensive guide covers the mechanics of selling weekly puts, strike selection criteria, risk management techniques, the role of the Greeks, and how to use MarketXLS to analyze option chains and track positions directly in Excel.
What Does Selling Weekly Put Options Mean?
When you sell (or "write") a put option, you are entering into a contract that obligates you to buy 100 shares of the underlying stock at the strike price if the option buyer exercises their right. In exchange for accepting this obligation, you receive a premium upfront.
Weekly put options are contracts that expire every week (typically on Fridays), as opposed to standard monthly options that expire on the third Friday of each month. Weekly options were introduced by the CBOE in 2005 and have become increasingly popular due to their:
- Faster time decay: Shorter duration means theta (time decay) accelerates rapidly
- More frequent income opportunities: Traders can sell puts 4–5 times per month
- Greater flexibility: Tighter alignment with short-term market views
- Lower absolute premium per contract: Smaller capital at risk per trade
The Basic Mechanics
| Element | Details |
|---|---|
| Action | Sell to open a put option |
| Obligation | Buy 100 shares at strike price if assigned |
| Premium | Received upfront (non-refundable) |
| Expiration | Weekly (typically 5–7 days) |
| Ideal Outcome | Option expires worthless; seller keeps premium |
| Maximum Profit | Limited to the premium received |
| Maximum Loss | Strike price minus premium × 100 (if stock goes to zero) |
Why Sell Weekly Puts Instead of Monthly?
Time Decay Advantage
Time decay (theta) is the put seller's primary edge. The rate of time decay is not linear — it accelerates dramatically in the final week before expiration. By selling weekly options, you position yourself at the steepest part of the theta decay curve.
Consider two scenarios:
- Selling a 30-day put: Theta is moderate for the first three weeks, then accelerates in the final week
- Selling a 7-day put four times: Each time you sell, you're capturing the steepest theta decay period
Over a month, four weekly puts typically collect more total premium than a single monthly put at the same strike and underlying, because you're repeatedly capturing the high-theta-decay window.
Statistics on Option Expiration
According to CME studies covering multiple years of data, approximately 76.5% of all options held to expiration expired worthless. This statistic strongly favors option sellers, particularly those selling short-duration contracts where the underlying has less time to move adversely.
Annualized Return Potential
If a weekly put generates 0.5% return on capital at risk each week, that compounds to approximately 26% annualized. Weekly selling allows compounding more frequently than monthly strategies.
When to Sell Weekly Puts: Entry Criteria
Not every week is ideal for selling puts. Here are the key criteria to evaluate before entering a trade:
1. Market Direction (Bullish or Neutral View)
Selling puts is fundamentally a bullish-to-neutral strategy. You want the underlying stock to stay at or above your strike price. Only sell puts on stocks you have a neutral-to-bullish view on.
2. Implied Volatility Assessment
Higher implied volatility (IV) means richer premiums, but also signals greater expected movement. The ideal scenario is selling puts when IV is elevated relative to historical volatility (HV), capturing the "volatility risk premium."
Use MarketXLS to check option data:
=QM_GetOptionQuotesAndGreeks("AAPL")
This returns a full table of option quotes including IV, delta, theta, gamma, and vega for all strikes and expirations — allowing you to compare IV levels across different expirations.
3. Trend Analysis
Sell puts when the stock is in a stable or upward trend. Avoid selling puts into a downtrend, as you're fighting momentum and increasing assignment risk.
4. Support Levels
Choose strike prices at or below key technical support levels. If the stock has strong support at $145 and is trading at $155, selling a $145 put gives you both a technical and statistical buffer.
5. Earnings and Events
Avoid selling weekly puts when earnings announcements, FDA decisions, or other binary events fall within the option's life. These events can cause gap moves that overwhelm your premium collected.
Strike Selection Strategies for Weekly Puts
| Strategy | Strike Relative to Current Price | Delta Range | Risk/Reward Profile |
|---|---|---|---|
| At-the-Money (ATM) | At current price | ~0.50 | Highest premium, highest risk |
| Slightly OTM | 2–5% below current price | 0.20–0.35 | Balanced premium and safety |
| Deep OTM | 5–10% below current price | 0.05–0.15 | Low premium, high probability of profit |
| Cash-Secured Put | Any strike (fully cash-backed) | Varies | Eliminates margin call risk |
| Put Credit Spread | Sell higher strike, buy lower strike | Varies | Defined risk, lower capital requirement |
Recommended Approach: Slightly OTM with Delta Guidance
Many professional put sellers target options with a delta between -0.15 and -0.30 for weekly contracts. This means:
- There's an approximately 70–85% probability the option expires worthless
- The premium is still meaningful relative to capital at risk
- The strike sits below current support levels in many cases
How to Analyze Weekly Put Options in Excel With MarketXLS
MarketXLS provides powerful option chain analysis tools directly inside Excel. Here is how to set up a weekly put selling workflow.
Step 1: Pull the Full Option Chain
=QM_GetOptionChain("AAPL")
This populates your spreadsheet with the complete option chain for AAPL, including all available expiration dates, strikes, bid/ask prices, volume, and open interest.
Step 2: Build an Option Symbol
Once you've identified a specific strike and expiration, construct the option symbol:
=OptionSymbol("AAPL", "2026-03-20", "P", 220)
This returns the standardized option symbol (e.g., @AAPL 260320P00220000), which you can use with other MarketXLS functions.
Step 3: Get Real-Time Option Pricing
=QM_Last("@AAPL 260320P00220000")
This returns the last traded price of the specific put option, allowing you to monitor your position in real time.
Step 4: Analyze the Greeks
=QM_GetOptionQuotesAndGreeks("AAPL")
This returns a comprehensive table including:
| Greek | What It Tells You | Why It Matters for Put Selling |
|---|---|---|
| Delta | Price sensitivity to $1 move in underlying | Indicates probability of expiring ITM |
| Theta | Daily time decay in dollars | Your primary profit driver |
| Gamma | Rate of change of delta | Risk of delta accelerating against you |
| Vega | Sensitivity to 1% change in IV | Exposure to volatility expansion |
| Rho | Sensitivity to interest rate changes | Usually minimal for weekly options |
Step 5: Create a Weekly Put Selling Dashboard
Set up a spreadsheet with these columns:
| Column | Data/Formula | Purpose |
|---|---|---|
| A | Ticker | Underlying stock |
| B | =QM_Last("AAPL") | Current stock price |
| C | Strike Price | Your selected strike |
| D | Expiration Date | Weekly expiration |
| E | =OptionSymbol(A1, D1, "P", C1) | Option symbol |
| F | =QM_Last(E1) | Current option price |
| G | Premium Received | Entry price |
| H | =G1 * 100 | Dollar income per contract |
| I | =(G1 / C1) * 52 * 100 | Annualized return % |
Risk Management for Weekly Put Selling
Cash-Secured Puts
The safest approach to selling puts is the cash-secured put, where you hold enough cash in your account to purchase 100 shares at the strike price. If assigned, you simply buy the shares.
Example:
- Sell 1 AAPL $220 put for $2.50 premium
- Reserve $22,000 in cash (220 × 100)
- If assigned, your effective cost basis is $217.50 ($220 - $2.50)
- If the option expires worthless, you keep $250 (return of 1.14% for one week)
Put Credit Spreads (Defined Risk)
For traders who want defined risk, a put credit spread limits maximum loss:
- Sell the higher-strike put (e.g., $220 put for $2.50)
- Buy a lower-strike put (e.g., $215 put for $1.20)
- Net credit: $1.30 per share ($130 per contract)
- Maximum loss: Width of spread minus net credit = $5.00 - $1.30 = $3.70 per share ($370 per contract)
Build this in Excel:
=OptionSymbol("AAPL", "2026-03-20", "P", 220) // Sold put
=OptionSymbol("AAPL", "2026-03-20", "P", 215) // Bought put (hedge)
Then price both legs with =QM_Last() to calculate your net credit and maximum risk.
Position Sizing Rules
| Rule | Guideline |
|---|---|
| Maximum risk per trade | 2–5% of total portfolio |
| Number of concurrent positions | 5–10 across different underlyings |
| Correlation management | Avoid selling puts on 5 tech stocks simultaneously |
| Reserve cash | Keep 20–30% of portfolio in cash for adjustments |
| Stop-loss | Consider closing at 2× premium received |
Rolling Puts
If a put moves against you, you can "roll" the position:
- Roll down: Close the current put and sell a lower strike for the same expiration
- Roll out: Close the current put and sell the same strike for a later expiration
- Roll down and out: Combine both — lower strike and later expiration
Rolling allows you to collect additional premium while giving the stock more time and room to recover.
The Greeks in Detail for Weekly Put Sellers
Theta (Time Decay) — Your Profit Engine
Theta measures how much an option's price decreases per day, all else being equal. For weekly options:
- At-the-money weekly puts may have theta of -$0.15 to -$0.30 per day
- Over 5 trading days, that's $0.75–$1.50 of premium erosion
- Theta is highest for ATM options and decreases for deep ITM or OTM options
- Theta accelerates in the final 2–3 days before expiration
Delta — Your Directional Risk
For put options, delta ranges from 0 to -1.0:
- Delta of -0.30: The option price changes approximately $0.30 for every $1 move in the stock
- Delta also approximates probability: A -0.30 delta put has roughly a 30% chance of expiring ITM
- As expiration approaches, delta becomes more binary — either near 0 (OTM) or near -1 (ITM)
Gamma — The Speed of Delta Change
Gamma is highest for at-the-money options near expiration. This is the primary risk for weekly option sellers:
- High gamma means delta can change rapidly with small stock moves
- Near expiration, an ATM option can swing from -0.30 delta to -0.70 delta on a small stock decline
- Mitigation: Sell OTM options where gamma is lower
Vega — Volatility Risk
Vega measures how much the option price changes for a 1% change in implied volatility:
- For weekly options, vega is relatively small (shorter duration = less sensitivity)
- However, volatility spikes can still impact short-dated options significantly
- Strategy: Sell puts when IV is high, as a subsequent IV contraction benefits the seller
Comparison: Weekly Puts vs. Other Income Strategies
| Strategy | Income Source | Risk Level | Capital Required | Frequency | Best Market Condition |
|---|---|---|---|---|---|
| Selling Weekly Puts (Cash-Secured) | Put premium | Moderate | High (full cash backing) | Weekly | Bullish/Neutral |
| Selling Weekly Puts (Spread) | Net credit | Defined/Low | Low | Weekly | Bullish/Neutral |
| Covered Calls | Call premium | Low-Moderate | Own 100 shares | Weekly/Monthly | Neutral/Slightly Bullish |
| Iron Condor | Net credit | Defined | Moderate | Monthly | Range-bound |
| Credit Spreads (Calls) | Net credit | Defined | Low | Weekly/Monthly | Bearish/Neutral |
| Dividend Investing | Dividends | Low | Varies | Quarterly | N/A |
Common Mistakes When Selling Weekly Puts
- Selling too close to earnings: Binary events can overwhelm premium collected
- Over-leveraging: Selling too many puts relative to account size
- Ignoring correlation: Selling puts on 10 highly correlated stocks means one market move impacts everything
- Not having an exit plan: Define your stop-loss and adjustment rules before entering
- Chasing premium: Selling ATM options for higher premium without adequate safety margin
- Ignoring assignment risk: Be prepared to take delivery of shares if assigned
- Neglecting ex-dividend dates: Early assignment risk increases around ex-dividend dates for ITM puts
Step-by-Step Example: Selling a Weekly Put on SPY
Let's walk through a complete example using MarketXLS:
1. Check the Current Price
=QM_Last("SPY")
Assume SPY is trading at $580.
2. Pull the Option Chain
=QM_GetOptionChain("SPY")
3. Select a Strike
Looking for a put with delta around -0.20, you identify the $570 strike expiring in 7 days with a bid of $1.85.
4. Build the Option Symbol
=OptionSymbol("SPY", "2026-02-20", "P", 570)
5. Verify the Price
=QM_Last("@SPY 260220P00570000")
6. Calculate Key Metrics
| Metric | Calculation | Value |
|---|---|---|
| Premium per contract | $1.85 × 100 | $185 |
| Capital required (cash-secured) | $570 × 100 | $57,000 |
| Weekly return | $185 / $57,000 | 0.32% |
| Annualized return | 0.32% × 52 | 16.9% |
| Break-even price | $570 - $1.85 | $568.15 |
| Buffer from current price | ($580 - $570) / $580 | 1.72% |
7. Monitor Greeks
Use =QM_GetOptionQuotesAndGreeks("SPY") to track delta, theta, and gamma daily. If delta expands beyond -0.40, consider rolling or closing.
Tax Considerations for Put Selling
Income from selling put options is generally treated as short-term capital gains in the US, regardless of how long you've been trading. Key considerations:
- Expired puts: Premium received is a short-term capital gain
- Closed positions: Net gain or loss is short-term
- Assignment: The premium adjusts your cost basis in the assigned shares
- Wash sale rules: Can apply if you sell a put on a stock you recently sold at a loss
“Note: Tax laws vary by jurisdiction. Consult a qualified tax professional for advice specific to your situation.
Building a Weekly Put Selling System in Excel
Using MarketXLS, you can create a systematic put selling operation:
Trade Journal Template
| Column | Content |
|---|---|
| Date Opened | Trade entry date |
| Underlying | Stock ticker |
| Strike | Put strike price |
| Expiration | Weekly expiration date |
| Premium Received | Per-share premium collected |
| Delta at Entry | Delta when trade was opened |
| Status | Open / Closed / Assigned / Rolled |
| Close Price | Price at close (0 if expired) |
| P&L | Premium received minus close price |
| Notes | Market conditions, lessons learned |
Automated Monitoring
Set up a watchlist that refreshes with MarketXLS:
// Column A: Option symbols built with OptionSymbol()
// Column B: =QM_Last(A1) for current price
// Column C: Premium received (manual entry)
// Column D: =C1 - B1 for unrealized P&L per share
// Column E: =D1 * 100 for dollar P&L per contract
Frequently Asked Questions
What is the best delta for selling weekly put options?
Most professional put sellers target a delta between -0.15 and -0.30 for weekly contracts. This range provides a balance between premium collected and probability of profit. A -0.20 delta put has approximately an 80% probability of expiring worthless.
How much capital do I need to sell weekly puts?
For cash-secured puts, you need enough cash to buy 100 shares at the strike price. For a $50 stock, that is $5,000 per contract. Put credit spreads require less capital — only the width of the spread minus the credit received, multiplied by 100.
Can I sell weekly put options in a retirement account?
Many brokerages allow cash-secured put selling in IRA accounts. Put credit spreads are also permitted at some brokerages with the appropriate options approval level. Naked puts are generally not allowed in retirement accounts.
What happens if my weekly put gets assigned?
If the stock price is below your strike price at expiration, you will be assigned and required to purchase 100 shares per contract at the strike price. Your effective cost basis is the strike price minus the premium received.
How do I track weekly put options in Excel?
Use MarketXLS formulas: =QM_GetOptionChain("TICKER") for the full option chain, =OptionSymbol() to build specific option symbols, =QM_Last() for real-time pricing, and =QM_GetOptionQuotesAndGreeks() for Greeks analysis. Build a dashboard with these formulas for systematic monitoring.
Is selling weekly puts better than selling monthly puts?
Weekly puts benefit from faster time decay and more frequent compounding opportunities. Monthly puts offer higher absolute premium per trade and less management overhead. Many traders use a combination — weeklies for high-conviction names and monthlies for lower-maintenance positions.
Start Analyzing Weekly Put Options in Excel
Selling weekly put options for income requires systematic analysis of option chains, Greeks, and risk parameters. MarketXLS brings all of this data directly into Excel, allowing you to build custom screening tools, monitor positions in real time, and track your performance over time.
Ready to build your options income strategy in Excel? Explore MarketXLS pricing and plans to get started with real-time option chain data and Greeks analysis.
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.
