Thanks for the response, As I understand your comment the QP data base includes the release dates of all earnings reports. Is it possible to retrieve the earnings report release dates from Excel? thanks, Charles
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Haworth Sent: Friday, June 09, 2006 12:39 PM To: [email protected] Subject: RE: [quotes-plus] Re: historical fundamental data in QP database? Charles, Actually Quotes Plus does provide dates but that was not the question asked earlier. In the COM there is a method in the RevEps class called QtrDate which gives the quarter date of the evenings for x-quarters back. I don't know if this function is available through Quotes Plus own language. One of the advantages of learning programming in say VB or C++ is you can use QPs dll and completely customize your applications well beyond the language Quotes Plus provides. By the way Quotes Plus gets their data from Reuters. If you had to buy from Reuters directly the cost would be astronomical. What we get for the money in terms of information is unmatched. To see a complete listing of classes, properties, and methods available to the QP subscriber go to the DJ Traders Manual link in the User Group. John ________________________________ From: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com on behalf of Charles Mattson Sent: Fri 6/9/2006 9:43 AM To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com Subject: RE: [quotes-plus] Re: historical fundamental data in QP database? How will you decide which date to use to post the eps numbers in your plots? The quarterly data for various companies is reported somewhat randomly from 3 to 15 weeks after the close of the quarter. Also, some company quarters end on different months. How will you know which one applies to your plot? The data for QTREPS(0) could be from 1 day to more than 3 months old. It would be nice if Quotes Plus kept track of the actual date the earnings data is reported. Charles _____ From: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com <mailto:quotes-plus%40yahoogroups.com> [mailto:quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com <mailto:quotes-plus%40yahoogroups.com> ] On Behalf Of joe_global_2005 Sent: Friday, June 09, 2006 11:23 AM To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com <mailto:quotes-plus%40yahoogroups.com> Subject: [quotes-plus] Re: historical fundamental data in QP database? John, Thanks for making it clear to the newbies to QP. Joe --- In quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com, "John Haworth" <[EMAIL PROTECTED]> wrote: > > What I pasted in below is from QP help files for their proprietary language. The database holds quarterly earnings and revenues back 12 quarters ( 0 to -11). So you can use the COM object in say VB or C++ to get at this data as I showed in my earlier e-mail this morning. > > As mentioned you would use the RevEpsClass and create an instance of it and then say to get data 12 quarters back you could write > > in C+: double dbl_EarningsBack12 = Convert::ToDouble(m_Earnings- >Earnings(-11)) where m_Earnings is an instance of the RevEpsClass > > in VB.Net: Dim dbl_Earnings# = m_Earnings.Earnings(-11); > > John > > ********************************************************************** ************************************************************ > > QTREPS(quarter#) > > Returns the earnings per share, in dollars, for the specified quarter. Data on the 12 most recent quarters are kept in the database. > > QTREPS(0) specified the most recent quarter; > > QTREPS(-1) is the quarter before the most recent; > > QTREPS(-11) is the oldest quarter available. > > Example > > Output = "mylist"; > > if QTREPS(0) > 3.0 then > > println symbol; > > endif; > > > ________________________________ > > From: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com on behalf of vjsworld > Sent: Fri 6/9/2006 6:01 AM > To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com > Subject: [quotes-plus] Re: historical fundamental data in QP database? > > > > OK, I see that in the DJtraders guide, but it only says it 0, -1, - > 2, -3 quarters... So does this mean it only goes back up to 4 > quarters (one year)? Or does it go back for years and this is just > not outlined in the guide? > > Thanks in advance, > Van > > --- In quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com <mailto:quotes-plus% 40yahoogroups.com> , "John Haworth" <john@> wrote: > > > > > > > > You would use the RevEpsClass in the COM object. Earnings and > Revenues can be extracted back to I forget how many quarters but if > you wanted the earnings 1quarter back in VC++>Net you might write > > > > double dbl_EarningsBack1 = Convert::ToDouble(m_Earnings->Earnings (- > 1)) where m_Earnings is an instance you earlier created of the > RevEpsClass. > > > > So in summary Earnings and Revenues are not called by trading days > back in the database but by quarter. > > > > John > > > > ________________________________ > > > > From: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com <mailto:quotes-plus% 40yahoogroups.com> on behalf of vjsworld > > Sent: Thu 6/8/2006 7:34 PM > > To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com <mailto:quotes-plus% 40yahoogroups.com> > > Subject: [quotes-plus] historical fundamental data in QP database? > > > > > > > > Can you access historical fundamental data from the QP database > via > > the API? I see how to get the price data out (for charting), but I > am > > trying to get fundamental data out so that I can chart EPS under > Price > > (as an indicator, or something I can create indicators with) in my > > charting program. > > > > The reason I ask this, is I see in the DJtraders guide that when > you > > call the price function, you need to tell it how many days back to > > load, but looking at the fundamental functions (EPS, etc), it > doesn't > > ask how many days to load....... > > > > Anybody have any experience here? > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get to your groups with one click. Know instantly when new email arrives http://us.click.yahoo.com/.7bhrC/MGxNAA/yQLSAA/GHeqlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/quotes-plus/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
