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

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



PureBytes Links

Trading Reference Links

Hello,

Yahoo changes things from time to time, then AQ and/or format definitions need update.
Will check it out.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "brian_z111" <brian_z111@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Saturday, June 13, 2009 3:47 PM
Subject: [amibroker] Re: Where is Forward P/E data ???


>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
>
>
>



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

**** 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/