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 --- In [email protected], "Don Lindberg" <[EMAIL PROTECTED]> wrote: > > 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 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. > > > 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: http://www.amibroker.com/support.html Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
