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 cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"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 use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - 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.
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"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've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"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
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 907 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: 394
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: Fri April 26, 2024 3:56 PM CFBB v1.2.0 14 ms.
© AderSoftware 2002-2003