|
PureBytes Links
Trading Reference Links
|
Hi Ray,
On the next run, I will check the last date traded and ensure that it
has been traded within the last few days (of my extract). As for the
filter you are using, I am sure that will work well for you, but
others may want a slighty different approach, which is why I listed
it on the web site to allow users to choose what they would like.
I'll try and get to it in the next few days and also update the Excel
spreadsheet as well.
I messed up on the Markets and did not label them correctly after the
extract. 0 = Amex, 1 = Nasdaq, 2 = NYSE, 3 = OTC, 4 or 5 = unknown,
like indices or ETFs.
.OB stands for Over The Counter (OTC), and .PK stands for Pink Sheets
(according to Yahoo Help that is...)
Thanks,
Jim
--- In amibroker@xxxxxxxxxxxxxxx, "me_rayme" <rayme9@xxx> wrote:
>
> 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@> 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
|