Live Nifty Options Open Interest Monitoring Tool

[msultan]

Hello Santosh,
Where to download updated version ?

Image posted Today @ 10:35 AM is has more info, but download gives image yesterdays post.

Thanks and keep up the good work.

MS

 

[santhosh2010]

Hello Santosh,
Where to download updated version ?

Image posted Today @ 10:35 AM is has more info, but download gives image yesterdays post.

Thanks and keep up the good work.

MS

Download here :-

http://www.mediafire.com/download/z1qvt45a5ixv9xt/OI+data.xlsx

 

[nune_siva]

SANTOSH ANNA,
Your excel sheet studies calls and Puts seperately on their parameters.
I wish to know from you - Is it more revarding to study a particular strike say 7900 call in conjuction with 7900 put ,ananyse call open interest change in relation to put open interest change and come to conclusion on trend. Something like the image attached.

Pls give your view. Eagerly waiting
Rgds

Siva Prasad

 

[nune_siva]

Santosh anna,

Awaiting your suggestions eagerly

 

[santhosh2010]

Santosh anna,

Awaiting your suggestions eagerly

Raj sir already explained the details about "OI change" based analysis..

Kindly download this attachment and understand about the OI theory...

Downlaod link :-

http://goo.gl/wL3QDv

 

[nune_siva]

Santosh anna , would you take some time out to prepare an excel sheet
to monitor change in oi and volume in conjuction to specific Call and put .

For index and F& O STOCKS.

Regards

Siva Prasad

 

[manoj2012]

Dear Santoshji,

I have 2 queries -

1) How PCR is calculated ?
Is it -
Volume PE (aggregate all strikes) / Volume CE (aggregate all strikes)
or
OI PE (aggregate all strikes) / OI CE (aggregate all strikes)
or
some other formula.

In your open interest chart - Intraday Trend is shown as UP whereas OI Trend is shown as STRONG BEAR.

What is major difference between Intraday Trend and OI Trend and how do we interpret the two.

Thanx

 

[mvkarthik]

Santosh sir
can u please make tool for usdinr

http://www.nseindia.com/live_market/dynaContent/live_watch/fxTracker/optChainDataByExpDates.jsp

thanks

 

[iris1in]

Dear Santosh,

I am using Windows 8.1 with Microsoft Office 2007, having difficulty using the excel sheet at it failed to refresh and resulting #N/A is every column of the excel sheet. Please help me in this to correct the issues.

Regards,
iris

 

[iris1in]

Hello Sir,

Would you be able to help me out for solving the Excel error while accessing the excel sheet. Your help in this regard is much appreciated.

Regards,
iris