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 would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"You have an excellent product !!!!!!" - Comment from Arely
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
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 »IQFeed Developer »IQFeed Developer Support »Bugs in SBS (Symbols by SIC lookup) query
Author Topic: Bugs in SBS (Symbols by SIC lookup) query (5 messages, Page 1 of 1)

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

IQML - IQFeed-MATLAB connector


Posted: Sep 28, 2019 01:46 PM          Msg. 1 of 5
When I search for symbols by SIC code (SBS query), I can see the following:

=> SBS,28,x 

<= x,2813,AIQUY,3,1,L'AIR LIQUIDE ADR
<= x,2813,FLRE,3,1,FLAMERET INC
<= x,2816,TORM,3,1,TOR MINERALS
...
<= x,2819,ZGSI,3,1,ZERO GRAVITY SOL INC
<= x,2820,CDSAF,3,1,CYDSA SA SER A ORD
<= x,2820,FUPEF,3,1,FUCHS PETROLUB AG
<= x,2820,LNXSF,3,1,LANXESS AG
<= x,2821,ACGJ,3,1,ACI GLOBAL CORP
...
<= x,2834,AIHLF,3,1,
...
<= x,2836,XLRN,1,1,ACCELERON PHARMA INC. COMMON S
<= x,2839,LMDCF,3,1,LINGO MEDIA CORP NEW
<= x,2839,YLWDF,3,1,YELLOW PAGES LTD COMMON SHARE
<= x,2840,DUNIY,3,1,DUNI AB
<= x,2840,HEGIF,3,1,HENGAN INTL
<= x,2841,BTTR,3,1,BETTER CHOICE COMPANY INC. COMMON STOCK
...
<= x,2869,WLKP,7,1,WESTLAKE CHEMICAL PARTNERS
<= x,2870,NHYDY,3,1,NORSK HYDRO ADR
<= x,2870,NHYKF,3,1,NORSK HYDRO ASA ORD
<= x,2873,AGGL,3,1,AGTECH GLOBAL INTERNATIONAL INC. COMMON STOCK
...
<= x,!ENDMSG!

There are 2 problems with these results:

1. SIC group codes 2820,2839,2840,2870 are not listed in the response to a SSC query. I detected 154 such SIC codes that were reported by SBS but not listed by SSC (I can email you this list of 154 if you wish).

2. Some symbols are reported without a company name. I found 4 cases of this problem: AIHLF (SIC code 2834), ELIAF (4911), UTBPP (6798) and FWDE (1311).

I have not tested to check whether similar problems occur with the corresponding NAICS queries (SBN and SNC), but it would not surprise me to discover this.

Please advise...

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

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

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

IQML - IQFeed-MATLAB connector


Posted: Sep 29, 2019 05:06 AM          Msg. 2 of 5
Followup problem #3: SIC groups 00-09 (Agriculture sector) return no symbols at all. For example:
=> SBS,07,x
<= x,E,!NO_DATA!,
<= x,!ENDMSG!

It seems that only SIC groups 10+ are properly processed.

You *do* have information about the Agriculture stocks. For example, you report valid market and fundamental data for AGRO (SIC=0139, i.e. SIC group 01), CVGW (SIC=0179) and FDP (SIC=0179) - It's just that you don't return these symbols in the SBS query since their SIC group < 10.

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

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

DTN_Gary_Stephen
-Interested User-
Posts: 50
Joined: Jul 3, 2019


Posted: Oct 2, 2019 09:10 AM          Msg. 3 of 5
Yair,

I will investigate this.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

DTN_Gary_Stephen
-Interested User-
Posts: 50
Joined: Jul 3, 2019


Posted: Oct 2, 2019 10:32 AM          Msg. 4 of 5
OK, I see what you're saying. I will report a bug as:

1. SBS returns no data for 01, 02, 03, 07, 08, 09. I even tried doing SBS,1 instead of SBS,01, but that returns an "invalid code" error. (43, 93, and 94 return no data, but given the public-sector nature of those categories, I suspect that is correct.)

2. I found a total of 152 codes in the SBS command that do not appear in the SSC query. I'll send you an email so we can compare lists.

3. The missing name problem seems to be larger in scope. I got some missing names too, but not the same symbols; for me it happens to YKLTF, AMPO, LCHD. If I run the command again, they are still missing, so it isn't random. If I run a Watch command on those symbols, there's no company name there either. The symbols you listed now show names, and I don't see that any of the symbols have recently activated or deactivated. I will report this also, but I don't think it's necessarily an SBS/SSC problem.


Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

Edited by DTN_Gary_Stephen on Oct 2, 2019 at 10:38 AM

DTN_Gary_Stephen
-Interested User-
Posts: 50
Joined: Jul 3, 2019


Posted: Oct 2, 2019 04:15 PM          Msg. 5 of 5
UPDATE: I've been advised by our data people that the missing company names is a known behavior. These are all new symbols, and apparently sometimes it takes a day or two for the company name field to populate. So this is nothing unusual.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist
 

 

Time: Sun February 16, 2020 4:00 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003