Selasa, 21 April 2015

[smf_addin] Digest Number 3387

13 Messages

Digest #3387
3b
Re: Morningstar gold, silver, bronze ratings by "Randy Harmelink" rharmelink
4b
Re: Company Description - element number 994 by "Randy Harmelink" rharmelink
5b
Re: Using RCHGetTableCell for Google by "Randy Harmelink" rharmelink
6a
Extract Shiller PE Ratio by ridgebacksexcel
6b
Re: Extract Shiller PE Ratio by "Randy Harmelink" rharmelink

Messages

Mon Apr 20, 2015 7:44 am (PDT) . Posted by:

rr76012

4/20/2015


Hello Randy,


Re: fyi, I think maybe rchgetelementnumber 14428 maybe reporting wrong info?


This element number is reporting 10.4% for Wal-Mart.


But the Morningstar website shows 5.1%? I think this is the right number?
Earnings Estimates for Wal-Mart Stores Inc (WMT) from Morningstar.com http://financials.morningstar.com/valuation/earnings-estimates.html?t=WMT®ion=usa&culture=en-US


Earnings Estimates for Wal-Mart Stores Inc (WMT) from Morningstar.com http://financials.morningstar.com/valuation/earnings-estimates.html?t=WMT®ion=usa&culture=en-US See Wal-Mart Stores Inc's earnings estimates and analyst ratings based on Wall Street analysts's analysis.



View on financials.morningstar.com http://financials.morningstar.com/valuation/earnings-estimates.html?t=WMT®ion=usa&culture=en-US
Preview by Yahoo




rr76012


Mon Apr 20, 2015 8:40 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Element #14428 isn't the forecasted 5-year growth rate, it's the growth
rate implied by the 2nd forecast year EPS estimates from 90 days ago. So
10.4% is correct. It comes from this static web page:

http://financials.morningstar.com/valuation/annual-estimate-list.action?t=WMT

Element 14434 is the forecasted 5-year growth rate, and comes from this
static web page:

http://financials.morningstar.com/valuation/forward-comparisons-list.action?t=WMT

On Mon, Apr 20, 2015 at 7:44 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Re: fyi, I think maybe rchgetelementnumber 14428 maybe reporting wrong
> info?
>
> This element number is reporting 10.4% for Wal-Mart.
>
> But the Morningstar website shows 5.1%? I think this is the right number?
>
>

Mon Apr 20, 2015 8:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. Looks like elements 14401 thru 14433 have the wrong descriptions on
them on the RCHGetElementNumber-Element-Definitions.xls workbook -- they
should be:

*#* *Usage* *Source* *Element* Template or Notes Updated 14401 S
MorningstarAE Annual Estimates -- As Of Date
SMF-Template-Morningstar-Stock-Data.xls 41705 14402 S MorningstarAE Annual
Estimates -- Year 1 Date SMF-Template-Morningstar-Stock-Data.xls 41705
14403 S MorningstarAE Annual Estimates -- Year 1 High Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14404 S MorningstarAE Annual
Estimates -- Year 1 High Growth % SMF-Template-Morningstar-Stock-Data.xls
41705 14405 S MorningstarAE Annual Estimates -- Year 1 Low Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14406 S MorningstarAE Annual
Estimates -- Year 1 Low Growth % SMF-Template-Morningstar-Stock-Data.xls
41705 14407 S MorningstarAE Annual Estimates -- Year 1 Median Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14408 S MorningstarAE Annual
Estimates -- Year 1 Median Growth % SMF-Template-Morningstar-Stock-Data.xls
41705 14409 S MorningstarAE Annual Estimates -- Year 1 30 Days Ago Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14410 S MorningstarAE Annual
Estimates -- Year 1 30 Days Ago Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705 14411 S MorningstarAE Annual
Estimates -- Year 1 60 Days Ago Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14412 S MorningstarAE Annual
Estimates -- Year 1 60 Days Ago Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705 14413 S MorningstarAE Annual
Estimates -- Year 1 90 Days Ago Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14414 S MorningstarAE Annual
Estimates -- Year 1 90 Days Ago Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705 14415 S MorningstarAE Annual
Estimates -- Year 1 Number of Estimates
SMF-Template-Morningstar-Stock-Data.xls 41705 14416 S MorningstarAE Annual
Estimates -- Year 2 Date SMF-Template-Morningstar-Stock-Data.xls 41705
14417 S MorningstarAE Annual Estimates -- Year 2 High Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14418 S MorningstarAE Annual
Estimates -- Year 2 High Growth % SMF-Template-Morningstar-Stock-Data.xls
41705 14419 S MorningstarAE Annual Estimates -- Year 2 Low Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14420 S MorningstarAE Annual
Estimates -- Year 2 Low Growth % SMF-Template-Morningstar-Stock-Data.xls
41705 14421 S MorningstarAE Annual Estimates -- Year 2 Median Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14422 S MorningstarAE Annual
Estimates -- Year 2 Median Growth % SMF-Template-Morningstar-Stock-Data.xls
41705 14423 S MorningstarAE Annual Estimates -- Year 2 30 Days Ago Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14424 S MorningstarAE Annual
Estimates -- Year 2 30 Days Ago Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705 14425 S MorningstarAE Annual
Estimates -- Year 2 60 Days Ago Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14426 S MorningstarAE Annual
Estimates -- Year 2 60 Days Ago Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705 14427 S MorningstarAE Annual
Estimates -- Year 2 90 Days Ago Estimate
SMF-Template-Morningstar-Stock-Data.xls 41705 14428 S MorningstarAE Annual
Estimates -- Year 2 90 Days Ago Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705 14429 S MorningstarAE Annual
Estimates -- Year 2 Number of Estimates
SMF-Template-Morningstar-Stock-Data.xls 41705 14430 S MorningstarAE Annual
Estimates -- Year 1 Mean Estimate SMF-Template-Morningstar-Stock-Data.xls
41705 14431 S MorningstarAE Annual Estimates -- Year 1 Mean Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705 14432 S MorningstarAE Annual
Estimates -- Year 2 Mean Estimate SMF-Template-Morningstar-Stock-Data.xls
41705 14433 S MorningstarAE Annual Estimates -- Year 2 Mean Growth %
SMF-Template-Morningstar-Stock-Data.xls 41705

Mon Apr 20, 2015 11:17 am (PDT) . Posted by:

rr76012

4/20/2015


Hello Randy,


With your recommendation, I have updated my smfUpdateDownloadTable-Sample.xls, it works great!


Thank you.
rr76012

Mon Apr 20, 2015 9:44 am (PDT) . Posted by:

lezm001

I use this for mutual funds and it still works fine:

=RCHGetElementNumber($B3,5064) where B3 contains the ticker



Mon Apr 20, 2015 9:47 am (PDT) . Posted by:

lezm001

I was using your recommend solution since January 21 but now it no longer works. Any idea what may have changed?

=PROPER(smfstrExtr(RCHGetWebData("http://quotes.morningstar.com/fund/xxxxx/f?t= http://quotes.morningstar.com/fund/xxxxx/f?t="&B3,"r_star",50,10),"'r_","_"))



Mon Apr 20, 2015 12:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

MorningStar has removed that web page address. Try this one instead:

=PROPER(smfStrExtr(RCHGetWebData("
http://performance.morningstar.com/fund/performance-return.action?t=
"&$B3,"r_star",50,10),"'r_","_"))

On Mon, Apr 20, 2015 at 9:47 AM, dlezman@steelcase.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I was using your recommend solution since January 21 but now it no longer
> works. Any idea what may have changed?
>
> =PROPER(smfstrExtr(RCHGetWebData("
> http://quotes.morningstar.com/fund/xxxxx/f?t=
> "&B3,"r_star",50,10),"'r_","_"))
>

Mon Apr 20, 2015 10:56 am (PDT) . Posted by:

jumonville


All,

Since I couldn't get this to work I made something using RCHGetWebData().

I thought some of y'all might be interested in it.

In Excel 2010:

=RCHGetWebData("http://www.finviz.com/quote.ashx?t="&MainTicker,"fullview-profile",(FIND("</td>",RCHGetWebData("http://www.finviz.com/quote.ashx?t="&MainTicker,"fullview-profile"))-32),31)

Enjoy!

Timothy A. Jumonville
3506 Doris Drive
Tallahassee, FL 32303850-562-3330

Mon Apr 20, 2015 12:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for sharing!

Element #994 is just the "description" from the ETF Investment Outlook web
site's listing of ETFs, so really just the name of the ETF.

Just an FYI -- your formula below can be done more simply as:

=RCHGetTableCell("http://www.finviz.com/quote.ashx?t=
"&D6,0,"fullview-profile")

On Mon, Apr 20, 2015 at 10:56 AM, biggntuff@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Since I couldn't get this to work I made something using RCHGetWebData().
> I thought some of y'all might be interested in it.
> In Excel 2010:
> =RCHGetWebData("http://www.finviz.com/quote.ashx?t=
> "&MainTicker,"fullview-profile",(FIND("</td>",RCHGetWebData("
> http://www.finviz.com/quote.ashx?t=
> "&MainTicker,"fullview-profile"))-32),31)
> Enjoy!
>
>

Mon Apr 20, 2015 6:09 pm (PDT) . Posted by:

spudtatro

Group,


I am trying to use the RCHGetTableCell for Google on the summary page to extract the shares value. The formula I wrote is as follows


=RCHGetTableCell("https://www.google.com/finance?q="&Ticker, 1, "shares")



However, when executed it returns the word "Range" which is the first word in the column. When I change the cell # to 2 it gives me the value for the stock price range. It does not matter what phrase I put in "quotes", as it appears to just grab either cell 1 or cell 2. From this google table, I want to be over to the right one column and down 3, however, when I put in any other cell number, it gives me an error.


Here is the syntax for the formula


=RCHGetTableCell( URL, Cell#, [Find1], [Find2], [Find3], [Find4], [Row#], [EndMarker], [Look#], [ErrorMsg], [Type] )



I am sure that I am using this RCHGetTableCell function incorrectly and would appreciate any guidance.


Thank you.


Mon Apr 20, 2015 7:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's because "shares" all by itself is not a good search term. That word
appears numerous times in the source code of the web page prior to that
table (usually in JavaScript data where a news item is talking about the
number of shares traded on a given day). In this case, the ">" prefix works
great:

=RCHGetTableCell("https://www.google.com/finance?q="&C7, 1, ">Shares")

...although that trick only works on web pages that have their source code
coded that way.

On Mon, Apr 20, 2015 at 6:09 PM, labsrcool@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am trying to use the RCHGetTableCell for Google on the summary page to
> extract the shares value. The formula I wrote is as follows
>
> =RCHGetTableCell("https://www.google.com/finance?q="&Ticker, 1, "shares")
>
> However, when executed it returns the word "Range" which is the first word
> in the column. When I change the cell # to 2 it gives me the value for the
> stock price range. It does not matter what phrase I put in "quotes", as it
> appears to just grab either cell 1 or cell 2. From this google table, I
> want to be over to the right one column and down 3, however, when I put in
> any other cell number, it gives me an error.
>

Mon Apr 20, 2015 9:29 pm (PDT) . Posted by:

ridgebacksexcel

Randy,


I am struggling trying the extract the Current Shiller PE Ratio from this web page:


http://www.multpl.com/shiller-pe/ http://www.multpl.com/shiller-pe/


The figure I want to extract is currently showing 27.32


Any ideas on what might be the best formula to do this?


I had it working for a while with a fairly clumsy one but now I can't seem to get anything to work.


Thanks.



Mon Apr 20, 2015 9:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Easiest would seem to be pulling it out of the META tag at the beginning of
the web page:

=smfConvertData(smfStrExtr(RCHGetWebData("http://www.multpl.com/shiller-pe","Current
Shiller PE Ratio is",40)," is ",","))

...or pull it from the "table" page instead:

=RCHGetTableCell("http://www.multpl.com/shiller-pe/table
",2,"id=""datatable""","<tr","<tr")

On Mon, Apr 20, 2015 at 9:29 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am struggling trying the extract the Current Shiller PE Ratio from this
> web page:
>
> http://www.multpl.com/shiller-pe/
>
> The figure I want to extract is currently showing 27.32
>
> Any ideas on what might be the best formula to do this?
>
> I had it working for a while with a fairly clumsy one but now I can't
> seem to get anything to work.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar