|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "Don Lindberg" <dlindber@xxx> 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.
> >
>
|