Re: [amibroker] Re: Using Jim's tickers... with some cutomization, AmiBroker Email List Archive

2008/3/29, brian_z111 <brian_z111@xxxxxxxxx>:

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 amibroker@xxxxxxxxxxxxxxx, "Louis Préfontaine"
<rockprog80@xxx> 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 <areehoi@xxx>:
> >
> > 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 amibroker@xxxxxxxxxxxxxxx <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 amibroker@xxxxxxxxxxxxxxx <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.
> > > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
>