Bull Put Options Strategy

Bull Put Options Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

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.

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.

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

MarketXLS options research demonstration

Loading this content connects to its provider, which may use cookies or similar storage.

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