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
"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'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.
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
"I used to have *******, but they are way more money for the same thing. I have had no probs with data from DTN since switching over." - Comment from Public Forum Post
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
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 3, 2024 8:57 AM CFBB v1.2.0 14 ms.
© AderSoftware 2002-2003