Bull Put Options Strategy

A bull put spread is a bullish credit spread: you sell a put at a higher strike and buy a put at a lower strike on the same underlying with the same expiration. You collect a net credit up front. The maximum profit is that credit, earned if the stock closes at or above the higher strike at expiration. The maximum loss is the difference between the strikes minus the credit. A bull put spread is a limited profit, limited risk strategy.

See it in actionMarketXLS video

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
Bull Put Options Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

In this video we will be discussing:

  • What Bull Put Spread is

  • How it works

  • How it is calculated using Marketxls

Use the Bull Put Spread Excel template to model the payoff.

Read the Bull Put Spread Excel walkthrough for a worked example.

About the authors
Anagh

About Anagh

CTO, MarketXLS

Anagh is the CTO of MarketXLS. He works with Ankur and Robin on the MarketXLS blog, creating articles together about market data and spreadsheet workflows.

Written collaboratively by Anagh, Ankur and Robin.

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.

The Professional Investment Platform Inside Excel

Market data and options research tools in Excel

  • Option prices and Greeks in Excel
  • Historical options data in Excel
  • US stock and index options data
  • Prices and data on underlying stocks and indices
  • Use MarketXLS formulas in your Excel worksheets
  • Explore options research workflows in Excel
  • Excel formulas and sample worksheets

See MarketXLS in action

Bring this workflow into Excel.

Book a demo with our team to see how MarketXLS supports your market research.

Ankur
AnkurFounder & CEO, MarketXLS
Book a demo