|
PureBytes Links
Trading Reference Links
|
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@xxxxxxxxx>:
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, "Louis Préfontaine" <rockprog80@xxx>
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@xxx>:
> >
> > 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>, "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.
> > >
> >
> >
> >
>
__._,_.___
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
![]()
__,_._,___
|