|
PureBytes Links
Trading Reference Links
|
Hi Jim
The sectors are great thanks.I never knew how to do this.
I have found out it includes 8761 symbols using Amiquote Yahoo.
After updating it from Yahoo, going back to 1990 until last friday,
it shows a lot of symbols that show No quotes or No recent quotes.
Using the filter below says 7490 symbols. This can be revised to
something more reasonable, like Va 1000 and Close>2.
Va=10;//Volume Average This is a very low value.
AveV=MA(Volume,25);
Filter = Close > 0.1 // this is a very low value
AND Close<100 // to eliminate the index list
AND MA(Volume,25)>Va;
AddColumn(Close,"Close",1.2);
AddColumn(AveV,"AveV");
Questions
What market does .OB stand for?
What is included in the Markets 0-5 ?
After this went to Tools/cleanup database, this took maybe 30 minutes
to go through and delete all the stocks that did not trade or no
recent trades. This AB process (cleanup database) is very poor, I am
familiar with AIQ, which is much easier.
Could you put out a revised list that would save each person from
going through this process?
Or what am I missing.
Thanks again for this list with sectors!
Ray
--- In amibroker@xxxxxxxxxxxxxxx, "jrswindle2001" <jr.ab@xxx> wrote:
>
> Hi Rick,
>
> Sorry about the files, I must have missed them on the last zip up.
> There is another link on the web site now for the Broker.xx files.
>
> Good idea on the last traded date. I will look into it.
>
> Thanks,
>
> Jim
>
> --- In amibroker@xxxxxxxxxxxxxxx, Rick Osborn <ricko@> wrote:
> >
> > I too really appreciate your work on this database.
> >
> > A question -- you mentioned that broker.industries
> > and broker.sectors are included. I could not find
> > them in the Zip file.
> >
> > Also in the Excel file, would it be possible to also
> > add "last date traded" - so as to weed out stocks that
> > have quit trading?
> >
> > Great work
> >
> > Rick
> >
> > --- jrswindle2001 <jr.ab@> wrote:
> >
> > > If anyone is interested I have posted a new AB blank
> > > database on my
> > > website. It is setup for the Yahoo downloader.
> > > US-Stocks.zip
> > >
> > > http://www.icc-az.com/Update-AB.html
> > >
> > >
> > >
> > >
> > >
> >
> >
> > Rick Osborn & Associates
> > 885 Sorrento Ave.
> > Oshawa, Ontario L1J 6V6
> > (905) 728-8543 fax 728-0815
> >
>
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.11/542 - Release Date: 11/20/2006
|