[amibroker] Populating AB Database with downloaded Hemscott coding.

["Don Lindberg" <dlindber@xxxxxxxxxxxxx>]

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 Java Script 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.