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)




"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"Everything is working great with the API. I love it." - Comment from Calvin
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"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
"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
"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
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 »Equity Tickdata has extreme outliers
Author Topic: Equity Tickdata has extreme outliers (10 messages, Page 1 of 1)

karthikkrishnan
-Interested User-
Posts: 22
Joined: Nov 4, 2015


Posted: May 19, 2020 05:54 PM          Msg. 1 of 10
I am notice some extreme outliers in tick data. For example INTC on. 2020/03/24 as attached. While it is possible for such extreme black swans, I want to make sure if this is not due to some error in feed. For example, these extremes are also happening on very low volume. So just making sure. Can you confirm ?



File Attached: intc.png (downloaded 910 times)

DTN Todd
-Interested User-
Posts: 74
Joined: Mar 24, 2010


Posted: May 19, 2020 07:10 PM          Msg. 2 of 10
Hello Karthikkrishnan

I checked the IQfeed data for your inquiry and I am not showing the spikes in data that your chart is showing.

Thanks
Todd

karthikkrishnan
-Interested User-
Posts: 22
Joined: Nov 4, 2015


Posted: May 19, 2020 08:00 PM          Msg. 3 of 10
I see it. My commands look like
S,CURRENT PROTOCOL,6.1
HTT,INTC,20200324 093000,20200324 160100,100000000,,,1,,

Can you check again ?

karthikkrishnan
-Interested User-
Posts: 22
Joined: Nov 4, 2015


Posted: May 19, 2020 08:05 PM          Msg. 4 of 10
9:55:14 AM 52.925 100 6245693 52.92 52.93 7313 C 19 1 0 24
9:55:14 AM 52.92 100 6245793 52.92 52.93 7314 C 19 1 0 24
9:55:14 AM 52.92 300 6246093 52.92 52.93 7315 C 19 1 0 24
9:55:14 AM 52.925 100 6246193 52.92 52.93 7316 C 19 1 0 24
9:55:14 AM 49.58 1 6246194 52.92 52.93 7317 O 19 8706 0 24
9:55:14 AM 52.925 100 6246294 52.93 52.94 7318 C 19 1 0 24
9:55:14 AM 52.925 100 6246394 52.93 52.94 7319 C 19 1 0 24
9:55:14 AM 52.925 100 6246494 52.93 52.94 7320 C 19 1 0 24
9:55:14 AM 52.925 100 6246594 52.93 52.94 7321 C 19 1 0 24
9:55:14 AM 52.925 100 6246694 52.93 52.94 7322 C 19 1 0 24
9:55:14 AM 52.9201 200 6246894 52.93 52.94 7323 C 19 1 0 24

This is what it looks like (check 49.58 last price at row #6). FYI, I tried it again and see the same anamoly
Edited by karthikkrishnan on May 19, 2020 at 08:05 PM

DTN Todd
-Interested User-
Posts: 74
Joined: Mar 24, 2010


Posted: May 19, 2020 08:35 PM          Msg. 5 of 10
This is everything i am showing for 09:55.14
09:55:15.0 3/24/2020 52.96
09:55:14.9 3/24/2020 52.97
09:55:14.9 3/24/2020 52.97
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.97
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.8 3/24/2020 52.96
09:55:14.4 3/24/2020 52.97
09:55:14.4 3/24/2020 52.96
09:55:14.4 3/24/2020 52.96
09:55:14.1 3/24/2020 52.96
09:55:14.1 3/24/2020 52.96
09:55:14.1 3/24/2020 52.96
09:55:14.1 3/24/2020 52.95
09:55:14.1 3/24/2020 52.95
09:55:14.1 3/24/2020 52.95
09:55:14.1 3/24/2020 52.95
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.1 3/24/2020 52.94
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.925
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.93
09:55:14.0 3/24/2020 52.9201
09:55:14.0 3/24/2020 52.925
09:55:14.0 3/24/2020 52.925
09:55:14.0 3/24/2020 52.925
09:55:14.0 3/24/2020 52.925
09:55:14.0 3/24/2020 52.925
Thanks
Todd

karthikkrishnan
-Interested User-
Posts: 22
Joined: Nov 4, 2015


Posted: May 19, 2020 08:42 PM          Msg. 6 of 10
What does your message look like ? Could you also post the entire line for the rows you are showing. What I posted includes last_trade, bid, ask etc (basically entire feed and I am looking at last price). My row header is
timestamp,last_price,last_size,total_volume,bid,ask,tickid,basis,trade_market_center,trade_condition,trade_aggresor,day_of_month,

Edited by karthikkrishnan on May 19, 2020 at 08:43 PM

DTN Todd
-Interested User-
Posts: 74
Joined: Mar 24, 2010


Posted: May 19, 2020 08:51 PM          Msg. 7 of 10
I can go over the data with you. Instead of taking up forum space with this specific details if you could contact IQfeed Support. I am available for chat at www.iqfeed.net or by email at support@iqfeed.net

Thanks
Todd

DTN_Gary_Stephen
-DTN Guru-
Posts: 396
Joined: Jul 3, 2019


Posted: May 20, 2020 08:08 AM          Msg. 8 of 10
Yeah, that is unusual. I will have our data team investigate, and will post my findings. ETA: I see that my teammate Steve has already given an explanation below.


Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

Edited by DTN_Gary_Stephen on May 20, 2020 at 08:34 AM

DTN_Stephen
-DTN Guru-
Posts: 453
Joined: Aug 22, 2014


Posted: May 20, 2020 08:33 AM          Msg. 9 of 10
karthikkrishnan I believe we spoke in chat this morning and I provided a complete explanation of this trade. However I will recap it here in the forums for all readers.

The trade in question was a Trade Condition: ODDLOT/CASH with an INC Volume 1. This trade was non-last qualifying trade that did not set a new low for the date of 3/24/20.

Symbol: INTC
09:55:13.986418 2020-03-24 49.5800 1 52.9200 52.9300 6246194 0 0 7317 Other Trade NTRF ODDLOT/CASH

https://www.investopedia.com/terms/o/oddlot.asp

What is an Odd Lot?
An odd lot is an order amount for a security that is less than the normal unit of trading for that particular asset. Odd lots are considered to be anything less than the standard 100 shares for stocks. Trading commissions for odd lots are generally higher on a percentage basis than those for standard lots, since most brokerage firms have a fixed minimum commission level for undertaking such transactions.


Understanding Odd Lots
Odd lots may inadvertently arise in an investor's portfolio through reverse splits or dividend reinvestment plans. For example, a one-for-eight reverse split of a security, of which the investor holds 200 shares, will result in a post-split amount of 25 shares. While trading commissions for odd lots may still be higher than for standard lots on a percentage basis, the popularity of online trading platforms and the consequent plunge in brokerage commissions means that it is no longer as difficult or expensive for investors to dispose of odd lots as it used to be in the past.


Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

Edited by DTN_Stephen on May 20, 2020 at 08:35 AM

karthikkrishnan
-Interested User-
Posts: 22
Joined: Nov 4, 2015


Posted: May 20, 2020 08:41 AM          Msg. 10 of 10
That explains it. Thanks!
 

 

Time: Tue May 7, 2024 11:43 AM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003