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 »Historical tick data issues
Author Topic: Historical tick data issues (4 messages, Page 1 of 1)

jphiggs
-Interested User-
Posts: 6
Joined: Feb 24, 2019


Posted: Feb 24, 2019 11:57 AM          Msg. 1 of 4
A couple questions:

1) I see bad tick data on a regular basis, in downloaded tick data, in instruments like the S&P 500 sector ETFs. I assume the same for individual stock data though I don’t gather that. I don’t see the same thing for liquid futures coming from the CME for example. See below for a sample. Do your clients have to write their own algorithms to eliminate these programmatically?

2) I’ve often noted a discrepancy between volume data for tick downloads that I’ve summed myself and the Total Volume reported in the IQFeed tick data. See below for an example from 2/22/19 business day that began 2/21/19 at 6pm ET. Seems like some records were dropped that totaled 7 contracts in this single example. At the end of the day the difference can be quite substantial. I downloaded this data three times over several days and all results were identical. Can you explain what may be happening here?



File Attached: ESTotal.PNG (downloaded 1159 times)

jphiggs
-Interested User-
Posts: 6
Joined: Feb 24, 2019


Posted: Feb 24, 2019 12:00 PM          Msg. 2 of 4
Attachment



File Attached: ES1.PNG (downloaded 1184 times)

jphiggs
-Interested User-
Posts: 6
Joined: Feb 24, 2019


Posted: Feb 24, 2019 12:00 PM          Msg. 3 of 4
Attachment



File Attached: XLV.PNG (downloaded 1157 times)

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


Posted: Feb 26, 2019 06:42 AM          Msg. 4 of 4
Hello, concerning the trades in question. These are valid trades so it will be up to you to filter within your app. However we provide some help on filtering these by sending the trade conditions for each trade along with a classification of last-qualified or non-last-qualified. In your example, all of these trades are non-last-qualifed ODDLOT trades. Additionally, 4 of the 5 are labeled as CASH trades with the 5th being labeled as TTEXEMPT.

You will have to do some experimentation to figure out exactly which types trades you want to exclude from your analysis.

I am still looking into the volume discrepancy however, generally speaking, summation of tick volumes and comparing to total volumes is not a valid data verification technique because frequently these will not match up due to corrections, inserts, deletes, etc by the exchange.
 

 

Time: Fri July 26, 2024 10:05 PM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003