Live Nifty Options Open Interest Monitoring Tool

S

santhosh2010

Banned
#1
#1


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
 
S

santhosh2010

Banned
#2
#2
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

a1b1trader

Well-Known Member
#3
#3
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

option writer

Banned
#4
#4
santhosh2010 said:


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 ...:cool:
Click to expand...
 
Rish

Rish

Well-Known Member
#8
#8
option writer said:
santhosh2010 said:


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 ...:cool:
Click to expand...

That is for marketing purpose, indirectly he has called clients for the blogspot.
Click to expand...
 
a1b1trader

a1b1trader

Well-Known Member
#9
#9
Nirahjan said:
option writer said:
That is for marketing purpose, indirectly he has called clients for the blogspot.
Click to expand...
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.
Click to expand...
 
Rish

Rish

Well-Known Member
#10
#10
a1b1trader said:
Nirahjan said:
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.
Click to expand...
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.
Click to expand...
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
P How to get live options data for nifty and banknifty from upstox api to excel or any database? Data Feeds 0
S Sgx Nifty live chart Introductions 0
B Live Trading Journal - Nifty Futures Derivatives 0
I CNX NIFTY INDEX with live ticker Day Trading 4
P About nifty options, future & delivery buy sell signal software Introductions 3

Similar threads