Discussions
»
Product and Service Development
»
Data Related Questions
»
Sector-Group-Industry-Subindustry Complete List of Stocks
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 12/7/2006(UTC)
Posts: 35
|
I've created, through the Sector Performance Monthly scan and Microsoft Access, a detailed breakdown of the quarterly 'Sector through Sub-Industry' 2 year cycle using the CME S&P 1500 securities. Unfortunately, when I find an Industry or Group coming out of a down cycle, the related folder in "Stocks by Sector S&P" doesn't seem to have anywhere near a complete list of correlated stocks. Am I missing something or does each folder only hold limited stocks based on a certain criteria. For instance, Office Electronics (GICS 452040) only has Xerox & Pitney Bowes. Richard
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
It probably is no longer accurate to call this Symbol Utility file S&P based. It was changed to reflect Thomson Reuters Business Classification. In many cases, even certain old S&P Industries only had a few symbols within.
In your example, when I look up the constituents for S&P 1500 Office Electronics (symbol .SPCOMELCI) I see Xerox Corp and Zebra Technologies Corp.
If you do have a different listing that contradicts this information I can try and get the index reported but I did want to clarify that the Sector / Industry Symbol Utility file does not perfectly map to the S&P GICs any more.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 12/7/2006(UTC)
Posts: 35
|
My question leans more toward "does Reuters Data Link update the "Stocks Grouped by Sector" folders". In other words when a new symbol is added to their data base do they also assign that new symbol to a Sector / Industry folder? I'm sure you appreciate what value this update holds in the stock picking process. As for the S&P 1500 I have the SPCOM** Ticker Symbols matched to the respective GICS code so I'm OK there. Thanks for your response. Richard
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
They should update when the associated TRBC Index is updated (and we build new symbol files, which we do monthly). We output a Chain RIC for these TRBC indexes, and when they add new stocks into that Index (or remove stocks) the symbol database should be updated to reflect this. This also goes for the Symbol Utility file that we post on our web site. This is built using the TRBC sector and industry indices and whenever these indices are updated with new constituents the folders are as well.
Keep in mind this involves re-downloading and running the Symbol Utility file. Local data folders do not update automatically.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Data Related Questions
»
Sector-Group-Industry-Subindustry Complete List of Stocks
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
