Prash, thank you for that. It seems that the 1 day update for the
7000 symbols from Yahoo takes more than an hour. Is that right? Also
to download the Fundamentals have to leave it running over
night....It seems to me that something is not working properly....any
idea what can be?
Ray
--- In amibroker@xxxxxxxxxps.com,
"Prashanth" <prash454.ta@...> wrote:
>
> Your exploration contained a Fitler which targetted scrips with
volume greater than 100K.
>
> Do this to get a number of scrips
>
> Filter=1;
> Addcolumn(c,"C");
>
> Cheers
>
> Prashanth
> ----- Original Message -----
> From: ax_ray2222
> To: amibroker@xxxxxxxxxps.com
> Sent: Wednesday, July 04, 2007 8:00 PM
> 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@xxxxxxxxxps.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@xxxxxxxxxps.com
[mailto:amibroker@xxxxxxxxxps.com]
> On Behalf
> > Of ax_ray2222
> > Sent: Monday, July 02, 2007 11:41 PM
> > To: amibroker@xxxxxxxxxps.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 VB
Script,
> 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
> > > > > >
> > > > >
> > > >
> > >
> >
>