Dick, As I understand it Louis doesn't want to delete .OB and .PK stock - he wants to keep them in the database, in their Markets/Groups/Sectors/Industries and then use the database with DTN IQ feed RT.
brian_z --- In [email protected], "areehoi" <[EMAIL PROTECTED]> wrote: > > 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" <rockprog80@> > 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 <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 [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. > > > > > > > > > > > > > > > >
