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

[amibroker] Re: Where is Forward P/E data ???



PureBytes Links

Trading Reference Links

I downloaded GE to check it for you.

Note that, if my memory serves me correctly, we don't see the data on the server that AQ downloads.... it is seperate to the webpages that we are viewing i.e. AQ is not scraping the page.... so data can be different on the website to the data we get.

Forward EPS is actually the analysts average guestimate from this page:

http://finance.yahoo.com/q/ae?s=GE

When I download I get:

12/06 Close 13.51,EPS 1.54 P/E 8.77 (correct)
Forward EPS 0, Forward P/E N/A - Yahoo has analyst est at 0.94 for a FP/E of 14.37.

Probably the Yahoo server that AQ downloads from has 0 as the incorrect value.

It is unlikely that AQ downloads incorrectly (you can check my download since we are completely independent).

Sometimes it happens that Yahoo move stuff and Tomasz has to make an adjustment but not if it is only a % of stock.

Not being rude because I use Yahoo myself ...have done for years (but not for critical tasks) ... if Yahoo doesn't do the job QP is the alternative paid data with fundamentals included (in case you didn't know).





 --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@xxx> wrote:
>
> TJ - I downloaded again this morning following this order:
> 1. Historical (save all) 2. Fundamental Basic (save all) 3. Fundamental Extra (save all).
> Looked at the tickers and the Forward EPS and Forward P/E are flipped.
> This weekend, I'll delete all ticker data and rebuild the database and see what the results are. (in case something isn't being overwritten properly).
> Thanks
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> >
> > hmmm.... Just now, I reloaded the Fundamental data, first basic, then extended. Then I did a Save in AmiBroker, then shutdown Amibroker, then restarted and checked the ticker of GE.
> > Still flipped in AmiBroker:
> > P/E = 8.70 (looks good)
> > Forward P/E = .94 (hmmm...)
> > EPS est. Next Year = .94 (looks good)
> > Foward EPS = 14.26 (hmmm...)
> > 
> > Looked on Yahoo to confirm my figures are flipped.
> > I also confirmed aqfe.format file as:
> > 
> > $NOQUOTES 1
> > $AUTOADD 1
> > $OVERWRITE 1
> > $SEPARATOR ,
> > 
> > $FORMAT CLOSE, FORWARD_PE, PEG_RATIO, PROFIT_MARGIN, OPERATING_MARGIN, RETURN_ON_ASSETS, RETURN_ON_EQUITY, REVENUE, QTRLY_REVENUE_GROWTH, GROSS_PROFIT, EBITDA, EPS,  QTRLY_EARNINGS_GROWTH, BOOK_VALUE_PER_SHARE, OPERATING_CASH_FLOW, FREE_CASH_FLOW, BETA, SHARES_OUT, SHARES_FLOAT, INSIDER_HOLD_PERCENT, INSTIT_HOLD_PERCENT, SHARES_SHORT_PREV,SHARES_SHORT, FORWARD_DIV, DIVIDEND, DIV_PAY_DATE, EX_DIV_DATE, LAST_SPLIT_RATIO, LAST_SPLIT_DATE 
> > 
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@> wrote:
> > >
> > > Hello,
> > > 
> > > No. It is correct. AmiBroker supports both fields and then calculates EPS and P/E using one data or another and current price.
> > > It is needed because Yahoo "basic" stats contain one field and "key statistics" contain only second.
> > > If you use both it is best to first run "basic" download and then extended download.
> > > 
> > > Best regards,
> > > Tomasz Janeczko
> > > amibroker.com
> > > ----- Original Message ----- 
> > > From: "gmorlosky" <gmorlosky@>
> > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > Sent: Wednesday, June 10, 2009 8:35 PM
> > > Subject: [amibroker] Re: Where is Forward P/E data ???
> > > 
> > > 
> > > > Oddly the Forward P/E data ends up in the Forward EPS line and vice versa. I'm confused. Is the aqfe file right or wrong ? is 
> > > > Amibroker putting the data in the correct line ?
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> > > >>
> > > >> The AmiQuote aqfe.format file is in error. Changing the FORWARD_PE to FORWARD_EPS fixed the problem.
> > > >>
> > > >> TJ -- Updates needed to AmiQuote file and documentation, I beleive.
> > > >>
> > > >>
> > > >>
> > > >> --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> > > >> >
> > > >> > I don't understand something. The Yahoo data to be downloaded is labeled FORWARD_PE in the aqfe file, but the data from Yahoo 
> > > >> > is expected to FORWARD_EPS according to the Amibroker user guide > Using fundamental data.
> > > >> >
> > > >> > Is this part of the problem ?
> > > >> >
> > > >> >
> > > >> > --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> > > >> > >
> > > >> > > I find it is actually the aqfe.format file that holds the Forward P/E and there is an N/A from Yahoo in that location, 
> > > >> > > although their website has Forward P/E when looking at key statistics of any stock ??? Does that mean that Yahoo did not 
> > > >> > > transmit the data or does not ever transmit that data ?
> > > >> > > I thought the Forward P/E is calculated by Amibroker based on the Forward EPS ?
> > > >> > >
> > > >> > > --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> > > >> > > >
> > > >> > > > I just started with fundamental data and have the extended AmiQuote download from Yahoo, BUT in AmiBroker > Information > 
> > > >> > > > Financials > Forward EPS is 0 ? All other data is there, except of course the calculated Valuations > Forward P/E, which is 
> > > >> > > > also N/A.
> > > >> > > >
> > > >> > > > Is Forward EPS not coming in because something in the AmiQuote aqfn.format file, because one of the "skip", should not be 
> > > >> > > > there ??? (I have not altered this file)
> > > >> > > >
> > > >> > > > $NOQUOTES 1
> > > >> > > > $AUTOADD 1
> > > >> > > > $OVERWRITE 1
> > > >> > > > $SEPARATOR ,
> > > >> > > >
> > > >> > > > $FORMAT TICKER, FULLNAME, CLOSE, EPS, EPS_EST_CUR_YEAR, EPS_EST_NEXT_YEAR, EPS_EST_NEXT_QTR, PEG_RATIO, 
> > > >> > > > BOOK_VALUE_PER_SHARE, EBITDA, SKIP, REVENUE, SKIP, DIV_PAY_DATE, EX_DIV_DATE, DIVIDEND, ONE_YEAR_TARGET, SKIP, 
> > > >> > > > SHARES_FLOAT, SHARES_OUT
> > > >> > > >
> > > >> > >
> > > >> >
> > > >>
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > **** IMPORTANT PLEASE READ ****
> > > > This group is for the discussion between users only.
> > > > This is *NOT* technical support channel.
> > > >
> > > > TO GET TECHNICAL SUPPORT send an e-mail directly to
> > > > SUPPORT {at} amibroker.com
> > > >
> > > > TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
> > > > http://www.amibroker.com/feedback/
> > > > (submissions sent via other channels won't be considered)
> > > >
> > > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> > > > http://www.amibroker.com/devlog/
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> >
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/