Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"I just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"And by the way, have to say this. I love the IQFeed software. It's rock solid and it has a really nice API." - Comment from Thomas via RT Chat
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Archive (2017 and earlier) »IQFeed Developer Support »Open Interest - One More Time
Author Topic: Open Interest - One More Time (6 messages, Page 1 of 1)

shortorlong
-Interested User-
Posts: 16
Joined: Jan 31, 2008


Posted: Feb 12, 2008 01:40 AM          Msg. 1 of 6
My application is successfully computing implied volatility and the greeks - very cool..

I do not yet have a plan for calculating Open Interest for options.

Open interest is defined as 'The amount of outstanding contracts on a specific underlying security.'

It is not the same as Volume because it only counts the sum of (BuyToOpen + SellToOpen orders) - (BuyToClose + SellToClose orders).

I may be able to tally this value by looking at tick-data, but for 50 000 option symbols just for the Nasdaq, that is a LOT of tick data. It's prohibitively too much (I only pull minute-based data because I look at all 50 000 symbols).


So - How can I calculate open interest for options? How are other IQFeeders doing this? Does it exist somehow in historic or streaming pulls and I just haven't found it? If not, can IQFeed provide guidance on if/when they can add this to their data?

Extremely grateful for any help..

dkobelt
-Interested User-
Posts: 14
Joined: Jan 2, 2007

Can I have More Data please? :)


Posted: Feb 12, 2008 09:12 AM          Msg. 2 of 6
The Open Interest is supposed to be the open interest.... The number of contracts out there. I thought DTN had that information. It seems to have changed.

Other sources do show the correct Open Interest. For example,
http://www.optionsxpress.com/OXNetTools/Chains/index.aspx?SessionID=&Symbol=AAPL&Range=4&lstMarket=0&ChainType=&AdjNonStdOptions=OFF&lstMonths=&FromVB6=True

That shows the Open interest for SPY DK as 12,780 contracts.

The odd part is that this information has been screwed up by DTN (in my opinion) for a while now. We were getting the true number, now I only have the true number for stocks starting with letters from A to D. I am trying to find another data source where I can get this information reliably.

I appreciate the difference between Volume (what really is traded) and Open Interest (what is out there). I was both items. I WAS getting this from DTN.

I am now looking for a data service that WILL give this to me again.... and then I wont have to fight with mysterious changes anymore. Yes, I'm disappointed. I've openly lost my interest in DTN. ;)

DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Feb 12, 2008 11:32 AM          Msg. 3 of 6
IQFeed does carry open interest as a field. We don't store historical OI data on equity options however (we do for futures). If you can provide more data about what you are missing, it would help us to look into it.

The example you gave mentioned that SPY DK has 12,780 for OI. We actually match CBOE for SPY DK which is The April 2008 Calls with a 115 strike. The OI is 56. Could you have meant SFB DK, which we do show an OI of 12780 (again, matching CBOE)?

Jay Froscheiser
DTN - Trading Markets

shortorlong
-Interested User-
Posts: 16
Joined: Jan 31, 2008


Posted: Feb 12, 2008 04:21 PM          Msg. 4 of 6
Ah, if I understand correctly then, open interest is included with the streaming real-time quote, but not included in the history database, is that correct?

DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Feb 12, 2008 04:22 PM          Msg. 5 of 6
That is correct.

Jay Froscheiser
DTN - Trading Markets

shortorlong
-Interested User-
Posts: 16
Joined: Jan 31, 2008


Posted: Feb 12, 2008 09:16 PM          Msg. 6 of 6
I've just finished testing grabbing open interest from the streaming feed instead of the historical feed and it works great. I've never look at the streaming feed until now, but it seems to provide all I'll need.

Thanks Jay, I'm good to go for now.
 

 

Time: Sun April 28, 2024 5:29 PM CFBB v1.2.0 11 ms.
© AderSoftware 2002-2003