4 New Messages
Digest #2492
Messages
Fri Feb 1, 2013 7:49 am (PST) . Posted by:
"tenenbaum88" tenenbaum88
Hi Randy,
I was going through the list of items available through the above function and I see there a few interesting calculated items at the bottom of the list.
My question is, how is the MFI earnings yield below calculated:
15013..1.3d....Y....N....N....Calculated......Magic Formula Investing -- Earnings Yield
I know it is EBIT/EV, but where does the underlying data come from? I only ask because EBIT seems to be interpreted differently depending on which site one uses and there can be large discrepancies when one-time items are included, which, in my opinion, it makes sense to exclude from this type of metric that purely looks at the valuation based on ongoing operational results. EV can also get skewed by unfunded pension liabilities ... particularly for large energy corps. If this is a pretty clean calc, though, it's a seriously useful series!
Thanks again
I was going through the list of items available through the above function and I see there a few interesting calculated items at the bottom of the list.
My question is, how is the MFI earnings yield below calculated:
15013..1.3d.
I know it is EBIT/EV, but where does the underlying data come from? I only ask because EBIT seems to be interpreted differently depending on which site one uses and there can be large discrepancies when one-time items are included, which, in my opinion, it makes sense to exclude from this type of metric that purely looks at the valuation based on ongoing operational results. EV can also get skewed by unfunded pension liabilities ... particularly for large energy corps. If this is a pretty clean calc, though, it's a seriously useful series!
Thanks again
Fri Feb 1, 2013 12:43 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The exact calculation:
Case "Magic Formula Investing -- Earnings Yield"
n1 = RCHGetElementNumber(pTicker, 949) ' Enterprise value
to EBITDA
RCHSpecialExtraction = 1 / n1
...so it just takes the Enterprise Value/EBITDA on the Yahoo Key Statistics
page and inverts it.
On Fri, Feb 1, 2013 at 8:49 AM, tenenbaum88 kenneth.dooley@gmail.com >wrote:
>
> I was going through the list of items available through the above function
> and I see there a few interesting calculated items at the bottom of the
> list.
>
> My question is, how is the MFI earnings yield below calculated:
>
> 15013..1.3d....Y....N....N....Calculated......Magic Formula Investing --
> Earnings Yield
>
> I know it is EBIT/EV, but where does the underlying data come from? I
> only ask because EBIT seems to be interpreted differently depending on
> which site one uses and there can be large discrepancies when one-time
> items are included, which, in my opinion, it makes sense to exclude from
> this type of metric that purely looks at the valuation based on ongoing
> operational results. EV can also get skewed by unfunded pension
> liabilities ... particularly for large energy corps. If this is a pretty
> clean calc, though, it's a seriously useful series!
>
Case "Magic Formula Investing -- Earnings Yield"
n1 = RCHGetElementNumber
to EBITDA
RCHSpecialExtractio
...so it just takes the Enterprise Value/EBITDA on the Yahoo Key Statistics
page and inverts it.
On Fri, Feb 1, 2013 at 8:49 AM, tenenbaum88 kenneth.dooley@
>
> I was going through the list of items available through the above function
> and I see there a few interesting calculated items at the bottom of the
> list.
>
> My question is, how is the MFI earnings yield below calculated:
>
> 15013..1.3d.
> Earnings Yield
>
> I know it is EBIT/EV, but where does the underlying data come from? I
> only ask because EBIT seems to be interpreted differently depending on
> which site one uses and there can be large discrepancies when one-time
> items are included, which, in my opinion, it makes sense to exclude from
> this type of metric that purely looks at the valuation based on ongoing
> operational results. EV can also get skewed by unfunded pension
> liabilities ... particularly for large energy corps. If this is a pretty
> clean calc, though, it's a seriously useful series!
>
Fri Feb 1, 2013 4:34 pm (PST) . Posted by:
"tenenbaum88" tenenbaum88
Thanks a lot, Randy
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> The exact calculation:
>
> Case "Magic Formula Investing -- Earnings Yield"
> n1 = RCHGetElementNumber(pTicker, 949) ' Enterprise value
> to EBITDA
> RCHSpecialExtraction = 1 / n1
>
> ...so it just takes the Enterprise Value/EBITDA on the Yahoo Key Statistics
> page and inverts it.
>
> On Fri, Feb 1, 2013 at 8:49 AM, tenenbaum88 wrote:
>
> >
> > I was going through the list of items available through the above function
> > and I see there a few interesting calculated items at the bottom of the
> > list.
> >
> > My question is, how is the MFI earnings yield below calculated:
> >
> > 15013..1.3d....Y....N....N....Calculated......Magic Formula Investing --
> > Earnings Yield
> >
> > I know it is EBIT/EV, but where does the underlying data come from? I
> > only ask because EBIT seems to be interpreted differently depending on
> > which site one uses and there can be large discrepancies when one-time
> > items are included, which, in my opinion, it makes sense to exclude from
> > this type of metric that purely looks at the valuation based on ongoing
> > operational results. EV can also get skewed by unfunded pension
> > liabilities ... particularly for large energy corps. If this is a pretty
> > clean calc, though, it's a seriously useful series!
> >
>
--- In smf_addin@yahoogrou
>
> The exact calculation:
>
> Case "Magic Formula Investing -- Earnings Yield"
> n1 = RCHGetElementNumber
> to EBITDA
> RCHSpecialExtractio
>
> ...so it just takes the Enterprise Value/EBITDA on the Yahoo Key Statistics
> page and inverts it.
>
> On Fri, Feb 1, 2013 at 8:49 AM, tenenbaum88 wrote:
>
> >
> > I was going through the list of items available through the above function
> > and I see there a few interesting calculated items at the bottom of the
> > list.
> >
> > My question is, how is the MFI earnings yield below calculated:
> >
> > 15013..1.3d.
> > Earnings Yield
> >
> > I know it is EBIT/EV, but where does the underlying data come from? I
> > only ask because EBIT seems to be interpreted differently depending on
> > which site one uses and there can be large discrepancies when one-time
> > items are included, which, in my opinion, it makes sense to exclude from
> > this type of metric that purely looks at the valuation based on ongoing
> > operational results. EV can also get skewed by unfunded pension
> > liabilities ... particularly for large energy corps. If this is a pretty
> > clean calc, though, it's a seriously useful series!
> >
>
Sat Feb 2, 2013 7:19 am (PST) . Posted by:
"bozo" calhandon
Thank you for the link to the JustCoveredCalls message group, Randy! Will look into it further.
RE: Bonds -- Same here, which is why I want to learn more about investing *directly* in *individual* bonds. You know exactly how much you're going to pay for an exact yield. Just have to monitor the price of the bond, just like with stocks. Our brokers all have separate web pages for bonds and half of it looks like Greek to me (sigh). They have their own jargon which is different from stocks. I'll learn it.
Have a great weekend!
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, February 01, 2013 7:56 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Which site has the most accurate Fundamental data?
For covered calls:
http://finance.groups.yahoo.com/group/justcoveredcalls/
I have a few add-in workbooks related to options over there.
But I don't do bonds. I'm especially not fond of bond funds, because the strength of a bond is a guaranteed return, which you lose from a bond fund, because all the only value it can have is the present value of its holdings. So, when interest rates go up, the bond fund will go down. But if you own the individual bond, you would still get the same return if you hold it to maturity.
And, with so many municipalities discussing bankruptcy because of pension and health care plans, municipal bonds ain't lookin' so good either.
On Fri, Feb 1, 2013 at 1:40 AM, bozo bozo@donandcarla.com > wrote:
Howdy Randy,
> But I was always the "paralysis by analysis" guy.
Unfortunately, this is where I find myself too many times as well. That's where I'm hoping the SMF add-in will help, by automating a lot of the manual website work I've been doing for years. BUT, the data has to be reliable and trustworthy enough for me to stop most of my manual Internet work.
> I primarily do covered calls ...
We've not gotten into any Options trading yet. Can you recommend a good site to learn some of the basics like covered calls, as you mention?
Personally, I would also like to learn more about investing directly in individual bonds of various types (U.S. Treasuries, Corp debt, etc.), instead of using ETFs that may or may not have the particular "mix" we're looking for. Any suggestions for this?
RE: Bonds -- Same here, which is why I want to learn more about investing *directly* in *individual* bonds. You know exactly how much you're going to pay for an exact yield. Just have to monitor the price of the bond, just like with stocks. Our brokers all have separate web pages for bonds and half of it looks like Greek to me (sigh). They have their own jargon which is different from stocks. I'll learn it.
Have a great weekend!
From: smf_addin@yahoogrou
Sent: Friday, February 01, 2013 7:56 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Which site has the most accurate Fundamental data?
For covered calls:
http://finance.
I have a few add-in workbooks related to options over there.
But I don't do bonds. I'm especially not fond of bond funds, because the strength of a bond is a guaranteed return, which you lose from a bond fund, because all the only value it can have is the present value of its holdings. So, when interest rates go up, the bond fund will go down. But if you own the individual bond, you would still get the same return if you hold it to maturity.
And, with so many municipalities discussing bankruptcy because of pension and health care plans, municipal bonds ain't lookin' so good either.
On Fri, Feb 1, 2013 at 1:40 AM, bozo bozo@donandcarla.
Howdy Randy,
> But I was always the "paralysis by analysis" guy.
Unfortunately, this is where I find myself too many times as well. That's where I'm hoping the SMF add-in will help, by automating a lot of the manual website work I've been doing for years. BUT, the data has to be reliable and trustworthy enough for me to stop most of my manual Internet work.
> I primarily do covered calls ...
We've not gotten into any Options trading yet. Can you recommend a good site to learn some of the basics like covered calls, as you mention?
Personally, I would also like to learn more about investing directly in individual bonds of various types (U.S. Treasuries, Corp debt, etc.), instead of using ETFs that may or may not have the particular "mix" we're looking for. Any suggestions for this?
Tidak ada komentar:
Posting Komentar