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

Re: [amibroker] Scanner and some fundamental information --- Tomasz, Confirm Please


  • To: <amibroker@xxxxxxxxxxxxxxx>
  • Subject: Re: [amibroker] Scanner and some fundamental information --- Tomasz, Confirm Please
  • From: "Tomasz Janeczko" <amibroker@xxxxxx>
  • Date: Thu, 4 Aug 2005 18:06:29 +0200

PureBytes Links

Trading Reference Links

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 -----
From: Dan Clark
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.

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Tony Lei
Sent: Wednesday, August 03, 2005 10:06 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Scanner and some fundamental information

 

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.

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Tony Lei
Sent: Wednesday, August 03, 2005 4:37 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Scanner and some fundamental information

 

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



SPONSORED LINKS

Investment management software

Investment property software

Investment software

Investment tracking software

Return on investment software

Stock investment software

 


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

 

 






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