Rank: Member
Groups: Registered, Registered Users Joined: 9/25/2010(UTC) Posts: 14
|
I bought FIRE recently in order to produce the NH-NL index for my non US data, and it's doing an excellent job of that. I'm now looking at the ERSA report, and trying to get that working.
The MS Data CD for non US stocks does not come with default Sectors and Industries, and Stocks Grouped by Sector folders, so I need to create my own.
So, I've created about 50 industry folders and added the relevant stocks to these in the downloader. The stocks update fine, and I can run the ERSA report on an individual industry by selecting folder with the "Add All Sub Folders" option checked. So this tells me whether, for example, one food retailer is performing more strongly than another within that specific folder.
I've then created about 10 sector folders, which contain on average 5 industry folders each - hope this makes sense - so effectively my directory structure is:
C:\MS Data\UK Stocks\Sectors and Industries\Retail\Food Retailers\SBRY
What I am really struggling with is how do I compare individual industries within a sector? And then how do I compare the sectors against each other? So what I am really looking for is to find that the Retail Sector is outperforming the other Sectors, and that within that Sector, the Food Retailers industry is doing the best, and that within that industry, the SBRY ticker is the strongest performer.
I can' imagine this can be too hard to do, but the documentation really relies on using the default MS Data CD and is not very helpful if you don't have this.
One other thing to note - when I run the ERSA report across each of my individual industry folders, an "External Relative Strength" folder appears within that industry folder, and it contains a text file for each ticker within that industry. I would guess that these could be used to somehow expand the report across other industries, and then the same thing to do it with sectors.
Sorry for the long post; I've spent all week trying to explain this to MS support and either they aren't getting it, or they just don't know the answer. Thanks for any help with this.
Will
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 5/13/2005(UTC) Posts: 715 Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Who's your data supplier?
|
|
|
|
Rank: Member
Groups: Registered, Registered Users Joined: 9/25/2010(UTC) Posts: 14
|
Its' Quote Center - thanks :)
|
|
|
|
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)
|
You could run the exploration "Equis Performance Daily" on the sector indexes you made with fire. You can sort by the different time frames to see which preformed best over that interval. Then you can run the same exploration on the folder to see which security preformed best.
Alternately, you can use one of the FIRE explorations that use ERSA. Those were designed to do comparisons like you are asking about
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
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.