|
Hello,
Note: I am speaking about *Current* QP2 1.5.1
plugin.
It Includes current
and HISTORICAL sales and EPS as well as dates.
Having EPS and Shares number you can easily
calculate Earnings:
GetExtraData("EPS") *
GetExtraData("Shares")
As for dates, since EPS and Sales fields provide
HISTORICAL data as well, last earnings date
can be obtained this way:
EPS = GetExtraData("EPS");
LastEarningsDateNum = ValueWhen( EPS != Ref( EPS,
-1 ), DateNum() );
Note that QP2 provides EPS and Sales historical
data dates only in YYYYMM format (without day)
as explained in the read me so accurracy of
"earnings date" is limited.
Excerpt of the read-me:
GetExtraData now supports two new historical fundamental data fields "Sales"
and "EPS":
Sales and EPS historical figures are provided by QP2 on quarterly basis.
Since QP2 reports dates for this data only in YYYYMM format (without day),
to ensure no future is referenced, AmiBroker returns data for given fiscal
quarter starting from the first
day of NEXT month occurring after Sales/EPS date provided by QP2.
Example:
Plot(GetExtraData("Sales"), "Sales", colorRed );
Plot(GetExtraData("EPS"), "EPS", colorGreen );
Best
regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
Sent: Thursday, August 04, 2005 5:10
PM
Subject: RE: [amibroker] Scanner and some
fundamental information --- Tomasz, Confirm Please
Tony,
Regarding this date,
this is important to me too. I called Quotes Plus and talked with
Greg. Based on that call and some review of AB
docs:
·
The
Quotes Plus database includes the CURRENT quarter’s earnings date as a data
field. Unfortunately, it does NOT include the NEXT earnings
date. (You might derive it by adding 3 months to the current
date.)
·
It is
not clear if the current quarter’s revenue date is exposed in the Quotes Plus
API.
·
It
appears that AB does NOT include the current quarter’s revenue date as one of
the GetExtraData() fields.
Tomasz,
can you weigh in on this issue? Is my understanding correct? Can
the QP Current Earnings Date be added to AB?
Regards,
Dan.
p.s., There are other
options for getting next earnings date into AB. Unfortunately, they are
relatively expensive and cumbersome, require software development, and would
probably be slow. It involves exporting a list of symbols from AB,
calling software to “screen scrape” the earnings date from a website,
downloading the date to a file, and then calling fOpen in AB to load the date
into AB for scanning or display on a chart. I.e., doable, but it would
be a hassle.
From:
amibroker@xxxxxxxxxxxxxxx
[mailto:amibroker@xxxxxxxxxxxxxxx]
On Behalf Of Tony
Lei
Sent: Thursday, August
04, 2005 5:33 AM
To:
amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Scanner and some
fundamental information
Using QP, how would I gather data
regarding the dates for earnings?
thanks
tony
On 8/4/05, Dan Clark <dan_public@xxxxxxxxxxx>
wrote:
Tony,
Hmmm… I use the AFL
function "GetExtraData()":
http://www.amibroker.com/guide/afl/afl_view.php?id=60
However, I don't
think that GetExtraData() currently supports Yahoo Finance data.
Sorry.
Regards,
Dan.
Yahoo Finance
On
8/4/05, Dan Clark <dan_public@xxxxxxxxxxx>
wrote:
Tony,
What you can retrieve
depends on you data vendor. If you use QP, you have a lot of data
available. If Telechart, only two data elements. I'm not
sure about other vendors.
Who provides your
data?
Regards,
Dan.
Hi all,
Do any of you guys know how to retrieve
earnings, dividends, etc date for all the stocks in the database?
thanks
tony
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
YAHOO!
GROUPS LINKS
YAHOO! GROUPS
LINKS
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
YAHOO! GROUPS LINKS
|