Long Put Option Strategy: Managing and Tracking

Published
Long Put Option Strategy-Managing And Tracking - options strategy analysis and payoff diagram in Excel with MarketXLS

What is a long put option strategy?

A long put is a bearish trade where you buy one put option and profit if the stock falls below the strike price minus the premium you paid. The maximum loss is the premium. The maximum profit is large but capped, because a stock cannot fall below zero: it equals the strike price minus the premium, per share. Breakeven at expiration is the strike price minus the premium. It is one of the simplest options strategies and a common starting point for beginners.

Compared with short selling, a long put caps your loss at the premium, while a short sale has unlimited loss if the stock rises. However, there are certain things you should keep in mind to make the most out of options trading as a whole. The premium and implied volatility drive the result. Out-of-the-money puts cost less but need a bigger drop to pay off. Buying when implied volatility is already high makes the put expensive, while a rise in implied volatility after you buy increases the put's value.
I will explain the strategy with the help of an excel template provided by marketXLS and discuss the possible scenarios.

Tracking a long put with MarketXLS

MarketXLS is an add-in for Microsoft Excel that pulls stock and options data into a spreadsheet (real-time on the Advanced and Business plans, delayed or end-of-day on Standard). Apart from this, it also provides templates to manage and track Long Put options trades for different strategies. Here, I have used Microsoft(MSFT) options as an example. This trade is not taken in real, and it is just for explaining. As I am writing this article, the MSFT shares are trading at $239. Let’s assume that the trend will be bearish in the next couple of days. Therefore, we bought a put option at $230, which will expire on 5-Feb-2021. The premium paid for one contract (100 shares) at $2 per share is $200.

##** Profit, loss, breakeven**

We have bought an out of the money contract (100 shares) of MSFT with a strike price of $230 at a premium of $2. Let’s have a look at the possible scenarios:
1. Let’s say my assumption was right, and the stock moved down, say to $225. The intrinsic profit would be that is $500 and the net profit would be

that is $300. The profits will keep increasing with the stock moving downward.
2. If the stock moves in the other direction or doesn’t move, the contract will be deemed worthless, and my net loss would be the premium that is $200. This is the maximum loss I am going to make in this trade.

The breakeven point would be $228.

Profit grows as MSFT falls below $228, up to a maximum of $22,800 if the stock went to zero. The loss is limited to $200 if the stock finishes at or above the $230 strike.

**The bottom line **To end the article, long-put is a beginner level strategy. The capital required will vary with the profit expectations. But the foremost driving force in this strategy would be the Volatility of a particular underlying. The loss is limited to the premium, which is the main advantage over short selling the stock. This article is educational, not investment advice.

##DisclaimerNone 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.

##** References**

Learn more about long put OptionsTrading.org long-put guide.

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.
I use MarketXLS to manage my personal portfolio. I can easily pull in stock quotes, betas, and dividends. I also like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

•

Associate Professor of Finance, Penn State University

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

I can now concentrate on manipulating financial data, valuing stocks and making investment decisions, rather than hacking around with VBA or copying and pasting data from websites.

Samir Khan

•

InvestExcel.net

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year.

Kirubakaran K.

•

Investment Professional

I Love My MarketXLS. The market speaks to you when you know how to listen. With MarketXLS, the market truly does speak. Patterns emerge. Pricing behavior becomes clearer.

Don Zelezny

•

Entrepreneur & Options 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