Louis, There is no need to convert the XL files to ASCII. Jim has already done this by providing the US-Stocks database. To simplify take the US-Stocks database (intact) and copy then paste in the Amibroker Program files (be sure to rename the existing one to another name ie ...US-Stocks1). When you open AB go to open database and pick the new US-Stocks. It should work. To eliminate the "OB,s" and "Pink Sheet" go to the Excel spreadsheet and sort on the column that carries them. Copy them and put in word (unformated) so you can make a coma delimitated ascii file. Put that file in a blank Watch list from which you can delet all.
Dick H --- In [email protected], "Louis Préfontaine" <[EMAIL PROTECTED]> wrote: > > Hi Brian, > > Even with the precedent method, it does not work. It works fine the first > time with the first group, but then whatever the number of the industry I > choose, the tickers go in the first one.. or even one in the fourth group, > with no particular reason. This looks to me like a strange bug if it is > one! > > 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>, "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> > > 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. > > > > > > > > > >
