Short Put Ladder Options Strategy (Using Excel Template)

Introduction

The Short Put Ladder is a limited risk, unlimited profit strategy in options trading that is employed when the trader thinks that the underlying security will experience significant volatility in the near term. A Short Put Ladder should be executed when one is expecting big movement in the underlying security price, favorably downside.

Short Put Ladder

The Short Put Ladder is named as such because its payoff diagram looks like a ladder and it is initiated with Puts. In short, the Short Put Ladder is an options trading strategy that uses Put options to implement a trade that will capitalise on the increased volatility of the price of the underlying asset. It is a strategy with limited loss potential and unlimited profit potential.

Short Put Ladder Construction

To implement and execute this strategy, the trader will trade in three different contracts. The strike prices can be customized as per the suitability of the trader.

The three trading contracts will be:

  • Selling 1 ITM (in the money) Put option
  • Buying 1 ATM (at the money) Put option
  • Buying 1 OTM ( out the money) Put option

To set up the Short Put Ladder, the options trader sells an in-the-money Put, buys an at-the-money Put and buys another lower strike out-of-the-money Put of the same underlying asset and expiration date. A trader can also initiate the Short Put Ladder strategy in the following way – Selling 1 ATM Put, Buying 1 OTM Put and Buying another 1 Far OTM Put.

Profit Potential

The maximum profit is limited to the initial credit received if the stock price rises above the upper breakeven point but large unlimited profit can be realised if the stock price makes a dramatic move to the downside below the lower breakeven point.

The further the price of the underlying security goes below the lower breakeven point, the greater is the realisable profit. Hence, there is unlimited profit potential as the price decreases. As the price of the underlying asset increases above the upper breakeven point, so does the realisable profit. However, at some price point above the breakeven point, the profit stays constant. This constant profit is shown as a horizontal line on the payoff diagram. This maximum profit is also the net credit received.

Maximum profit can be calculated with the formula:

Profit realised When Price of Underlying < Total Strike Prices of Long Puts – Strike Price of Short Put + Net Premium Received

Profit = Lower Breakeven – Price of Underlying

Maximum Profit = Unlimited

Limited Loss

Maximum loss for the Short Put Ladder strategy is limited and occurs when the underlying stock price on expiration date is trading between the strike prices of the Put options bought. At this price, while both the short Put and the higher strike long Put expire in the money, the short Put is worth more than the long Put, resulting in a loss. The loss can be calculated using the formula below.

Maximum loss can be calculated with the formula:

Max Loss = Strike Price of Short Put option – Strike Price of Higher Strike Long Put option – Net Credit Received + Commissions Paid

Max Loss Occurs When Price of underlying security is trading in between the Strike Prices of the 2 Long Puts

Breakeven Points

The Short Put Ladder position has 2 Breakeven points:

short put ladder breakeven points
  • Lower Breakeven Point = Total Strike Prices of Long Puts – Strike Price of Short Put + Net Premium Received
  • Upper Breakeven Point = Strike Price of Short Put – Net Premium Received

Applying Short Put Ladder Strategy Using MarketXLS Template With an Example:

MarketXLS software is a one-stop solution for the analysis of your entire investments. It provides a host of functions like eps, various ratios, key fundamentals, historical data, options pricing and much more to assess the value of your investments. It provides a variety of templates for various options trading strategies and also to compare your portfolio stocks for doing a better analysis of your investments.

Step 1: Enter the stock ticker in cell C6 and press enter. The template will provide the upcoming expiry dates for the stock, current market price, and lot size. Select any one of the expiry dates and change the lot size according to your preference.

short put ladder template

Link to the Template: https://www.marketxlswp.com/template/short-put-ladder/

Step 2: Enter the ATM strike price in cell C10.

Step 3: Enter the Spread (Difference between higher and lower strike price) in cell C11.

Step 4: The template might ask you to refresh. Go to the MarketXLS tab in the ribbon > Refresh All. Click on Refresh All.

The template uses the bid price for sells and ask price for buys and related premiums to calculate the net cash flow for you.

short put ladder payout table

Step 5: The template also provides the Net Payoff Profile of the strategy. You need to enter the expected minimum and maximum expiry prices for the period. It will calculate the net profit or net loss for all the levels of expiry prices and present it graphically.

Microsoft Corporation (MSFT) as an example in the above template: 

MSFT stock is trading at levels of $260 on 16th June 2021. I have selected the upcoming expiry of   July 2, 2021 to enter the trade. I want to execute a Short Put Ladder strategy by buying an ATM Put @$260 and maintaining a spread of $10. Thus I would be buying another OTM Put @$250 and selling an ITM Put @$270. 

The template will calculate the premium amounts for all the options and thus calculate the net cash flow for entering the trade, which is $550 credit in this case.

[ -1.1*100 ($250 strike) – 3.95*100 ($260 strike) + 10.55*100 ($270 strike) = +$550 ]

Suppose if the stock keeps trading at $260 on expiration date, only the Short Put will expire in money with an intrinsic value of $1000. Taking into account the initial credit of $550, buying back this put to close the position will leave me with a $450 loss, which is also my maximum possible loss.

If the stock trades at $270 on expiration, all the Puts will expire worthless and my profit will be the initial $550 received while entering the trade.

However, if the stock price drops to $236, all the Put options will expire in money. The Long Put option ($260) will expire with $2400 intrinsic value while the Long Put option ($250) will expire with $1400 value. Buying back the Short Put at this level will cost me $3400. That will still leave me with a profit of $400. Adding the initial credit received, my total profit will be $950. This profit will even be greater if the stock price dives below $236. The net profit can easily be determined by looking at the net payoff table within the template.

Here is a video explaining the Short Put Ladder Strategy using MarketXLS:

https://youtu.be/dMNBDQl7sNU

Bottom Line

A Short Put Ladder position is best to execute when you are confident about an underlying security moving significantly lower. Another scenario wherein this strategy can give profit is when there is a surge in implied volatility. It is an unlimited reward and a limited risk strategy only if movement comes on the lower side or else reward would also be limited.

Disclaimer

All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own, or affiliation with the trademark owners.
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 for helping 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.

Reference

https://www.theoptionsguide.com/short-put-ladder.aspx

https://www.5paisa.com/blog/short-put-ladder-strategy-explained

Image Source

https://optionsmanual.com/high-volatility-strategies/short-put-ladder-profit-from-increased-volatility/

Verelq News |
13.04.2024

alexistogel macau

alexistogel

link alexistogel

alexistogel slot

situs alexistogel

alexistogel rtp

situs alexistogel

link alternatif alexistogel

alexistogel gacor

bandar alexistogel

alexistogel

alexistogel

alexistogel 4d

alexistogel terpercaya

alexistogel gacor

alexistogel

alexistogel 4d

alexistogel

alexistogel

slot alexistogel

alexistogel gacor

alexistogel terpercaya

agen togel online

link alexistogel

alexistogel toto

alexistogel resmi

alexistogel

alexistogel rtp

situs alexistogel

bandar alexistogel

alexistogel

alexistogel slot

link alexistogel

agen alexistogel

alexistogel

alexistogel macau

alexistogel

alexistogel

alexistogel

alexistogel slot

alexistogel

alexistogel terpercaya

alexistogel togel slot

alexistogel

alexistogel gacor

alexistogel

alexistogel terpercaya

link alternatif alexistogel

alexistogel online

alexistogel

alexistogel gampang menang

alexistogel 4d

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

syair togel

alexistogel

شرط بندی پرسپولیس شرط بندی استقلال شرط بندی روی تراکتورسازی تبریز شرط بندی روی سپاهان شرط بندی رئال مادرید بارسلونا شرط بندی شرط بندی psg سایت شرط بندی جام جهانی شرط بندی جام جهانی 2026 سایت شرط بندی جام جهانی 2026 بازی انفجار رایگان سایت انفجار ضریب بالا بهترین سایت شرط بندی فارسی شرط بندی بدون فیلتر شرط بندی بازی رولت شرط بندی پوکر شرط بندی مونتی شرط بندی سنگ کاغذ قیچی شرط بندی بلک جک کرش رویال بت پاسور شرط شرط بندی تخته نرد آنلاین انفجار 2 بت شرط بندی بازی اسلات شرط بندی بازی پوپ سایت سامان بت ریور پوکر 2024 سایت 4030bet ورود به بازی انفجار دنس بت شرط بندی انفجار دنس آموزش بازی پوکر سایت شرط بندی 123 بهترین شرط بندی بهترین سایت شرط بندی انفجار اپلیکیشن بازی انفجار دانلود بازی انفجار انفجار بازی ربات بازی انفجار کازینو آنلاین ایرانی انفجار پولساز ورود به بازی انفجار بازی انفجار با شارژ 10 تومن سایت bet betyek وان ایکس برو آدرس سایت بت یک سایت دوست دختر اونلی فنز فارسی پیدا کردن دوست دختر ورود به ریور پوکر پدرام مختاری پویان مختاری نازنین همدانی مونتیگو داوود هزینه بیوگرافی آیسان اسلامی بیوگرافی دنیا جهانبخت سایت رسمی حسین تهی بیوگرافی کوروش وانتونز سایت آرتا وانتونز رها وانتونز بیوگرافی ربکا قادری سحر قریشی بیوگرافی تتلو بیوگرافی مهدی طارمی الناز شاکردوست سایت عادل فردوسی پور بیوگرافی نیلی افشار بیوگرافی محمدرضا گلزار سایت armin2afm بیوگرافی شادمهر عقیلی بیوگرافی سردارآزمون بیوگرافی علیرضا بیرانوند بیوگرافی رامین رضاییان وریا غفوری بیوگرافی علی دایی بیوگرافی پوریا پوتک مدگل سایت حصین بیوگرافی صدف طاهریان فرشاد سایلنت بیوگرافی آریا کئوکسر بیوگرافی sogang بیوگرافی میا پلیز بیوگرافی مهراد هیدن سایت رسمی سهراب ام جی بیوگرافی علیرضا جی جی بیوگرافی بهزاد لیتو اشکان فدایی بیوگرافی رضا پیشرو بیوگرافی گلشیفته بیوگرافی هیپ هاپولوژیست بیوگرافی سارن بیوگرافی آدام مرادی بیوگرافی محمد هلاکویی بیوگرافی علی حسنی سایت رسمی علی حسنی بیوگرافی ساسی خواننده بیوگرافی ابی باربد معصومی حسینی فایننس بیوگرافی امیرحسین نام آور بیوگرافی امین فردین بیوگرافی فرزاد وجیهی سایت سیب بت سایت jetbet آدرس جدید بت فوروارد وان ایکس بت سایت abt90 بازی انفجار سایت شرط بندی فاز بت بهترین سایت شرط بندی انفجار ورود به آلپاری آلپاری فارکس آدرس بروکر آلپاری بدون فیلتر ثبت نام در بروکر آلپاری فارسی صرافی کوکوین ربات فارکس بهترین سایت تتر

alexistogel toto online

bandar alexistogel

alexistogel bandar gacor

alexistogel link

alexistogel online

alexistogel bandar togel

link alternatif alexistogel

alexistogel

alexistogel

alexistogel

alexistogel daftar

alexistogel toto macau

alexistogel bandar macau

alexistogel slot

alexistogel agen slot

alexistogel

situs alexistogel

alexistogel

alexistogel slot

alexistogel

alexistogel

alexistogel

alexistogel bandar slot

alexistogel

Alexistogel Toto Macau

alexistogel

bandar alexistogel

alexistogel slot

alexistogel link alternatif

alexistogel macau

alexistogel

alexistogel toto macau

slot alexistogel

alexistogel bandar togel

alexistogel

alexistogel

alexistogel rtp

alexistogel

alexistogel slot

alexistogel

alexistogel

alexistogel

alexistogel terpercaya

daftar alexistogel

alexistogel online

rtp alexistogel

alexistogel slot

alexistogel gacor

link alternatif alexistogel

alexistogel login

alexistogel

alexistogel slot dana

agen togel online

bandar togel online

alexistogel rtp

alexistogel slot

alexistogel daftar

slot online dana

RTP LIVE

Bandar Toto Macau

Situs Slot Gacor

bandarbola855 resmi

bandarbola855 gacor

bandarbola855 slot

link bandarbola855

bandarbola855 bola slot

bandarbola855 rtp

bandarbola855 slot online

bandarbola855 link

bandarbola855 bandar

bandarbola855 slot terpercaya

bandarbola855

bandarbola855 slot

bandarbola855 terpercaya

bandarbola855 online

slot bandarbola855

bandarbola855 slot

bandarbola855 daftar

bandarbola855 link

bandarbola855

bandarbola855

bandarbola855

bandarbola855 slot

bandarbola855

iosbet

iosbet

link iosbet

slot online iosbet

iosbet link login

slot iosbet

iosbet gacor

iosbet slot

iosbet

slot iosbet

agen iosbet

bandar iosbet

iosbet

iosbet link

bandar iosbet gacor

iosbet

iosbet

liatogel

bandar liatogel

login liatogel

live draw hk liatogel

liatogel slot online gacor

liatogel totomacau

liatogel link

slot gacor

daftar slot online

bandar slot dana

slot ovo

slot gopay