Hi Brian, I am sorry... I really don't understand points b) and c). I copied all the .OB tickers to a new .XLS file but I am not sure what you mean by entering columns for sector, industry, etc.
I'm sorry if I sound like I am too slow to understand, but really this thing puzzles me. I am thinking about changing my real-time provider because of this... I just can't figure out how to delete the .OB. I am seriously considering removing manually 50 per day and in a month or two that would be over... Louis 2008/3/29, brian_z111 <[EMAIL PROTECTED]>: > > Louis, > > Dick is quite right. > > It is easier to work with the sorted list of .OB stocks by themselves. > > Try this: > > a) sort by .OB and copy all OB rows to a new file US-Stocks_OB.xls > b) enter columns for sector ID, industry ID, market ID, and Group ID > c) manually enter ID numbers into each column (the numbers should > align to the 0 based count in AB >> symbols >> categories > d) save a copy as US-Stocks_OB.csv > e) write a formats file to suit and save it in Programs/AB/Formats as > US-Stocks.format (allow for adding new symbols) > f) open a spare copy of US-Stocks and ASCII import US-Stocks_OB.csv > using US-Stocks.format as file type > > The suffix free symbols should now be in the database in their > correct categories (if so you can delete the old symbols that have > suffexes) > > brian_z > > --- In [email protected] <amibroker%40yahoogroups.com>, "Louis > Préfontaine" > <[EMAIL PROTECTED]> wrote: > > > > 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><amibroker% > 40yahoogroups.com>, "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><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> > > > <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> > 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. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
