All About Credit Spreads (Explained With Examples)

Written by  Shubham Shah on 
Mon Nov 30 2020
 • Last updated 
Mon Jan 09 2023
 about OptionsOptions strategies
All About Credit Spreads (Explained With Examples) - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
All About Credit Spreads (Explained With Examples) - MarketXLS

A credit spread involves purchase of one option (call or put) & the sale of another option, both with the same maturity and underlying security but with a different strike price. The main reason why this strategy is called a credit spread is because it involves net inflow of premium from the two positions involved in this strategy (for example, by selling a put with a higher premium and purchasing another put option with a lower premium).

The basic idea here is the transfer of credit risk from one party to another. This can be used as a risk management tool by option traders at the cost of giving up a limited amount of profit potential.

There are 2 types of credit spreads, differentiated based on whether the trader has a bullish or bearish stance on the underlying security. These are:

  1. Credit put spread
  2. Credit call spread

Credit put spread

Also known as the Bull put spread, this strategy involves the sale of a put option with a higher strike price (thus a higher option premium) and buying another option with a lower strike price (thus involves a lower option premium).

As the name suggests, one will use this strategy if he/she is of the opinion that the price of the underlying security will rise in future. The basic objective here is to take option positions in such a way so that both of them expire unexercised, leaving us the difference between the option premiums. Now we will look at an example to make things clear for you

Example:

Suppose I am bullish on a stock & the stock is trading at $40. To apply the strategy I will then sell a put option contract with a strike price of $45 for a cost of $4.75 and buy one put option contract with a strike price of $40 for $1.75, both for the same time period (let’s say a year). In this case, I will receive a total of $3 per share to set up this strategy ($4.75 – $1.75 i.e. $3). So now, what could be the possible cases that might arise at the end of the year?

Stock Price at Expiration Short 45 Put Profit/(Loss) at Expiration Long 40 Put Profit/(Loss) at Expiration Bull Put Spread Profit/(Loss) at Expiration
47 4.5 -1.5 3
46 4.5 -1.5 3
45 4.5 -1.5 3
44 3.5 -1.5 2
43 2.5 -1.5 1
42 1.5 -1.5 0
41 0.5 -1.5 -1
40 -0.5 -1.5 -2
39 -1.5 -0.5 -2

 

Case 1: When the stock price is above the higher strike price

Let’s say that the stock price is $46. In such a case, we can’t exercise our put option thus we subtract 1.5 from our calculation of the final position. At the same time, the party which bought the option from us also won’t exercise the option thus we add 4.5 to the calculation which leaves us with a profit of $3.

Case 2: When the stock price is in between the higher & lower strike price.

Let’s say that the stock price at the end is $41. In such a case, the other person will exercise his option, leaving us a total of $0.5, after including option cost (i.e. $4.5 – $4). On the other hand, we won’t exercise the put option, thus subtracting $1.5. This leaves us with a loss of $1.

Case 3: When the stock price is below the lower strike price

Let’s say that the stock price is $39. In this case, the value that we derive from our short put position is -$1.5 (i.e. $4.5 – $6). Also, we lose $0.5 (i.e. $1 – $1.5) from our long put position. This leaves us with a loss of $2.

Credit Call Spread

Also known as the Bear Call Spread, this strategy involves the sale of a call option with a lower strike price (thus a higher option premium) and buying another option with a relatively higher strike price (thus involves a lower option premium). As the name suggests, one will use this strategy if he/she is of the opinion that the price of the underlying security will fall in future. The basic objective here is to take option positions in such a way so that both of them expire unexercised, leaving us the difference between the option premiums (per share). Again, we will look at an example to make things clear for you

Example:

Suppose I am bearish on a stock & the stock is trading at $40. To apply the strategy I will then sell a call option contract with a strike price of $40 for a cost of $4.75 and buy one call option contract with a strike price of $45 for $1.75, both for the same time period (let’s say a year). In this case, I will receive a total of $3 per share to set up this strategy ($4.75 – $1.75 i.e. $3). So now, what could be the possible cases that might arise at the end of the year?

Stock Price at Expiration Short 40 Call Profit/(Loss) at Expiration Long 45 Call Profit/(Loss) at Expiration Bear Call Spread Profit/(Loss) at Expiration
47 -2.5 0.5 -2
46 -1.5 -0.5 -2
45 -0.5 -1.5 -2
44 0.5 -1.5 -1
43 1.5 -1.5 0
42 2.5 -1.5 1
41 3.5 -1.5 2
40 4.5 -1.5 3
39 4.5 -1.5 3

 

Case 1: When the stock price is above the higher strike price

let’s say that the stock price is $47. In such a case, the other party will exercise its call option Thus we will have to subtract $2.5 from our final position (i.e. $4.5 – $7). Similarly we will also exercise our call option, leaving us with $0.5 from this position. (i.e. $2 – $1.5). Considering both the positions, we incur a loss of $2.

Case 2: When the stock price is in between the higher & lower strike price.

Let’s say that the stock price at the end of the period is $41. In such a case, the other person will exercise his option, leaving us a total of $3.5, after including option cost (i.e. $4.5 – $1). On the other hand, we won’t exercise the call option, thus subtracting $1.5 from the final value. This leaves us with a profit of $2.

Case 3: When the stock price is below the lower strike price.

Let’s say that the stock price is $39. In this case, the value that we derive from our short call position is $4.5. Also, we lose $1.5 from our long call position. This leaves us with a profit of $3.

 

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

References:

  1. https://www.investopedia.com/terms/c/credit-spread-option.asp
  2. https://www.youtube.com/watch?v=sZrMhrmhDCQ

 

 

 

 

#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.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

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

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Related Formulas

No related formulas found.

Related Templates

No related templates found.