DTN IQFeed, DTN.IQ, DTN ProphetX Support Forums

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)

"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum

"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email

"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

"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

"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum

"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.

"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe

"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post

"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post

"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.

Home

Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather

DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter

»Forums Index »NEW IQFEED FORUMS »New IQFeed Forum »How to get historical expired option chain symbols for past months

Author	Topic: How to get historical expired option chain symbols for past months (10 messages, Page 1 of 1)
denisk -Interested User- Posts: 4 Joined: Apr 9, 2019	Posted: Apr 9, 2019 02:06 AM Msg. 1 of 10 There seems to be no way to get expired option symbols: the CEO request of the TCP/Interface doesn't accept year as parameter and only returns unexpired symbols... What is the best way to get the expired option symbol list? I'm talking just 3 months ago.
DTN_Steve_S -DTN Guru- Posts: 2093 Joined: Nov 21, 2005	Posted: Apr 9, 2019 06:49 AM Msg. 2 of 10 We do not retain these lookup lists historically. The best we can offer is a list of all expired equity options that have traded in the system so you can build these lists on your end. We currently only update this as a manual process every couple months (on demand when customers ask). I have updated it for this morning's file. The file is located on our FTP server here: ftp://www.dtniq.com/beta/IEOPTION.zip Edited by DTN_Steve_S on Apr 9, 2019 at 06:49 AM
denisk -Interested User- Posts: 4 Joined: Apr 9, 2019	Posted: Apr 9, 2019 11:44 AM Msg. 3 of 10 Thanks, that's not so bad at all.
denisk -Interested User- Posts: 4 Joined: Apr 9, 2019	Posted: Apr 10, 2019 03:17 AM Msg. 4 of 10 Dear Steve, Could you please give a hint what are the date columns 4 & 6, they sometimes do not much the expiration date, and it's not clear which is which? Denis
DTN_Steve_S -DTN Guru- Posts: 2093 Joined: Nov 21, 2005	Posted: Apr 10, 2019 05:43 AM Msg. 5 of 10 Denis, the file I updated yesterday has the following header as the first line. Symbol,SecurityType,Description,ExpirationDate,Exchange,LastUpdate Is that consistent with what you are seeing (as I mentioned, this isn't quite a finished offering for us in terms of delivery so it's possible there is still issues with implementation)? By the way, I also found this older thread on the same subject that explains the Expiration Date field is currently intentionally left blank since the same data is embedded in the symbol. I'm not sure if there is extra information that is useful to you in that thread but just in case you're interested, I wanted to make you aware of it. http://forums.dtn.com/index.cfm?page=topic&topicID=3326
denisk -Interested User- Posts: 4 Joined: Apr 9, 2019	Posted: Apr 13, 2019 07:26 AM Msg. 6 of 10 Yes, thank you, this solved my issue. The only one thing I would put on a wishlist is some kind of automation that would update this file every month. P.S. All clear with the expiration date column! My use case doesn't require it, but such a column is extremely useful for filtering through entries without regexp parsing of option symbols (makes a difference: ~ 1min vs 5-7 minutes, when processing the entire file). Edited by denisk on Apr 19, 2019 at 04:26 AM
veng1 -Interested User- Posts: 8 Joined: Oct 8, 2018	Posted: Nov 20, 2019 09:46 AM Msg. 7 of 10 Is there a plan to update this file? It looks like it's been about 6 months.
DTN_Gary_Stephen -DTN Guru- Posts: 394 Joined: Jul 3, 2019	Posted: Nov 20, 2019 09:54 AM Msg. 8 of 10 I have requested that a new version of the file be generated. Sincerely, Gary Stephen DTN IQFeed Implementation Support Specialist
DTN_Gary_Stephen -DTN Guru- Posts: 394 Joined: Jul 3, 2019	Posted: Nov 20, 2019 10:33 AM Msg. 9 of 10 An updated version of the file is available: ftp://www.dtniq.com/beta/IEOPTION.zip The folder ftp://www.dtniq.com/beta/ also contains some dated past versions of this file. Sincerely, Gary Stephen DTN IQFeed Implementation Support Specialist Edited by DTN_Gary_Stephen on Nov 20, 2019 at 11:07 AM Edited by DTN_Gary_Stephen on Nov 20, 2019 at 11:07 AM
veng1 -Interested User- Posts: 8 Joined: Oct 8, 2018	Posted: Nov 20, 2019 11:52 AM Msg. 10 of 10 Got it, thank you. And thank you for dating the file name. I'm looking forward to seeing if my software correctly identifies the old data and does not reload it. Edited by veng1 on Nov 20, 2019 at 11:52 AM