[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

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@xxx> 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/