Max Open Interest for Call option

General
1

Hello,

Is there any website or tool which gives details of strike price of Calls with Max OI for all the stocks?

Thanks.

2


This may help you.

3

Download Bhavcopy then use excel formulae

4

Thanks.

5

bhavcopy doesn’t have max OI for calls and put data, Just verified it. Is there any other way?

6

From Bhavcopy, filter OPTSTK in first row, filter expiry date, filter CE

Then copy that data in new sheet

Create pivot table on same - with left side “Stock name” and right side “Max of Open Int”

If you want strike price also, you need to google, I dont know Excel that well lol, but it should be possible too

7

Thanks a lot I was trying to look into cash market bhavcopy. Anyway, got my work done. You will need to use vlookup after the steps you mentioned.