*Maximum Open Interest* https://docs.google.com/spreadsheets/ | EQUITY DATA ANALYSIS

*Maximum Open Interest*

https://docs.google.com/spreadsheets/d/1IAXV1cqugWxyACKaJezTgyn5iisFMsbYXplfiBLzXUE/edit?usp=drivesdk
Click on the above link and open the file and copy it in your GoogleDrive. You can rename it also.
You have to do it only once.

Now follow the instruction to get Maximum Open Interest of all stocks.

A ) Get the Historical data from NSE site by clicking the below link.

https://www1.nseindia.com/products/content/derivatives/equities/archieve_fo.htm

Select report as BhavCopy and appropriete date to download the file.

B ) Remove / Delete Unwanted Data like Index Data & other expiry date. It saves our processing time.

C ) Copy the data & paste special it at C1 cell of google file of Work Sheet.

D ) Run Macros PIVOT -1 and PIVOT -2
To do so, Click on Extensions & then Macros.

This will provide list of stocks where Maximum Open Interest of Call is highest from Maximum Open interest of Put.

Please use it for study purposes.
Do subscribe my youtube channel to watch the video for further explanation.
Please share this file with your friends.

Thanks.

*Nitin Potade*
https://m.youtube.com/c/NITINPOTADE