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

[amibroker] Re: Using Jim's tickers... with some cutomization



PureBytes Links

Trading Reference Links

I still have more to learn about AB than what I already now so I can 
never be 100% certain but I think some one would have told us by now 
if there was a quicker way.

I have only posted GUI methods at the UKB because 'we' need to 
understand the principles before we can use more advanced (semi-auto 
methods) like file handling functions/script/COM/ODBC methods etc.
If you already have skills in those areas it might not take long to 
do but if you have to learn it first it will take longer because you 
have to get up to speed for a one off procedure.

Either way, AFAIK, you have to have text file lists for every sub-
category of every category.

In time I am happy to learn advanced methods but in the interim I 
find setting up a database does not take long once you have the 
subcategory component lists carefully labelled.

>From memory you just need to slip the lists into the Watchlists 
folder and run the code (category by category - there are only three 
major categories - admittedly there are a lot of industry groups 
lists to prepare).

If you haven't got the Industry lists prepared you could use 
Information/Categories functions and File I/O Functions to write 
them, from the US-Stocks database to a text file.

The next step for the DM section of the UKB is to write procedures to 
help people learn how to do that type of thing - that is a little bit 
down the track though.

brian_z



--- In amibroker@xxxxxxxxxxxxxxx, "Louis Préfontaine" 
<rockprog80@xxx> wrote:
>
> Hi Brian,
> 
> Thanks a lot for the kind words!  I sure am coming froma long way, 
and
> thanks to you and to others who helped me I am getting better 
everyday using
> Amibroker!
> 
> There are two files on Jim website:
> 
> 1) The database in .zip with all the tickers in the correct 
categories;
> 2) The database in .xls with all the tickers listed with 
categories, name,
> eps, etc.
> 
> I already know how to set the first database correctly with Yahoo, 
but I
> need to delete the .OB after the tickers to use the database wuith 
my
> real-time provider.  So this is why I used the second database with 
Excel
> and deleted the .OB.  But then, that's where I don't know how to 
put that
> information back in place to be sure the tickers will be in the 
correct
> industries/markets, etc.
> 
> I read in the manual that categoryAddSymbol can add symbols to 
whatever
> category I choose, but the problem is still the same: to have a 
scan of all
> the tickers going in the category restaurant (as an example) I 
would have to
> manually put them in "restaurants", and considering Jim's DB has 
tons of
> different categories this would take me forever!
> 
> Is there a faster way to get there?
> 
> Thanks!
> 
> Louis
> 
> 
> 2008/3/21, brian_z111 <brian_z111@xxx>:
> >
> >   If it is in Jim's DB then you can get it out, in any category, 
and
> > get it back,in any category (via Watchlists).
> >
> > categoryAddSymbol uses one of the following:
> >
> > categoryMarket
> > categoryGroup
> > categorySector
> > categoryIndustry
> > categoryWatchlist
> > categoryFavorite
> > categoryIndex
> >
> > You have come a long way in a short time so you maybe miss a few
> > points.
> >
> > Doing it yourself is a tedious business at times but you really 
learn
> > your craft that way.
> >
> > I can't do more now.
> > I'm getting tired and don't do good work in that state.
> >
> > I am impressed with your progress.
> >
> > brian_z
> >
> > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
40yahoogroups.com>, "Louis
> > Préfontaine"
> > <rockprog80@> wrote:
> > >
> > > Hi Brian,
> > >
> > > The problem is that when I want to import back to AB, all I can
> > change is
> > > the group, and I can only modify this group by group. I don't 
see
> > how I can
> > > import everything back in the right industry, as setted by Jim.
> > >
> > > Louis
> > >
> > > 2008/3/18, brian_z111 <brian_z111@>:
> > > >
> > > > Try this:
> > > >
> > > > a) convert CSV lists >> text file
> > > > b) import to Watchlists
> > > > c) use categoryAddSymbol to move from WL to 
Markets/Groups/Sectors
> > > >
> > > > (as per "SetUp A Custom Database/Nasdaq" at the UKB
> > > >
> > > > I think it is also possible using AFL (even within AB) but 
others
> > > > could help you more with that than yours truly.
> > > >
> > > > brian_z
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
40yahoogroups.com><amibroker%
> > 40yahoogroups.com>, "Louis
> >
> > > > Préfontaine"
> > > > <rockprog80@> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I really enjoyed using Jim's tickers
> > > > > http://icc-az.com/icc%2Daz/default.html?http%3A//icc-
az.com/icc%<http://icc-az.com/icc%2Daz/default.html?http%3A//icc-
az.com/icc%25>
> > <http://icc-az.com/icc%2Daz/default.html?http%3A//icc-az.com/icc%
25>
> > > > 252Daz/
> > > > >
> > > > > However, I see that this is Yahoo's formatting with e.g. 
AAAA.OB
> > > > for pink
> > > > > sheets while my provider would prefer simply AAAA. I tried 
to
> > > > remove the
> > > > > .OB with Excel, and did it correctly, but then I don't know 
how
> > to
> > > > import
> > > > > the files WITH the categories/industries as Jim setted them 
up.
> > In
> > > > the
> > > > > import wizard, there are no options for those categories, so
> > would
> > > > there be
> > > > > another way to do this?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Louis
> > > > >
> > > > >
> > > > > p.s. I will try to redownload Amiquote to use Yahoo with 
those,
> > but
> > > > would
> > > > > enjoy using my intraday data if possible.
> > > > >
> > > >
> > > >
> > > >
> > >
> >
> >  
> >
>



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

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 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/