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

[amibroker] Re: How to import QP Hemscott structure into AB



PureBytes Links

Trading Reference Links

> I am looking to use the Hemscott structure because it provides
> volume for each of the sector and industry index symbols as well as
> the sub-industry index symbols. Volume is critical to my analysis 
>in AB.

Pity I can't see what you are getting from QP.

Are you getting all layers ?

> I can export the structure from the QuotesPlus charting programming
> and save it in Metastock format. I think I can then import the
> Metastock format into AB.  

AFAIK you can read the Metastock format seamlessly, using the MS 
plugin, but it doesn't recognise the structure ... you can only 
structure AB via the methods discussed in the help manual/UKB i.e. 
manually setting categories etc.

> A significant difference is the Hemscott structure is three layers
> deep Sector --> Industry --> Sub-Industry --> stock
> AB databse does not support three levels of definition.
> I will have to think of a way around this, but I'm sure I can come 
>up
> with something that will work for me.


There is no nice way, that I know of, to manage mutiple sector 
industry layers in AB.
Some of us are scratching our heads about that one.

All of the classification systems use multi-layers ... S&P have had 
them since 1999.

The only way I can think of is to use the categories that are there 
in a non-traditional way .... categorise the third level (sub-
industry) of the structure by using Watchlists..... at least there 
are plenty of WL's available .... the newer WL structure does allow 
for a significant break at WL > no 64 .... if I went down that path I 
would think about putting them there and keeping the first 64 WL/s 
for other uses.

The ODBC plugin is another round about possibility ... perhaps AB 
support can advice if it is capable of tagging a stock with 3 or more 
category identifiers (database fields) that you could then 
reference ... it might slow you down on large stock lists though.

brian_z



--- In amibroker@xxxxxxxxxxxxxxx, "trb0428" <tombrowne34@xxx> wrote:
>
> I am looking to use the Hemscott structure because it provides
> volume for each of the sector and industry index symbols as well as
> the sub-industry index symbols. Volume is critical to my analysis 
in AB.
> 
> I can export the structure from the QuotesPlus charting programming
> and save it in Metastock format. I think I can then import the
> Metastock format into AB.  
> 
> A significant difference is the Hemscott structure is three layers
> deep Sector --> Industry --> Sub-Industry --> stock
> AB databse does not support three levels of definition.
> I will have to think of a way around this, but I'm sure I can come 
up
> with something that will work for me.
> 
> Your information in the KB is very useful. Thank you for providing 
it.
> 
> best regards,
> Tom
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "brian_z111" <brian_z111@> wrote:
> >
> > I know a little bit about Hemscotts strucure.
> > 
> > I don't use QP so I can't help you directly..... of you want to 
copy 
> > the structure directly you need to know if it is saved locally 
i.e. 
> > in AB Workspace etc.
> > 
> > You then have a few choices:
> > 
> > - save copy of database & delete what you don't want
> > - copy/paste key files to duplicate database structure without 
data
> > - export symbol lists manually then reimport to a new database
> > 
> > 
> > BUT! 
> > 
> > You can start from scratch and make your own H structure database 
(it 
> > is incredible fun, trust me).
> > 
> > It would help if you could be specific about what you want to do.
> > 
> > To help you decide:
> > 
> > - Hemscott is a UK company
> > - it doesn't make a lot of sense to use H if you are not going to 
use 
> > QP
> > - Hemscott have their own structure (similar to ICB)
> > - it is more fine grained than S&P (most of the sector trading in 
the 
> > US goes on in the S&P ETF's)
> > - H has gained some favour in the US (don't know why they have 
> > forgiven the Pommies, for the Boston Tea Party stuff, so easily).
> > - H is used at YahooUSA 
> > 
> > http://biz.yahoo.com/ic/ind_index.html
> > 
> > hunt around there and you can get 5day intraday charts for 
industries 
> > and component lists (html only).
> > 
> > - AFAIK there is no way to trade a Hemscott sector/industry 
(actually 
> > there is very little difference in performance between an H 
sector 
> > and an ICB sector anyway ... same old companies).
> > 
> > - you can get links to the H structure and H site from the UKB 
> > (scroll down to DatabaseManagement>>Hemscott
> > 
> > (I posted files at the UKB to help people use for set up the 
> > Hstructure ... can't seem to download the XL file but ask Tomasz 
> > about it if you want it).
> > 
> > - You can subscribe to H site and get filtered lists for the UK 
but 
> > not the US
> > 
> > http://www.hemscott.com/companies/company-search.do
> > 
> > 
> > I prefer use Dow ICB classification (I follow international 
markets a 
> > little) because while it comes second in the USA it is a more 
> > universally used classification:
> > 
> > - It is very similar to Hemscott.
> > - It is used mainly in Europe/UK.
> > - The DownIdexes site recently improved features and you can get 
> > quite good file lists in CSV format from there.
> > - You can trade ICB sectors via futures and ETF's.
> > - Used by YahooUK.
> > - Used by STOXX.
> > 
> > http://uk.biz.yahoo.com/sectors/
> > 
> > http://uk.finance.yahoo.com/m9.php
> > 
> > http://uk.finance.yahoo.com/m7.php
> > 
> > 
> > 
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "trb0428" <tombrowne34@> wrote:
> > >
> > > QuotesPlus has recently added Hemscott structured data to their 
data
> > > download.
> > > 
> > > Their industry monitor index structure is automatically 
imported and
> > > setup
> > > within the AB database providing sector/industry groupings 
> > organized in
> > > a folder
> > > structure.
> > > 
> > > Now, with the Hemscott structure available from QuotesPlus, is 
> > their a
> > > way
> > > to set up the AB database to directly import this Hemscott 
> > structure?
> > > 
> > > Is anyone using this?
> > > 
> > > Here is the Hemscott structure:
> > > http://www.webcando.com/demos/hemscott_structure.jpg
> > > 
> > > Thanks,
> > > Tom
> > >
> >
>



------------------------------------

**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

*********************
TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com
*********************

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

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/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/