|
Dick,
I also have a database set up using those files. I have two issues with it. First it does not contain all of the coded stocks and some of the stocks it does contain have either changed or have incorrect coding. Just the NYSE has 2074 coded stocks, AMEX has over 1,200 and I haven't worked up the figures on NASDAQ and OTC yet, but I am convinced the # will be higher than the 8,000 stock shown by the database set by the existing ticker. I may be nit picking, but I would like to be as current as possible.
I am still trying to figure out how the creators of the industry data file that is in the Hemscott file section arrived at their IndustryID #, because it doesn't relate to the Hemscott Industries ID in any way that I can see. All of the Hemscott ID are 3 digit numbers, but the ticker has 1, 2 and 3 digits. I have requested information on how the number was arrived at, but have not gotten any reply yet.
Thank you for your reply, but I am still working on getting answers.
Don Lindberg
-------Original Message-------
Date: 08/25/06 09:56:22
Subject: [amibroker] Re: Populating AB Database with downloaded Hemscott coding.
Don,
I set up the Hemscott database over a year ago and switched to it from
the orignal US Stocks db at that time. No problems and industries
match Yahoos. All the necessary files ...Industy, Sectors and symbols
are available from the files section at this site. So, unless you are
taking a differenct approach it would simplify your task to check this
out.
Dick Hoierman
>
> Can't ANYONE give me some ideas on this problem?
>
>
> > Group,
> > I am attempting to get updated Industry/Sector information from
> > Yahoo (which uses Hemscott Industry Codes) and then importing this
> > information into AmiBroker. I am doing this so that I can create a
> > COMPLETE List of all Hemscott coded stocks for each of the US
> > exchanges. Until I get the system perfected I am working with a
> test
> > database. I have an Excel Add in (RCH_Stock_Market_Functions.xla)
> > which captures Yahoo's Industry Group ID #, Sector ID # and
> Exchange
> > ID # . From this captured list I create a csv file in the format
> of
> > Ticker, Market ID, Full Name, Industry ID. I then use the Java
> > Script "PopulateIndustriesAndTickers_v3_0.js" (from the AmiBroker
> > User List Files Section) to populate my new database. I have run
> > into problems doing this. I have tried this using the
> > Broker.Industries and Broker.Sector files found in the User List
> > file section under Hemscott) and the codes get assigned
> incorrectly.
> > On looking at the Broker.Industries file I realize all it does is
> > relate each industry group to the appropriate Sector, but does not
> > relate to the actual Hemscott Industry Group ID #. So I created a
> > new Broker.Industries file that has the actual Hemscott Industry
> > Group ID # tied to the Industry Group Name. Using this new
> > Broker.Industries file I again created my test database, and by
> > going into Symbol-Catagories related each of the Hemscott Industry
> > codes to their apprpriate Sector. I ran the script again. The
> script
> > ran fine, but the codes are still not assigned corectly. In fac if
> I
> > look at the Symbol Information view most of the stocks don't even
> > have an assignment! The Hemscott Industry Code document was
> > downloaded directly from Hemscott website and I double checked it
> > against the Yahoo assignments.
> > Am I doing something wrong? Is the _javascript_ out dated? I am not
> a
> > programmer, so can only accept the script is correct.I note that
> > when I look at the sample ticker file that accompanies the
> Hemscott
> > file on the user list, the Industry ID # are not the same as what
> I
> > get from the Hescott document. Hemscott uses all 3 digit numbers,
> > and the sample file uses both 2 and 3 digit numbers that have no
> > apparent relation to the Hemscott system. What am I missing?
> > I am bound and determined to make this work, so any help I can get
> > will be greatly appreciated. I have run this by Tomasz, but I
> think
> > he is too busy to look at it right now, so I appeal to the group
> at
> > large for their input. I will post a copy of the Hemscott file to
> > the files section as soon as I post this message.
> >
>
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
Yahoo! Groups Links
<*> To visit your group on the web, go to:
<*> To unsubscribe from this group, send an email to:
<*> Your use of Yahoo! Groups is subject to:
| 