Minggu, 08 Februari 2015

[smf_addin] Digest Number 3316[1 Attachment]

10 Messages

Digest #3316

Messages

Sat Feb 7, 2015 3:36 am (PST) . Posted by:

cchangsue

Thanks Randy. It works.


I been using the RCHGetYahooQuotes and noticed that their data is inaccurate.


Do you know how I can get the last price on this website?
-http://web.tmxmoney.com/quote.php?qm_symbol=XMV

Sat Feb 7, 2015 3:50 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfGetTagContent("
http://web.tmxmoney.com/quote.php?qm_symbol=XMV","span",1,"priceLarge"))

On Sat, Feb 7, 2015 at 4:34 AM, cchangsue@... wrote:

>
> I been using the RCHGetYahooQuotes and noticed that their data is
> inaccurate.
>
> Do you know how I can get the last price on this website?
>
> -http://web.tmxmoney.com/quote.php?qm_symbol=XMV
>
>

Sat Feb 7, 2015 3:46 am (PST) . Posted by:

cchangsue

Hi Randy,


Do you know how I can get the last price from this website?
-http://web.tmxmoney.com/quote.php?qm_symbol=XMV


Price $27.41


Sat Feb 7, 2015 2:25 pm (PST) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

I don't know if you can pull this number as I have been unable to find it in
the source page, but maybe you know a trick.

On the DCF tab of Gurufocus, there's a DCF calculator for Fair Value.

http://www.gurufocus.com/dcf/tmk

I would love to get that Fair Value number in my spreadsheet and/or the
Margin of Safety number as well.

I've tried the formula that works for most of the other numbers I pull from
Gurufocus, but only get an error for this one. I'm sure it has something to
do with the java script it runs to do the calculation.

Thanks very much.

Best regards,

Jim

Sat Feb 7, 2015 4:37 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yeah, it's placed in there dynamically from the JavaScript.

But they do document the calculation, so you could do it yourself. For
example, they define it as:

- Growth value=E(0) x(1-x^n)/(1-x), where x=(1+g)/(1+d), n is the number
of years business will grow at the rate of g; d is the discount rate. E(0)
is the earnings of the company in the current year.

- Terminal value=E(0) x^n * y(1-y^m)/(1-y), where y=(1+t)/(1+d), where m
is the years of terminal growth; t is the terminal growth rate.

- Fair Value= Growth Value + Terminal Value

So, the computation of each field in those equations would be:

B7 (Ticker symbol): TMK
C7 (n): 10
D7 (d): 12%
E7 (m): 10
F7 (t): 4%
G7 (g): =RCHGetTableCell("http://www.gurufocus.com/financials/"&B7,1,"EPS
without NRI Growth")/100
H7 (EPS): =RCHGetTableCell("http://www.gurufocus.com/financials/
"&B7,0,"eps%252Bwithout%252BNRI","yesttm")
I7 (x): =(1+G7)/(1+D7)
J7 (GV): =H7*I7*(1-I7^C7)/(1-I7)
K7 (y): =(1+F7)/(1+D7)
L7 (TV): =H7*I7^C7*K7*(1-K7^E7)/(1-K7)
M7 (FB): =L7+J7

Note that C7 thru F7 are you assumptions and G7 and H7 are your retrieved
data items, and then I7 thru M7 do all the calculations with those data
fields. So it ends up looking like:

n d m t g EPS x GV y TV FV TMK 10 12.0% 10 4.0% 7.4% $4.00 0.9589 $31.99
0.9286 $17.89 $49.88 MMM 10 12.0% 10 4.0% 5.7% $7.49 0.9438 $55.23 0.9286
$28.56 $83.80

The Margin of Safety just compares the Fair Value to the current price, so
an easy calculation there.

Now, if you REALLY want to get a one-cell calculation:

=(RCHGetTableCell("http://www.gurufocus.com/financials/
"&B7,0,"eps%252Bwithout%252BNRI","yesttm")*((1+(RCHGetTableCell("
http://www.gurufocus.com/financials/"&B7,1,"EPS without NRI
Growth")/100))/(1+12%))^10*((1+4%)/(1+12%))*(1-((1+4%)/(1+12%))^10)/(1-((1+4%)/(1+12%))))+(RCHGetTableCell("
http://www.gurufocus.com/financials/
"&B7,0,"eps%252Bwithout%252BNRI","yesttm")*((1+(RCHGetTableCell("
http://www.gurufocus.com/financials/"&B7,1,"EPS without NRI
Growth")/100))/(1+12%))*(1-((1+(RCHGetTableCell("
http://www.gurufocus.com/financials/"&B7,1,"EPS without NRI
Growth")/100))/(1+12%))^10)/(1-((1+(RCHGetTableCell("
http://www.gurufocus.com/financials/"&B7,1,"EPS without NRI
Growth")/100))/(1+12%))))

...which just needs the ticker symbol in cell B7. :)

Might be a nice little user-defined function. :)

On Sat, Feb 7, 2015 at 3:25 PM, 'Jim Ranum' amt2100@... wrote:

>
>
> I don't know if you can pull this number as I have been unable to find it
> in the source page, but maybe you know a trick.
>
> On the DCF tab of Gurufocus, there's a DCF calculator for Fair Value.
>
>
>
>
>
> http://www.gurufocus.com/dcf/tmk
>
>
>
> I would love to get that Fair Value number in my spreadsheet and/or the
> Margin of Safety number as well.
>
> I've tried the formula that works for most of the other numbers I pull
> from Gurufocus, but only get an error for this one. I'm sure it has
> something to do with the java script it runs to do the calculation.
>
>
>
>

Sat Feb 7, 2015 4:49 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

PS: I decided to save the worksheet I threw together for this, so I
attached it.

On Sat, Feb 7, 2015 at 3:25 PM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I don't know if you can pull this number as I have been unable to find it
> in the source page, but maybe you know a trick.
>
> On the DCF tab of Gurufocus, there's a DCF calculator for Fair Value.
>
>
>
>
>
> http://www.gurufocus.com/dcf/tmk
>
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)

Sat Feb 7, 2015 7:20 pm (PST) . Posted by:

"Jim Ranum" amt2100

Wow!

Randy, you are the man.

That is awesome! Really appreciate you "showing your work" too. Very educational.

Thanks so much.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, February 07, 2015 7:50 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus Fair Value [1 Attachment]

[Attachment(s) from Randy Harmelink included below]

PS: I decided to save the worksheet I threw together for this, so I attached it.

On Sat, Feb 7, 2015 at 3:25 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

I don't know if you can pull this number as I have been unable to find it in the source page, but maybe you know a trick.

On the DCF tab of Gurufocus, there's a DCF calculator for Fair Value.

http://www.gurufocus.com/dcf/tmk

Sat Feb 7, 2015 10:43 pm (PST) . Posted by:

patricklee_hc

Hi Randy,


I was trying to get the abovementioned data from Gurufocus but could not seem to get it right.

Sun Feb 8, 2015 12:33 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/dividend/"&$B4,"h1",-1,">Dividend
Yield"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/dividend/"&$B4,"h1",-1,">Dividend
Payout Ratio"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/dividend/"&$B4,"h1",-1,">Growth
Rate (5-year)"))
=RCHGetTableCell("http://www.gurufocus.com/financials/
"&$B4,0,"Dividends%252BPer%252BShare","yesttm")

On Sat, Feb 7, 2015 at 10:31 PM, patricklee_hc@... wrote:

> I was trying to get the abovementioned data from Gurufocus but could not
> seem to get it right.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 03.10

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)