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)




"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"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
"Everything is working great with the API. I love it." - Comment from Calvin
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"I'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei
"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"I've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler 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 »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 May 2, 2024 2:12 AM CFBB v1.2.0 13 ms.
© AderSoftware 2002-2003