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

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@xxxxxxxxxps.com, "Don Lindberg" <dlindber@xx.> 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@xxxxxxxxxps.com [mailto:amibroker@xxxxxxxxxps.com]
On Behalf
> Of ax_ray2222
> Sent: Monday, July 02, 2007 9:17 PM
> To: amibroker@xxxxxxxxxps.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

__,_._,___