[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Advice on Populating New Set of Industries



PureBytes Links

Trading Reference Links

Mr Don.

could you explain step by step how to use that script?
i`ve done first two steps, i changed industry and sector files in 
amibroker directory by hemscott files from 
http://finance.groups.yahoo.com/group/amibroker, i checked symbol 
>categories - industries.there was everything linked to right 
sectors.but now i have no idea how to do everything in step 3? i mean 
where that script file goes and how to use it?
(PopulateIndustriesAndTickers_v3_0.js or Industries.js , btw first 
script has  data stored in lines with following format
** <ticker>,<market number>,<full name>,<industry number>, second one 
<ticker>,<full name>,<industry number>,i`ve got industry_data.txt 
file from http://finance.groups.yahoo.com/group/amibroker whitch has 
no market numbers.where to put file industry_data.txt. how to use it?
 thank you 

>  Ken,
> Yes you can reassign you own definitions to the Industry/Sectors. I 
have
> played with this for a modified Hemscott rating system.
>  
> Here is the procedure as simply as I can explain it.
>  
>     1) you must change the broker.industries and broker.sectors 
files at the
> root of AB directory before you create your new directory.  These 2 
files
> establish your structure  on any NEW database. (has no effect on 
previously
> created ones). The broker.sectors file establishes your main 
categories
> (whatever you decide they are). This is simply a text file you can
> manipulate with any text editor. The file counts from 0 up, so your 
1st
> category will be 0, second will be 1, third will be 2, etc to the 
limit of
> your categories.  There is a direct relationship Between 
broker.sectors and
> broker.industries. In broker.industries you have 2 fields, a 
number, and a
> description. The number is a reference back to broker.sectors. Thus 
every
> entry in broker.industries MUST relate to one of the entries in
> broker.sectors.  This file is also a text file.
>  
>     2) Once you have established these two files in the format of 
your
> liking you will create your new BLANK database. You then go into
> Symbol>Categories and choose the Industries tab. On the left you 
will see
> all the categories you created in broker.industries. You must now 
go through
> each of these categories, and (on right hand side of screen) link 
them to
> one of your broker.sectors categories. This sets up your basic 
structure for
> populating the new database.
>  
>     3) Populating the database is done with a script reading a 
ticker file.
> I used the script "PopulateIndustriesAndTickers_v3_0.js which is 
located in
> the Files section on the AmiBroker Users Group.  The ticker format 
is
> <ticker>,<market number>,<Full name>, <industry number>.
> This last is the most important to you as it will put your stock 
into their
> assigned category.  THE MOST IMPORTANT THING TO REMEMBER is the 
industry
> number corresponds to you categories position in your 
broker.industries !
> Thus if your first category was Widgets, the number you put in the 
<industry
> number> post ion will be 0. Now when the script reads your ticker 
all of
> your stocks numbered 0 will appear in the category Widgets.
>  
> That covers the how. I am not a writer, so I can only hope the 
above makes
> sense to you. Feel free to ask me questions about the procedure and 
I will
> clarify as best I can.
>  
> Hope this helps,
>  
> Don Lindberg
>  
>  
>  
> -------Original Message-------
>  
> From: Ken Close <mailto:ken45140@...> 
> Date: 9/7/2006 7:21:32 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Advice on Populating New Set of Industries
>  
> I do not know if this can be done, but I hope someone can offer 
some advice
> or point to some messages....
>  
> I want to track ATCs of most ETFs which number well over 100.  
True, some
> are probably much less important now but as ETF use grows and as 
more
> varieties emerge, then the number of "popular" ones is sure to grow.
>  
> I have been thinking how to organize to do this, and the only 
obvious
> approach (short of an instantaneous update of the program to 
increase the
> number of Watchlists) is to popular the Industry set with the ETF 
members.
>  
> I see Industry slot from 0 to 100 or whatever, each named for the 
symbol of
> the ETF and containing the holdings of the ETF.  I have read (and 
reread)
> the "Organization of the database" and it appears that this will be
> possible, although I am not certain.
>  
> Also, it seems like some of the scripts which have been written to 
populate
> normally named industries and sectors will have to be modified (how 
I do not
> know yet).
>  
> What is your assessment of this approach?
>  
> Do you have other suggestions?
>  
> Can you point me to any scripts that I could use(modify) for my 
purpose?
>  
> Thanks for any assistance.
>  
> Ken
>