# Option Max Pain Excel – Option Max Pain Calculator FREE

Option Max Pain Excel refers to the way of calculating option max pain in excel sheet. This process is very useful and trade friendly. Option max pain is also known as max pain in options. Read more to know how to download Option Max Pain calculator free.

Max Pain Theory – Option Max Pain calculates outstanding open interest at any point of time and calculates max pain. The theory suggests that before expiration the underlying stock moves to a point where there is maximum loss to option buyers. Before reaching to a conclusion it presumes the following.

1. Buyers of option lose money mostly.
2. Sellers are the institutional players or hedge funds who hedge their position by selling options.
3. Sellers are big players who can induce the underlying to move to a point where the option buyers lose money mostly creating maximum pain for the option buyers.

It is seen that this theory holds true mostly and options traders can gain using this theory as part of the fundamental analysis for the stock price to be at the time of expiry.

### What is Option Max Pain?

• Option max pain theory calculates outstanding open interest of PE (puts) and CE (calls) at any point of time at different strike prices.
• It is calculated for a particular expiry. This calculation will not be valid for other expiries.
• All open interest data are imported to a MS-Excel sheet of all the PEs and CEs at different strike price for particular expiry.
• The max pain is calculated at the strike price where minimum net loss occurs to option sellers.

As seen from the Excel file above and graphical representation thereof, the Max Pain is at 9600 where the combined open interest of PE and CE in minimum. That is Nifty is expected to expire at the strike price of 9600 where the option sellers loss is minimum.

Strategy – We can strategically trade option using option max pain excel in the following ways.

• As Ratio Trade we can take a strategy by selling three lots of 9900 CE and 9300 PE each combining with selling of one lot of 9800 CE and 9400 PE each.
• For a more aggressive strategy, in the last week of expiry we can sell  one lot ATM straddle of  9600 CE and PE and sell two lots of 9800 CE and 9400 PE.
• We can also adopt a strategy of selling one lot of CEs and PEs at different strike prices equidistant from option pain strike price. The strategy should be properly hedged.

Option Max Pain Excel – Option Max Pain Calculator FREE

## 4 thoughts on “Option Max Pain Excel – Option Max Pain Calculator FREE”

1. Vikram says:

Very interesting. Loved it. good luck. I like to get Option Max Pain calculator in excel; and other spreadsheet useful you offer.
Thanks..

1. Vikram at present we dont have an excel version of the same. You can check in our site for the live max pain.

1. mbmcbb says:

Hi Indrajit,
Thanks for your good working and sharing ,in my view people are selling your excel sheet for monthly subscription ; i did not feel good.
I got shocked seeing people selling this as their own product.

1. There will be people who always want to earn money selling freely available things. U can’t help it.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to top