Hello there - Guess we have some common
interest. CANSLIM first.
I'm assuming you have Stock Picker Pro installed with your QP3? It comes with the QP3 CD for no additional
charge. SPP has dozens of filters, one of which is called
CANSLIM.
I've attached a screen shot and you'll see that
at least 2 of the data fields needed are not exposed by the AB plugin that
Tomasz has
provided us, like CQIE and CYIE. A couple
of options 1) if important enough maybe we could talk Tomasz into
adding
those 2 extra fields in the plug in, or 2) ask
someone who has the skills with the AB SDK could take the plug in
and extend it for those 2 fields. I've
never fired up the SDK myself and not sure I have all the elements in my
development desktop
to do this. I run the CANSLIM filter
on QP3 and get somewheres around 175-200 good stocks every day that form a
small universe of
stocks with good fundamentals and price change
momentum.
3) EPS is an array and if you plot it
you'll see it changes every quarter. So by either running an explore or a
plot you can
see if Ref(EPSarray,-66) works or
not. I'd take it outside the reference function just to be
conservative like
EPSArray = GetExtradata("EPS");
1) and 2) Lots of good documentation
in SPP, like the following that should remove any doubt in your mind as to what
the fields are.
We had a 'birds of a feather' meeting at the
Amibroker Conference in Houston and there were about 12 QP3 users there. I
have a distribution
list that I'm adding your name to and if you
don't want to be copied on some of our mailings please let me know and I'll take
you off it. Dan Clark is very active and has been providing information
for the forum, to our group and feed back to the owner of Quotes Plus,
hopefully to some avail.
Hope this helps.
Joe
% 5Yr EPS Gr
Description: 5 Year
Earnings Per Share
Growth The percentage change in current fiscal
year earnings
compared to five years ago fiscal year earnings. Source:
Quotes
Plus Filter category: Fund Earnings - % EPS
CYIE Description:
Continuous
Yearly Improvement in Earnings Per Share The objective is to find
securities with year after year of continuous EPS growth for the past 3 years.
The year is based on a trailing twelve month (TTM) basis. The yearly
difference between the most recent EPS quarter and the same quarter a year ago
is computed. This backwards computation is done to arrive at 4 yearly EPS
values. If the
difference for most recent yearly EPS value is greater than the previous year
(not equal) we add one to the count. This type of
backwards comparison goes on until one of two events occur:
-
All 3 yearly time periods have been processed or
-
The security fails with a yearly comparison that doesn't increase, the
process will stop and the count is recorded
The process results in a number from 0 – 3.
A security with
consecutive upward yearly progress will get a value of 3 (3 years of steady
upward
% 1Yr EPS Gr (TTM)
Description: 1 Year
Earning Per Share Growth (trailing 4 quarters) The percentage change
using the sum of the last 4 quarters
of EPS compared to the sum
of the prior 4 quarters of EPS. This is a current
4 quarter over the previous 4 quarters EPS comparison as opposed to the data fields:
Source:
Computed Filter category:
Fund Earnings - %
EPS
----- Original Message -----
Sent: Friday, March 17, 2006 12:51
AM
Subject: [amibroker] GetExtraData
I
have a few questions about the fundamental data coming out of QP3 that I
hoped someone here could answer:
I'm pretty sure that sales and
sharesfloat are reported in millions (e.g. "1.2" means 1,200,000), and
sharesshort are reported in thousands (e.g. "1,200" means 1,200,000), but
I don't know about some of the others.
1) TTMSales? I can't think
of any way to make this a real number. 2) TTMEPS? It looks like it could
just be normal, but I'd like to make sure. 3) Earnings growth numbers
(Y1, Y5, and projections)? One would expect percentage (e.g. "12" = 12%),
is this the case?
One final question: Since "EPS" is an array, does
that mean I can get historical EPS by using Ref(GetExtraData("EPS"),-#)?
If so, I've tried that and it didn't seem to work. Is there another way to
do it?
I'm trying to set up some sort of CANSLIM type of exploration.
So, if anyone has any ideas on that, I would really appreciate the
help.
Thank you.
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 other support material please check also:
http://www.amibroker.com/support.html
SPONSORED LINKS
YAHOO! GROUPS LINKS
|