[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: How to use ATC only with positive EPS?



PureBytes Links

Trading Reference Links

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@xxxxxxxxxxxxxxx, "Don Lindberg" <dlindber@xxx> 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@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] 
On Behalf
> Of ax_ray2222
> Sent: Monday, July 02, 2007 11:41 PM
> To: amibroker@xxxxxxxxxxxxxxx
> 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@xxxxxxxxx <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 Java Script, 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@xxxxxxxxx <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@xxxxxxxxx <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@xxxxxxxxx <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
> > > > >
> > > >
> > >
> >
>




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
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/