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 »NEW IQFEED FORUMS »New IQFeed Forum »missing split event?
Author Topic: missing split event? (25 messages, Page 1 of 1)

carter888
-Interested User-
Posts: 9
Joined: Oct 31, 2020


Posted: Dec 17, 2020 04:39 PM          Msg. 1 of 25
Hi I see symbol ANTGF is going to have split event tomorrow. However, the iqfeed fundamental data doesn't have it listed as of now:
Split Factor 1 Date 0001-01-01

And some other stock I checked such as GECC ddi not even have past split events listed.

I am wondering your split data's update schedule and coverage? Does it always list split event before it happen? Does it include all stocks, pink, OTC etc?
Thanks

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


Posted: Dec 17, 2020 04:52 PM          Msg. 2 of 25
ANTGF is a NASDAQ symbol. Splits for NASDAQ symbols are never entered before the day of the split. I would expect that new split to appear tomorrow. (NYSE symbols can, sometimes, be updated in advance, and have a 'last split' date that is in the future.)

I will investigate why GECC's splits aren't listed. If you can provide any other symbols you know of that are missing split data, we can investigate and add it where appropriate.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

carter888
-Interested User-
Posts: 9
Joined: Oct 31, 2020


Posted: Dec 17, 2020 11:48 PM          Msg. 3 of 25
Thanks. When you say 'appear tomorrow', does split update always appear BEFORE market OPEN on the day of split?

I will let you know if I find more missing split data.

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


Posted: Dec 18, 2020 04:38 PM          Msg. 4 of 25
I don't know the exact timing of the update.

As for GECC, I did not find any history of any splits. I know there are some online websites that mention it, but I could not find any official documentation. GECC merged with Full Circle CApital in 2016 (http://www.investor.greatelmcc.com/node/6246/pdf). GECC declared three monthly distributions of $0.083 per share through December 2020. These can be paid in cash, stock, or a combination thereof. In cases like this, where the shareholder as han option of receiving stock or cash, these can be treated as a dividend. GECC does show a most recent dividend date that would match this payout.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

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


Posted: Dec 18, 2020 04:45 PM          Msg. 5 of 25
I should also mention that we entered the 1-for-20 reverse split in this stock dated today. This has been corrected in IQ history and should now be visible.

Furthermore: the stock symbol changed from ANTGF to ANTGD just prior to the split, and it is now listed under ANTGD. This is typical for OTC stocks that undergo reverse splits ā€“ a fifth letter ā€œDā€ is added to the symbol or replaces the previous fifth letter. This is a temporary symbol and after a few days the symbol will revert to ANTGF. This symbol change is an industry standard and not unique to DTN.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

carter888
-Interested User-
Posts: 9
Joined: Oct 31, 2020


Posted: Dec 18, 2020 06:24 PM          Msg. 6 of 25
Thanks for the detailed explanation.

Do you think you can investigate the time of split update? It will still be useful if it's before market open. Otherwise we have to look for alternative data source.

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


Posted: Dec 21, 2020 08:30 AM          Msg. 7 of 25
The split updating process occurs at 01:50am CT.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

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


Posted: Apr 15, 2021 04:55 AM          Msg. 8 of 25
FNGU is still missing its recent 10:1 split event on 2/12/2021. Can you add that to the Fundamental message, please?

(The Daily data are adjusted, but we need that Split event to adjust the intraday properly.)
Edited by Roberts on Apr 15, 2021 at 04:56 AM
Edited by Roberts on Apr 15, 2021 at 04:56 AM

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


Posted: Apr 15, 2021 06:16 AM          Msg. 9 of 25
IQ Feed only adjusts Daily data for splits. Intraday data is not adjusted.

Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

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


Posted: Apr 15, 2021 08:45 AM          Msg. 10 of 25
It looks like the most recent split for FNGU is there now:

wFNGU
F,FNGU,7,,5974000,44.0800,4.9860,44.0800,23.3000,0.0000,,,,,,,,,MICROSECTORS FANG+ 3X LEVERAGED ETN,,,3.85,,14034.0,,,,50000,0.10 02/12/2021,,14,4,,111.24,1,11,02/16/2021,04/21/2020,02/16/2021,03/26/2021,286.6900,,,,,0,,,,,,USD,,,,,BBG00JSLPH24,3,

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

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


Posted: Apr 15, 2021 08:48 AM          Msg. 11 of 25
Yes! Getting it now, thanks.

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


Posted: Apr 23, 2021 12:26 PM          Msg. 12 of 25
Hi again!
VXX reverse split 1:4 today, 04/23/2021

And, the Fundamental string isn't returned the penultimate split either - 1:4 on 08/23/2017:

F,VXX,12,,58583000,45.0300,9.7300,21.7600,9.7300,0.0000,,,,,,,,,IPATH SER B S&P 500 VIX SHORT-TERM FUTURES ETN,VXX1,,1.00,,11570.0,,,,101585,,,14,4,,52.88,1,18,06/12/2020,04/16/2021,01/29/2021,04/16/2021,16.7900,,,,,0,,,,,,USD,,,,,BBG00JQ5JWB5,3,

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


Posted: Apr 23, 2021 12:43 PM          Msg. 13 of 25
Are you looking at intraday data or daily data?

Please be aware I am having our market data team look at this.



Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

Edited by DTN_Stephen on Apr 23, 2021 at 12:43 PM

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


Posted: Apr 23, 2021 12:46 PM          Msg. 14 of 25
I'm looking at both! You should know me by now ;)

I understand that only Daily is adjusted by IQFeed. We use the Fundamental message to adjust our intraday data too.

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


Posted: Apr 23, 2021 12:48 PM          Msg. 15 of 25
Update:
Disregard the split in 2017. That one was for the previous VXX series, which was delisted.

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


Posted: Apr 23, 2021 12:48 PM          Msg. 16 of 25
I agree. I should have read the thread above which I responded too.

I am assuming that our market data team will be getting the daily data adjusted shortly. I am still waiting for a reply from them in regard to these symbol(s).

Thank you.

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: Apr 23, 2021 01:00 PM          Msg. 17 of 25
We have applied the 1-for-4 reverse split to VXX effective today, and also to the underlying index VXX.IV.X.

This only applies to DAILY data.

As noted in follow-up post, the 2017 split referenced below was for a previous iteration of this fund which is now under a different symbol.

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: Apr 23, 2021 01:37 PM          Msg. 18 of 25
Thanks.

Unfortunately, the data guys got the ex-date wrong. It's today 04/23/2021, not 04/22/2021. Can you get them to adjust that, please?

F,VXX,12,,58583000,45.0300,9.7300,21.7600,9.7300,0.0000,,,,,,,,,IPATH SER B S&P 500 VIX SHORT-TERM FUTURES ETN,VXX1,,1.00,,11570.0,,,,101585,4.00 04/22/2021,,14,4,,52.88,1,18,06/12/2020,04/16/2021,01/29/2021,04/16/2021,16.7900,,,,,0,,,,,,USD,,,,,BBG00JQ5JWB5,3,

carter888
-Interested User-
Posts: 9
Joined: Oct 31, 2020


Posted: Apr 23, 2021 02:34 PM          Msg. 19 of 25
For the VXX date issue today, I am not sure if it's keyed in manually. I am wondering if you have any procedure in place to prevent it from happening again? This could cause big loss when price is missed by 400%. thanks

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


Posted: Apr 23, 2021 02:41 PM          Msg. 20 of 25
EX date has been resolved.

As in regards how its entered I am checking into this.


Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

Edited by DTN_Stephen on Apr 23, 2021 at 02:42 PM

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


Posted: Apr 23, 2021 03:24 PM          Msg. 21 of 25
"While splits are entered manually, we now have a better understanding of our sources for split information and expect instances such as today's to be rare."

Stephen Shockey
Senior Customer Support Representative and Product Support Specialist

DTN
800-779-7299
support@iqfeed.net

Cyberjoe
-Interested User-
Posts: 21
Joined: Aug 18, 2016


Posted: Mar 8, 2023 06:38 AM          Msg. 22 of 25

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


Posted: Mar 8, 2023 07:07 AM          Msg. 23 of 25
I will investigate what happened and post findings here.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

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


Posted: Mar 8, 2023 10:03 AM          Msg. 24 of 25
It should be correct now. We have corrected the "Split #1" in the Fundamental Message and the back-adjustment of the daily data. Thank you for letting us know.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

Cyberjoe
-Interested User-
Posts: 21
Joined: Aug 18, 2016


Posted: Mar 8, 2023 10:09 AM          Msg. 25 of 25
Thank you!
 

 

Time: Sun October 6, 2024 4:53 AM CFBB v1.2.0 17 ms.
© AderSoftware 2002-2003