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 <[EMAIL PROTECTED]>: > > 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 [email protected] <amibroker%40yahoogroups.com>, "Louis > Préfontaine" > <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>: > > > > > > 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 [email protected] <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. > > > > > > > > > > > > > > > > > >
