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)




"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal
"I was on the phone with a friend who uses CQG and right after the Fed announcement, CQG was as much as 30 seconds behind DTN.IQ. Some quotes were off by as much as 15-18 cents. Your feed never missed a beat." - Comment from Roger
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
"Everything is working great with the API. I love it." - Comment from Calvin
"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
"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"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
"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email
"I'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei
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) »Data and Content Support »historical option trades updated a few days later
Author Topic: historical option trades updated a few days later (5 messages, Page 1 of 1)

Larry jag
-Interested User-
Posts: 31
Joined: Dec 28, 2015


Posted: Mar 1, 2016 04:18 PM          Msg. 1 of 5
I've noticed that sometimes, when I download the HISTORY for an OPTION symbol on a recent day (lets say for GOOG and BAC data). If I download the same history 2 or 3 days later, the data may be different.

I download this data for: GOOG1626N695

This data was downloaded on FEB27.2016
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:31:28.668,11.23,1,1,10.0,11.8,308412,C,17,45,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:33:11.166,11.3,1,2,10.1,11.3,680519,C,26,20,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:33:58.401,11.5,1,3,10.2,11.5,816964,C,13,01,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:39:10.158,9.5,1,4,9.2,9.5,1740837,C,5,20,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:41:42.637,10.0,1,5,9.2,10.0,2105406,C,13,01,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:46:12.441,12.6,1,6,11.7,12.6,3144102,C,9,20,
>>>GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:50:04.736,12.5,2,8,11.7,12.2,3774041,C,9,20,
*** Note bid/offer is: 11.7/12.2

This data was downloaded on: MAR1.2016
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:31:28.668,11.23,1,1,10.0,11.8,308412,C,17,45,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:33:11.166,11.3,1,2,10.1,11.3,680519,C,26,20,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:33:58.401,11.5,1,3,10.2,11.5,816964,C,13,01,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:39:10.158,9.5,1,4,9.2,9.5,1740837,C,5,20,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:41:42.637,10.0,1,5,9.2,10.0,2105406,C,13,01,
GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:46:12.441,12.6,1,6,11.7,12.6,3144102,C,9,20,
>>>GOOG1626N695,HTT_10_GOOG1626N695,2016-02-24 09:50:04.736,12.5,2,8,11.7,12.5,3774041,C,9,20, <<<
*** Note bid/offer is now 11.7/12.5 (offer is different).

-------------------------------------------------------------------------------------
In another situation, I have seen extra trades added for BAC1620Q15:

data downloaded FEB27.
** NOTE that first trade size is 10 and next is 4 (for total 14)
>>BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.607,2.93,10,10,2.93,2.95,2707709,C,13,01,
>>BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.624,2.93,4,14,2.93,2.95,2708377,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.646,2.93,2,16,2.93,2.95,2709111,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.916,2.93,2,18,2.93,2.94,2715320,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.968,2.93,3,21,2.93,2.94,2716355,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.986,2.93,4,25,2.93,2.94,2717013,C,108,20,

data downloaded Mar1.
** 1st trade is now size 3, and 2nd is size 10.
** it appears a new extra trade was added a few days later.
>>>BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.600,2.93,3,3,2.93,2.95,2707408,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.607,2.93,10,13,2.93,2.95,2707709,C,13,01,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.624,2.93,4,17,2.93,2.95,2708377,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.646,2.93,2,19,2.93,2.95,2709111,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.916,2.93,2,21,2.93,2.94,2715320,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.968,2.93,3,24,2.93,2.94,2716355,C,108,20,
BAC1620Q15,HTT_10_BAC1620Q15,2016-02-25 09:33:56.986,2.93,4,28,2.93,2.94,2717013,C,108,20,

I completely understand there may be changes, but my real question is, when can I consider the HISTORICAL options data "final" and not expected to change? Is there a hard and fast rule to use? X days later?

DTN_CurtisT
-DTN Technical Support-
Posts: 323
Joined: Jun 14, 2007


Posted: Mar 1, 2016 04:36 PM          Msg. 2 of 5
Hello Larry jag, our Developers are investigating this and will get back with a response shortly.

Curtis Thompson
support@iqfeed.net
support@dtniq.com
support@prophetx.com
Trading Markets Customer Service
1-800-397-7000

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Mar 1, 2016 04:48 PM          Msg. 3 of 5
Hi Larry,

It is likely that this is related to the difference in feeds between our data centers. Bid and ask data is not sent to us in line with the trades for equity data, so there will be differences in our historical records just due to the varying latency at different locations.

Tim

Edited by DTN_Tim Walter on Mar 1, 2016 at 04:59 PM

Larry jag
-Interested User-
Posts: 31
Joined: Dec 28, 2015


Posted: Mar 1, 2016 10:19 PM          Msg. 4 of 5
Thanks for the quick reply Tim.

The BID/ASK was the first example I used, but the more important one is the updated trade (see second example). The volume ends up being different, and a trade was added. To me, it seems like this happens often. I can show you a hundred or so examples. Here is another: IWM1626N99:

FEB27
IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:48:25.836,0.76,1,240,0.76,0.78,10427304,O,17,45,
IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:52:22.354,0.81,1,241,0.8,0.81,12788913,C,88,01,
IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:52:25.567,0.81,3,244,0.8,0.82,12812730,O,13,45,

Mar1
IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:48:25.836,0.76,1,240,0.76,0.78,10427304,O,17,45,
** IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:50:04.723,0.84,54,294,0.83,0.84,11425202,C,88,01,
*** this trade above was added on Mar1
IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:52:22.354,0.81,1,295,0.8,0.81,12788913,C,88,01,
IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:52:25.567,0.81,3,298,0.8,0.82,12812730,O,13,45,
IWM1626N99,HTT_10_IWM1626N99,2016-02-24 09:55:04.626,0.82,1,299,0.82,0.84,13992041,O,17,45,

So I am wondering when I can trust the data is complete and won't change.

DTN_Steve_S
-DTN Guru-
Posts: 2093
Joined: Nov 21, 2005


Posted: Mar 2, 2016 04:00 PM          Msg. 5 of 5
Larry, this particular instance would also be explained by multiple server farms having different data. Each of our server farms operate independently from one another. This means that each has its own feed from the exchanges and separate processing.

While normally the feeds from the exchange match, problems do occur and there might be slight discrepancies in the data as processing recovers and switches from primary to backup. As a result, on the weekends we have a process that runs to consolidate historical data across all our server farms so it matches.

As a result, the following monday would be safe as far as this type of discrepancy is concerned however, the exchange can send corrections for any day at any time (we even receive corrections for data beyond our 180 day storage limit on occasion). Additionally, if our market data team determines that data is wrong, they will make corrections as needed. Unfortunately, this means that there never really is a "complete and won't change" date that I can give you.
 

 

Time: Sun April 28, 2024 1:34 PM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003