[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, 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@xxxxxxxxxxxxxxx, "Don Lindberg" <dlindber@xxx> 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@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] 
On Behalf
> Of ax_ray2222
> Sent: Wednesday, July 04, 2007 7:31 AM
> To: amibroker@xxxxxxxxxxxxxxx
> 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@xxxxxxxxx <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@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/