Hi Dick, I am not sure to understand how you would do that. I know how to eliminate the .OB from the Excel file provided by Jim, but I don't know how to put the files back.
I think I understand your point: there is no need for me to start again from scratch. I can use Jim database, but still, I am stuck with the same problem at the end: the pink sheets tickers are from different categories, industries, sectors, so how would I enter them at the correct place if not manually? Thanks, Louis 2008/3/28, areehoi <[EMAIL PROTECTED]>: > > 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] <amibroker%40yahoogroups.com>, "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><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. > > > > > > > > > > > > > > > > > >
