Don, thank you it says "7275 in database and 3355 in NMSS"
What does
the NMSS 3355 mean? Also if I go to Aquote I have only 5255 symbols
displayed there for same database. It is confusing....
How can I delete any symbol below $5 automatic? Seems that if you run
a script you can not choose the symbols and delete them....
Ray
--- In amibroker@xxxxxxxxxps.com,
"Don Lindberg" <dlindber@xx.> wrote:
>
> Ray,
>
> If you move your mouse over your database name at the very bottom
right hand
> corner of AmiBroker status bar it will show you total # of entries.
>
> Don
>
>
>
> _____
>
> From: amibroker@xxxxxxxxxps.com
[mailto:amibroker@xxxxxxxxxps.com]
On Behalf
> Of ax_ray2222
> Sent: Wednesday, July 04, 2007 7:31 AM
> To: amibroker@xxxxxxxxxps.com
> Subject: [amibroker] Re: How to use ATC only with positive EPS?
>
>
>
> Don, how can I check how many tickers are in the database? I ran
the
> simple Explration for C.5 and V>100k and it gave me only 140
symbols,
> which is not right....
> I try to see if the database has data collected (it says 7075
> symbols) if I open it in AQuote.
>
> Ray
>
> --- In amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
ps.com, "Don
> Lindberg" <dlindber@> wrote:
> >
> > Ray,
> >
> > If you keep 2 data bases you have to log into each separately and
> do the
> > updates. That is why I work with Many different Watch Lists. I
have
> one data
> > base, but all of my various calculations are done against one or
> the other
> > watch list.
> >
> >
> >
> > Don
> >
> >
> >
> > _____
> >
> > From: amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
ps.com
> [mailto:amibroker@yahoogrou <mailto:amibroker%40yahoogroups.com>
ps.com]
> On Behalf
> > Of ax_ray2222
> > Sent: Monday, July 02, 2007 11:41 PM
> > To: amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
ps.com
> > Subject: [amibroker] Re: How to use ATC only with positive EPS?
> >
> >
> >
> > Don thank you for that. If I create 2 databases, how do I keep
them
> > updated? do I have to log AB in both of them separate and update
> each
> > or both will get data from AQ? I'm puzzled here....
> > sorry for all this novices questions...
> > Ray
> >
> > --- In amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
> ps.com, "Don
> > Lindberg" <dlindber@> wrote:
> > >
> > > Ray,
> > >
> > > Keep the full AmiBroker Database, because Yahoo regularly
changes
> their
> > > stock classifications and split information.
Go into Auto
Analysis
> > and run
> > > the following Exploration against all stocks. When the
> Exploration is
> > > finished in the AA window choose File, Export to CVS and Save
the
> > file into
> > > your AmiQuote Directory. Now create a new empty Database and use
> > AmiQuote
> > > to populate it with the file you saved. You will now have only
> Stocks >=
> > > $5.00 whose 30 Day Avg Volume is >= $100,000. You could also
just
> > save this
> > > to a Watch List in your primary Database, and then do all you
work
> > against
> > > that Watch List. This has the advantage that any Sector and
> Industry
> > > Information won't have to be recreated.
> > >
> > >
> > >
> > > -----------------------------Exploration Code
Begins
> > > -----------------------------------------
> > >
> > > Filter= Close >= 5 AND EMA( Volume , 30 ) >=100000;
> > >
> > >
> > >
> > > Buy=1;
> > >
> > > Sell=1;
> > >
> > > AddTextColumn(FullName(),"Name",1.2);
> > >
> > > AddColumn (Close,"Close",1.2);
> > >
> > > AddColumn (Volume,"Volume",1.2);
> > >
> > >
> > >
> > > -------------------------- Exploration Code Ends
> > > ----------------------------
> > >
> > >
> > >
> > > Hope this is what you wanted.
> > >
> > >
> > >
> > > Enjoy,
> > >
> > >
> > >
> > > Don
> > >
> > > _____
> > >
> > > From: amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
> ps.com
> > [mailto:amibroker@yahoogrou <mailto:amibroker%40yahoogroups.com>
> ps.com]
> > On Behalf
> > > Of ax_ray2222
> > > Sent: Monday, July 02, 2007 9:17 PM
> > > To: amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
> ps.com
> > > Subject: [amibroker] Re: How to use ATC only with positive EPS?
> > >
> > >
> > >
> > > Don, thanks for that. Now how can I create my own universe of
> stocks
> > > from Yahoo and not all 8000 almost what comes with the AB? so
if
> I
> > > like to have only Stocks over $5 and over 100k average volume
how
> > > would I create that list and than create my new database?
> > > any idea? or do you have that already and would you like to
share
> it?
> > >
> > > Thank you for that, Ray
> > >
> > > --- In amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
> > ps.com, "Don
> > > Lindberg" <dlindber@> wrote:
> > > >
> > > > Ray,
> > > >
> > > > Won't work. The smf-addin is for Excel. The formulas only
work
> in
> > > Excel. You
> > > > would have to create some kind of _javascript_, or _vbscript_,
> and
> > > that is not
> > > > for the faint of heart. With some of the programming
geniuses
> we
> > > have it
> > > > this group I would think if it were possible someone would
have
> > > already done
> > > > it. If you are not a programmer there is no plug and paste
> stuff
> > > that will
> > > > work. But keep looking, that's how new things happen.
> > > >
> > > >
> > > >
> > > > Good Luck,
> > > >
> > > > Don
> > > >
> > > >
> > > >
> > > > _____
> > > >
> > > > From: amibroker@xxxxxxxxx <mailto:amibroker%
40yahoogroups.com>
> ps.com
> > > [mailto:amibroker@yahoogrou <mailto:amibroker%40yahoogroups.com>
> > ps.com]
> > > On Behalf
> > > > Of ax_ray2222
> > > > Sent: Monday, July 02, 2007 6:28 PM
> > > > To: amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
> ps.com
> > > > Subject: [amibroker] Re: How to use ATC only with positive
EPS?
> > > >
> > > >
> > > >
> > > > Don, I was thinking if we can use smf-addin formulas to
> retrieve the
> > > > missing data from other web pages direct in the
fundamentals
> fields
> > > of
> > > > AB, that will make it so much more powerful.....what
do you
> think?
> > > >
> > > > Ray
> > > >
> > > > --- In amibroker@xxxxxxxxx <mailto:amibroker%
40yahoogroups.com>
> > > ps.com, "Don
> > > > Lindberg" <dlindber@> wrote:
> > > > >
> > > > > Ray,
> > > > >
> > > > > I can pull data from the Web into Excel, but there is
no
way
> that
> > > I
> > > > know of
> > > > > that you can do that in AmiBroker. Your off on new
territory
> and
> > > > way beyond
> > > > > my skills.
> > > > >
> > > > > Good Luck,
> > > > >
> > > > > Don
> > > > >
> > > > >
> > > > >
> > > > > _____
> > > > >
> > > > > From: amibroker@xxxxxxxxx <mailto:amibroker%
> 40yahoogroups.com>
> > > ps.com
> > > > [mailto:amibroker@yahoogrou <mailto:amibroker%
> 40yahoogroups.com>
> > > ps.com]
> > > > On Behalf
> > > > > Of ax_ray2222
> > > > > Sent: Monday, July 02, 2007 2:24 PM
> > > > > To: amibroker@xxxxxxxxx <mailto:amibroker%
40yahoogroups.com>
> > > ps.com
> > > > > Subject: [amibroker] Re: How to use ATC only with
positive
> EPS?
> > > > >
> > > > >
> > > > >
> > > > > Don you are right, but as an exercise....I 'd
like to see
> what
> > > > > results I get and if it comes close to any other
data....
> > > > > Do you know of any other way of getting fundamental
data
from
> the
> > > > > Internet direct, without using excel?
> > > > > Like if EPS is missing from Yahoo to check Zacks page
and
> > > retrieve it
> > > > > with the specified formula? That means I guess to add
that
> code
> > > in
> > > > > AmiQuotes somehow....
> > > > >
> > > > > Ray
> > > > >
> > > > > --- In amibroker@xxxxxxxxx <mailto:amibroker%
> 40yahoogroups.com>
> > > > ps.com, "Don
> > > > > Lindberg" <dlindber@> wrote:
> > > > > >
> > > > > > Ray,
> > > > > >
> > > > > > You are missing the point. If you only pull data
that has
> > > positive
> > > > > value
> > > > > > then by default you are eliminating all the
stocks that
> Yahoo
> > > > > doesn't give
> > > > > > EPS data on. Given that fact your ATC PE and PS
values
are
> > > BOGUS,
> > > > > because
> > > > > > they do not include all the stocks in any given
Industry!!!
> > > > > >
> > > > > >
> > > > > >
> > > > > > It's the old "Garbage In, Garbage Out"
For your ATC to be
> of
> > > any
> > > > > value you
> > > > > > can't just pick and choose the data you want.
Trust me,
its
> all
> > > or
> > > > > nothing.
> > > > > > Do the math. If an Industry is made up of 100
stocks, but
> you
> > > only
> > > > > use data
> > > > > > on 75 stocks because Yahoo doesn't give you data
on the
> other
> > > 25
> > > > > your
> > > > > > results ARE NOT indicative of the whole
Industry!!!!!
> > > > > >
> > > > > >
> > > > > >
> > > > > > Don Lindberg
> > > > > >
> > > > > >
> > > > > >
> > > > > > _____
> > > > > >
> > > > > > From: amibroker@xxxxxxxxx <mailto:amibroker%
> 40yahoogroups.com>
> > > ps.com
> > > > > [mailto:amibroker@yahoogrou <mailto:amibroker%
> 40yahoogroups.com>
> > > > ps.com]
> > > > > On Behalf
> > > > > > Of ax_ray2222
> > > > > > Sent: Sunday, July 01, 2007 10:20 PM
> > > > > > To: amibroker@xxxxxxxxx <mailto:amibroker%
> 40yahoogroups.com>
> > > ps.com
> > > > > > Subject: [amibroker] How to use ATC only with
positive
EPS?
> > > > > >
> > > > > >
> > > > > >
> > > > > > How can I write an Industry ATC composite formed
only by
> the
> > > > > positive
> > > > > > EPS stocks?
> > > > > > -create Industries with ATC formula but if stock
has
> EPS<=0.01
> > > > > don't add
> > > > > > it to composite and
> > > > > > -do not count it in the OI counter field, so the
Industry
> > > composite
> > > > > will
> > > > > > have the averages formed out of just the positive
EPS
> stocks.
> > > > > >
> > > > > > Any idea how this can be achieved? Thank you for
any
help,
> Ray
> > > > > >
> > > > >
> > > >
> > >
> >
>