Photo from Nitin Potade

Photo from Nitin Potade

Photo from Nitin Potade

Auto suggestion on adjustment of hedging strategy

https://youtu.be/nqWZeSDHMMU

*ALL IN ONE - 10 MOST FAVOURITES FILES BY NITIN POTADE*

Click on the link to get the free link for the access

https://docs.google.com/spreadsheets/d/1KOZ2ghE2JpHAmI8esXQnYvpxHZvegR6nqRWYup60sRo/edit?usp=sharing

Please share it with your friends and other WhatsApp group and cooperate.

In the latest interview by Vivek Bajaj ji, CA Bijay Sharma had explained the use of the Open interest data for Option trading. He had explained the process to do data study of the open interest. I have tried to make it semi automatic to minimise your efforts and to save your time. Please watch the interview to understand the use of data for your self study. The link to the youtube video is given below. Please write your comment on the video so many traders will be benefitted.
BankNifty Trading Strategy using VWAP, AVWAP by a CA
https://youtu.be/xliamopkviw

The excel file is attached. It is difficult to open file on mobile. Download it on laptop or desktop and share your experience.
Thanks.

MY_DATA.xlsm

*Price & Volume BreakOut on Weekly Chart.*

1.NOCIL
2.GHCL
3.TIMETECHNO
4.VOLTAMP
5.OIL
6.JKIL
8.WELNET

Please check.

*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