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)




"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"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
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"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
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
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 »Product Support »Data and Content Support »How can I get/use splits info
Author Topic: How can I get/use splits info (3 messages, Page 1 of 1)

Rohan2008
-Interested User-
Posts: 3
Joined: Mar 27, 2019


Posted: Mar 27, 2019 02:09 PM          Msg. 1 of 3
Hi,

Questions related to splits from fundamental messages:

I see who split factors in Fundamental messages (dev api):

Quote:
Split factor 1 float[ ]MM/DD/YYYY A float a space, then MM/DD/YYYY Provided by exchange or 3rd party data provider
Split factor 2 float[ ]MM/DD/YYYY A float a space, then MM/DD/YYYY Provided by exchange or 3rd party data provider


1. How can I use them... I mean what type of information is present; an example can help dramatically.
2. When can I expect this information?
3. Are there any third party data providers that can provide this info... should I add any other service ontop of IQFeed for this info?

thanks,

altmany
-Interested User-
Posts: 43
Joined: Jul 30, 2018

IQML - IQFeed-MATLAB connector


Posted: Mar 27, 2019 02:33 PM          Msg. 2 of 3
Here is an actual example for MSFT (1:2 split on 03/29/1999 and 02/18/2003) - this is reported as part of the fundamental message for a symbol ("F" message):

Split Factor 1: "0.50 02/18/2003"
Split Factor 2: "0.50 03/29/1999"


This correlates with the latest 2 splits for Microsoft, as reported on https://www.stocksplithistory.com/microsoft/

If there is only a single split in recorded history, Split Factor 2 will be empty.
If there is no split history, both strings will be empty.

Note that for some reason IQFeed reports the split rounded only to 2 digits after the decimal. For example, the GOOGL split on 4/3/2014 (https://www.stocksplithistory.com/google/) was 1:1.998 but this is reported as "0.50" (instead of the more accurate 0.5005) by IQFeed:

Split Factor 1: "0.50 04/03/2014"
Split Factor 2: ""


In other words, the split factor is not a full-accuracy float but a float rounded to 2 decimal places. Hopefully IQFeed will improve this in a future release.

In some cases, splits may be missing or different between different data providers. For example, IQFeed reports only a single split for GOOG (1.00 on 04/27/2015) whereas https://www.stocksplithistory.com/?symbol=GOOG reports a 1:1.0027455 split on that date as well as a 1:2.002 split on 03/27/2014. This appears to be due to faulty data somewhere.



Yair Altman
IQML - IQFeed-MATLAB connector
https://UndocumentedMatlab.com/IQML

I am not a DTN employee; my post reflects my personal opinion

Edited by altmany on Mar 27, 2019 at 02:45 PM

Rohan2008
-Interested User-
Posts: 3
Joined: Mar 27, 2019


Posted: Mar 28, 2019 08:16 AM          Msg. 3 of 3
Thanks appreciate it. This helps.

So technically, I can assume that if a stock XYZ splits tomorrow for the first time (3/30/2019), IQFeed shall include this info in its split factor 1 field starting from tomorrow?

I create a lot of meta data around the stock price; I don't want to recreate all this info whenever a split happens and so all this.

thanks,
 

 

Time: Mon February 24, 2020 1:53 AM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003