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)




"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"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.
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"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 am very happy I changed. I love the product, but more so I am thrilled with Tech Support. You are knowledgeable, polite, pleasant and professional." - Comment from Pat
"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
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) »Data and Content Support »ticker to stock sector
Author Topic: ticker to stock sector (7 messages, Page 1 of 1)

civilwar
-Interested User-
Posts: 3
Joined: Apr 20, 2014


Posted: May 6, 2014 12:07 PM          Msg. 1 of 7
is this information available in IQFeeds anywhere?


i.e.

company,ticker,sector
tesla tsla consumer goods
disney dis services

if this information is not accessible what is another option?

should I create a lookup table from yahoo ticker profile sector? Any other public sources?

DTN_LorenF
-DTN Technical Support-
Posts: 228
Joined: May 11, 2004


Posted: May 6, 2014 12:26 PM          Msg. 2 of 7
Civilwar

We do have the Company name and the Ticker in our system, but all we have is the SIC code that you could reference from the Internet.
What you are looking for is not readily available in our system.

civilwar
-Interested User-
Posts: 3
Joined: Apr 20, 2014


Posted: May 6, 2014 12:33 PM          Msg. 3 of 7
What is the SIC code associated to?

i.e. ticker-> SIC ?

for example I have a bunch of news articles related to stock tickers. Now I want to create a lookup table of sectors for these tickers.


looks like my best bet for a couple of exchanges is:
http://www.nasdaq.com/screening/company-list.aspx
Edited by civilwar on May 6, 2014 at 12:35 PM
Edited by civilwar on May 6, 2014 at 12:38 PM

DTN_LorenF
-DTN Technical Support-
Posts: 228
Joined: May 11, 2004


Posted: May 6, 2014 12:45 PM          Msg. 4 of 7
Civilwar

Standard Industrial Classification (SIC) codes are four digit numerical codes assigned by the U.S. government to business establishments to identify the primary business of the establishment. The classification was developed to facilitate the collection, presentation and analysis of data; and to promote uniformity and comparability in the presentation of statistical data collected by various agencies of the federal government, state agencies and private organizations. The classification covers all economic activities.


you can search companys by this code on the internet

https://siccode.com/en/

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: May 6, 2014 01:05 PM          Msg. 5 of 7
In addition;

As a developer you could do a level one watch on each symbol that you want to consider, retrieve the SIC or NAICS code from the fundamental data that is returned and then do a symbol lookup to get a list of symbols for the corresponding sector. To get the name\description of the sector you could compare the number returned to the results of the sector lookup returns.

Note: These would count against any symbol limits.

http://www.iqfeed.net/dev/api/docs/SymbolLookupviaTCPIP.cfm describes the functions that would be needed to do the symbol lookup and sector code lookups.

Tim

civilwar
-Interested User-
Posts: 3
Joined: Apr 20, 2014


Posted: May 6, 2014 01:27 PM          Msg. 6 of 7
cool, although not practical unless I had a large symbol limit I will save info for reference, but I suppose I could do it over a larger span of time. is it 500 symbols per month or per day for default subscription?

Also news and the associated ticker do not list the exchange that the stock is listed under. I do not know enough about tickers, but I imagine that I might get two tickers that have the same name but are different companies on different exchanges?

anyways I will use nasdaqs Company List (NASDAQ, NYSE, & AMEX) and build a lookup and go from there.
Edited by civilwar on May 6, 2014 at 01:28 PM
Edited by civilwar on May 6, 2014 at 01:28 PM

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: May 6, 2014 02:03 PM          Msg. 7 of 7
500 at any one time.

Just spin through your symbol list and store the sector codes off in a database, that way your not constantly wasting bandwidth. Then set the process to refresh the sector codes once a week or once a month over a weekend or something similar to that.

Tim
 

 

Time: Thu April 25, 2024 4:54 AM CFBB v1.2.0 9 ms.
© AderSoftware 2002-2003