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

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



PureBytes Links

Trading Reference Links

Ray,

The second number is referring to the total number of Quotations for the stock in the Active Window, in your case that was NMSS.  As for AmiQuote your stock ticker list may be a default set by AmiQuote in the initial setup.  If you open AmiQuote and then tell it to get tickers from AmiBroker you will have the complete list, then save that list so you can call it up in future.  The AmiBroker Manual tells you how to do that.

There is no such thing as an “automatic” delete.  What you need to do is run a scan that finds all stocks under $5.00. Save the results to a Watch List. Then go into Symbol > Organize Assignments > Watch Lists. Choose the watch list you created with the under 5 stocks from the pull down, click on the 1st stock, scroll to the bottom of the list and while holding down the shift key click on the last stock. This will select all the stocks in the list. Then  choose the Delete Option.  This will remove them from your database.  Don’t forget to create a new AmiQuote ticker list from your now smaller database, or you will bring them all back in the next time you up date.  Judging from the questions you ask over the last few weeks I think you have to spend some time with the manual and find some of your answers for yourself.  The quickest way to alienate yourself on this list is to expect everyone else to give you answers without you doing your homework.

 

Don Lindberg

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of ax_ray2222
Sent: Wednesday, July 04, 2007 3:20 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: How to use ATC only with positive EPS?

 

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
> > > > > >
> > > > >
> > > >
> > >
> >
>

__._,_.___

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





SPONSORED LINKS
Investment management software Investment property software Investment software
Investment tracking software Return on investment software

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___