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)




"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"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
"You have an excellent product !!!!!!" - Comment from Arely
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"Just a quick one to say I'm very impressed so far :) The documentation for developers is excellent and I've quickly managed to get an app written to do historical downloads. The system is very robust and pretty quick considering the extent of data that's available. The support guys have been very helpful too, in combination with the forums it's been plain sailing so far!" - Comment from Adam
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
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: Fri May 17, 2024 11:24 PM CFBB v1.2.0 13 ms.
© AderSoftware 2002-2003