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" <[email protected]> To: <[email protected]> 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 [email protected], "gmorlosky" <gmorlo...@...> 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 [email protected], "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 [email protected], "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: <[email protected]> >> > > 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 [email protected], "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 [email protected], "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 [email protected], "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 [email protected], "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 > > >
