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 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
"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
"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
"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post
"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
"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 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
"I just wanted to let u know that your data feed/service is by far the best!!! Your unfiltered tick data is excellent for reading order flow and none of your competitors delivers this quality of data!" - Comment from Peter via Email
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
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: Fri May 17, 2024 5:21 AM CFBB v1.2.0 10 ms.
© AderSoftware 2002-2003