Live Nifty Options Open Interest Monitoring Tool

[santhosh2010]

Here is a simple Excel tool to monitor the Live Nifty Options Open Interest. Apart from Monitoring the Open Interest of Puts and Calls you can also monitorthe change in Open Interest for both puts and callls across the strike prices for that day. Tested in Excel 2007 & Excel 2010.

Download link

http://www.4shared.com/file/3OIUZjP2/Nifty-options-open-interest-Oc.html

 

[santhosh2010]

OPEN INTEREST & VOLUME

Open Interest (also known as Open Contracts or Open Commitments) refers to the number of active or open contracts for any given security. It applies to the futures and options markets but not to stocks.

In the futures market it refers to the total number of contracts long or short in a delivery month or market that has been entered into and not yet liquidated by an offsetting transaction or fulfilled by delivery. Each open transaction has a buyer and a seller, but for calculation of open interest, only one side of the contract is counted.

The open-interest position that is reported each day for a given market shows the increase or decrease in the number of contracts for that day in the form of a positive or negative number.

It is one of the foremost tools for confirming trends and forecasting trend reversals in the futures market.

- Open interest rising along with prices is a bullish indicator that an uptrend is in progress and is likely to be sustained. It shows that new money is entering the market.

- Falling open interest and rising prices is a bearish indicator, suggesting that the rise is being caused by short sellers covering their positions. The upmove is unlikely to be sustained because new buyers are not entering the market.

- Open interest in a sideways market can suggest a breakout in either direction

- A rise in open interest in a falling market suggests that a downtrend is in place. New money is entering the market through short sellers.

- When both open interest and prices are falling, this suggests that the longs are closing out their positions, indicating a trend reversal and an upward movement in price.

- Static open interest along with rising or falling prices suggests a possible market top or bottom and trend reversal.

Volume is often used along with open interest. Volume refers to the number of contracts that have to have been traded within a given session. Volume precedes price. The higher the volume traded, the more likely a trend will continue. Rising open interest confirms that new money is supporting the prevailing trend.

 

[a1b1trader]

Hi Santosh
Thanks for the excel tool.
I just want to know that this tool is for ever or on monthly basis (as suggested by the name of the download file) and you will post the link for november 2012 soon.
Thanks

 

[option writer]

Here is a simple Excel tool to monitor the Live Nifty Options Open Interest. Apart from Monitoring the Open Interest of Puts and Calls you can also monitorthe change in Open Interest for both puts and callls across the strike prices for that day. Tested in Excel 2007 & Excel 2010.

already this tool in traderji forum by made other member ,now u r repaint it with ur logo..
so many members using currently and also u r taken from this data from NIFTY OPTION CHAIN BY NSE SITE..
Already nse gives 1 min delay ...

 

[pakatil]

This is my own Tool. Not copied one .....

 

[adesara]

Where is the download link pl?

 

[a1b1trader]

Download link

http://www.4shared.com/file/3OIUZjP2/Nifty-options-open-interest-Oc.html

See the post carefully
Download link is given there
http://www.4shared.com/file/3OIUZjP2/Nifty-options-open-interest-Oc.html

 

[Rish]

Here is a simple Excel tool to monitor the Live Nifty Options Open Interest. Apart from Monitoring the Open Interest of Puts and Calls you can also monitorthe change in Open Interest for both puts and callls across the strike prices for that day. Tested in Excel 2007 & Excel 2010.

already this tool in traderji forum by made other member ,now u r repaint it with ur logo..
so many members using currently and also u r taken from this data from NIFTY OPTION CHAIN BY NSE SITE..
Already nse gives 1 min delay ...

That is for marketing purpose, indirectly he has called clients for the blogspot.

 

[a1b1trader]

That is for marketing purpose, indirectly he has called clients for the blogspot.

No, I do not think so.

Santhosh2010, is an helpful member and he has posted/shared a good amount of useful stuff at traderji.

And even at his blog he has posted a lot of data, lot of excel sheets and lot of AFLs and such stuff for free, without any consideration for money or such thing. Its a different thing that the blog is not being updated, regularly, these days.

 

[Rish]

No, I do not think so.

Santhosh2010, is an helpful member and he has posted/shared a good amount of useful stuff at traderji.

And even at his blog he has posted a lot of data, lot of excel sheets and lot of AFLs and such stuff for free, without any consideration for money or such thing. Its a different thing that the blog is not being updated, regularly, these days.

Fine. My point is, so many marketing activities are going on indirectly. Many innocent beginners use to cheat very easily by colorful past performance and giving free stuff (which is available already in Traderji Forum) to save there image.

Anyway, this is my view.