Boost Your Profits with Put Option Strategies
Put option strategies let you profit from a falling stock (buying puts), collect premium when you expect a stock to hold steady or rise (selling puts), or protect shares you already own (protective puts). Each has a different risk: a put buyer can lose the full premium paid, while a put seller can lose much more if the stock falls sharply. This article explains how each strategy makes money, the main risks, and how MarketXLS option data and templates help you track them in Excel. It is educational, not investment advice.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
What is Put Options Trading?
Put options are derivatives which give you the right to sell an underlying asset of a particular price and date. So, when you buy puts, you are investing in the expectation that the price of the underlying asset will fall lower than the strike price. Put options are often used for risk management, hedging and to create income through leveraging the put option contract.
How Do You Profit from Put Option Strategies?
A common put option strategy is selling puts. When you sell a put, you collect the premium and expect the underlying asset to stay above the strike price. If it does, the put expires worthless and you keep the premium. If the price falls below the strike, you may be assigned the shares and take a loss that can be much larger than the premium collected.
Another form of put option is the long put option strategy. In this strategy, you buy put options, expecting the price of the underlying asset to drop so that you can make a profit. However, investing in put options also carries more risks than other forms of investments because, as mentioned before, if the price of the underlying asset rises then the investor can accumulate a loss.
Risk and Reward Ratio for Put Options
The risk of a put strategy depends on which side you take. A put buyer's maximum loss is the premium paid, and the profit grows as the stock falls toward zero. A put seller's maximum gain is the premium, and the loss grows as the stock falls. Volatility raises put premiums, and leverage (one contract controls 100 shares) magnifies both gains and losses.
How MarketXls Can Help You with Investing in Put Options
MarketXLS is an Excel add-in that brings option chains, option prices, and Greeks into your spreadsheet, for example with =QM_GetOptionChain("AAPL"). You can use MarketXLS templates to model put strategies and track the risk and reward of each position. MarketXLS is a data tool, not a broker, so orders are placed with your brokerage. Options data is end-of-day on the Standard plan and real-time streaming on the Advanced and Business plans.
Conclusion
Put option strategies can generate income or hedge a portfolio in falling and volatile markets, but none of them is guaranteed to be profitable. They require an understanding of volatility, assignment risk, and position sizing. MarketXLS provides the option data and Excel templates to model these trades before you place them.
Relevant blogs that you can read to learn more about the topic
Selling Weekly Put Options For Income (With Professional Risk-Management)
Options Trading for Passive Income
How To Manage Risk When Trading Options For Income
How To Use Options Trading As An Income Generation Strategy (With Ease)
Craft Your Own Strategy with Active Options Trading