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 3rd Party Software Support »Erroneous Split in Fundamental Message
Author Topic: Erroneous Split in Fundamental Message (7 messages, Page 1 of 1)

Roberts
-Interested User-
Posts: 54
Joined: Mar 26, 2008


Posted: Sep 14, 2020 03:44 AM          Msg. 1 of 7
Is this a good place to report data errors?

The fundamental message returned just now for XLF begins like this, with the record truncated after Split Factor 2

F,XLF,7,,57698000,31.3800,17.4900,31.3800,17.4900,2.4700,0.1516,0.6115,06/25/2020,06/22/2020,,,,,FINANCIAL SELECT SECTOR SPDR,,,1.20,,186563.0,,,,744245,1000.00 09/19/2016,1231.00 05/04/2007,...

An hour earlier, this came in...
F,XLF,7,,57698000,31.3800,17.4900,31.3800,17.4900,2.4700,0.1516,0.6115,06/25/2020,06/22/2020,,,,,FINANCIAL SELECT SECTOR SPDR,,,1.20,,186563.0,,,,744245,1000.00 09/19/2016,1231.00 07/01/2002,....

I only noticed this because a customer reported that the date he got for Split Factor 2 was 10/12/2010.

Besides the changing date for this "split", a bigger problem is that there has never been a second split for XLF. There should only be the first on 9/19/2016, whose factor should be 1000/1231 (approximately). In reality, the factor should be 1/1.23167675 which is really a back-adjusment for a special dividend of $4.44346/share.

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


Posted: Sep 14, 2020 06:21 AM          Msg. 2 of 7
Robert we appreciate the information.

You can also report data issues at support@iqfeed.net

This split data is currently under review and I will notify you as soon as I have more information.

Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

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


Posted: Sep 14, 2020 09:55 AM          Msg. 3 of 7
We have corrected the data errors on the symbol XLF.

If you have any further questions regarding this information please feel free to contact us at support@iqfeed.net

Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

Roberts
-Interested User-
Posts: 54
Joined: Mar 26, 2008


Posted: Sep 14, 2020 10:15 AM          Msg. 4 of 7
Hi Stephen,
I just grabbed the message after reading your post and got this:

F,XLF,7,,57698000,31.3800,17.4900,31.3800,17.4900,2.4700,0.1516,0.6115,06/25/2020,06/22/2020,,,,,FINANCIAL SELECT SECTOR SPDR,,,1.20,,186563.0,,,,744245,0.81 09/19/2016,1231.00 02/22/2008,...

Indeed, Split Factor 1 was corrected, but Split Factor 2 should be empty. The factor 1231 is an artifact of the divisor for Split Factor 1 (1000/1231 = approx. 0.81), and its date is fictitious.

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


Posted: Sep 14, 2020 10:21 AM          Msg. 5 of 7
Thank you for the response.

Our Market data integrity team is reviewing the data on XLF at this time.

Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

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


Posted: Sep 14, 2020 02:10 PM          Msg. 6 of 7
We are still researching but for now, either:

• Unwatch the symbol and then rewatch the symbol.

Or if that doesn’t work

• Shut down and restart the feed.

Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

Roberts
-Interested User-
Posts: 54
Joined: Mar 26, 2008


Posted: Sep 14, 2020 02:58 PM          Msg. 7 of 7
Looks good now. SF2 is empty. Thanks.
 

 

Time: Mon October 7, 2024 12:26 PM CFBB v1.2.0 8 ms.
© AderSoftware 2002-2003