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)




"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
"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"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
"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"I just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"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
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon
"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
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 April 26, 2024 3:43 AM CFBB v1.2.0 10 ms.
© AderSoftware 2002-2003