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!
|
|
|
|