|
PureBytes Links
Trading Reference Links
|
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.
>
|