10 New Messages
Digest #2471
Messages
Thu Jan 17, 2013 7:18 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I stumble across the Morningstar education today and thought others might find it useful.
The link below is to the Star Rating. It helped me better understand how they determine the values.
Or use the information to develop your own Star rating system. I'm sure they do not devolve all of the rating system
http://ibd.morningstar.com/classroom/client/ETR102.html?docId=144047 http://ibd.morningstar.com/classroom/client/ETR102.html?docId=144047&page=3&CN=ETR102&view=course&courseLevel=500¤tLevel=400 > &page=3&CN=ETR102&view=course&courseLevel=500¤tLevel=400
these aren't in depth articles but they will give you an idea of how Morningstar uses the information
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, January 11, 2013 10:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar star's rating
They're no longer using an image on the web page for the star rating. Instead, try:
=0+smfStrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t= "&C5,"r_star"),"r_star","'")
On Fri, Jan 11, 2013 at 8:24 PM, Jacob Jose pepecan47@yahoo.ca > wrote:
The retrieval of the M* star rating stopped working. This is the formula I've been using successfully for several months:
=VALUE(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t= http://quote.morningstar.com/stock/s.aspx?t=%22&A3,%22star.gif%22,1,-1 > "&A3,"star.gif",1,-1))&"*"
Any idea what is going on?
The link below is to the Star Rating. It helped me better understand how they determine the values.
Or use the information to develop your own Star rating system. I'm sure they do not devolve all of the rating system
http://ibd.mornings
these aren't in depth articles but they will give you an idea of how Morningstar uses the information
Kermit
From: smf_addin@yahoogrou
Sent: Friday, January 11, 2013 10:31 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Morningstar star's rating
They're no longer using an image on the web page for the star rating. Instead, try:
=0+smfStrExtr(
On Fri, Jan 11, 2013 at 8:24 PM, Jacob Jose pepecan47@yahoo.
The retrieval of the M* star rating stopped working. This is the formula I've been using successfully for several months:
=VALUE(RCHGetWebDat
Any idea what is going on?
Thu Jan 17, 2013 7:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Actually, about as easy as it gets. For example, to get the current P/E
Ratio:
=RCHGetTableCell("http://www.bloomberg.com/quote/PETR4:BZ ",1,">Current P/E
Ratio")
On Thu, Jan 17, 2013 at 6:22 AM, cesarcrivelli cesarcrivelli@gmail.com >wrote:
>
> I would like to retrieve most of the fields that are below the chart, as
> P/E ratio, Mkt Cap, Shares Outstanding, etc.
>
> http://www.bloomberg.com/quote/PETR4:BZ
>
> Do you think the AddIn can get this data?
>
Ratio:
=RCHGetTableCell(
Ratio")
On Thu, Jan 17, 2013 at 6:22 AM, cesarcrivelli cesarcrivelli@
>
> I would like to retrieve most of the fields that are below the chart, as
> P/E ratio, Mkt Cap, Shares Outstanding, etc.
>
> http://www.bloomber
>
> Do you think the AddIn can get this data?
>
Thu Jan 17, 2013 10:35 am (PST) . Posted by:
"cesarcrivelli" cesarcrivelli
Many Thanks!
I am reading the documentation too.
--- In smf_addin@yahoogrou
>
> Actually, about as easy as it gets. For example, to get the current P/E
> Ratio:
>
> =RCHGetTableCell(
> Ratio")
>
> On Thu, Jan 17, 2013 at 6:22 AM, cesarcrivelli wrote:
>
> >
> > I would like to retrieve most of the fields that are below the chart, as
> > P/E ratio, Mkt Cap, Shares Outstanding, etc.
> >
> > http://www.bloomber
> >
> > Do you think the AddIn can get this data?
> >
>
Thu Jan 17, 2013 2:42 pm (PST) . Posted by:
"thomasdardanic" thomasdardanic
Hi Everyone:
I am trying to figure out if anyone has ever been able to find analyst consensus estimates with the add-in? Specifically, I look at REITs which analyst estimate Funds From Operations ("FFO") not EPS.
Thoughts?
I am trying to figure out if anyone has ever been able to find analyst consensus estimates with the add-in? Specifically, I look at REITs which analyst estimate Funds From Operations ("FFO"
Thoughts?
Thu Jan 17, 2013 3:10 pm (PST) . Posted by:
"Martin Topper" mtopper
If this page provides info that is useful to you, it can be retrieved by the smf add-in using the get tables or get table cell functions I think.
Marty
http://finance.yahoo.com/q/ae?s=WSR+Analyst+Estimates
________________________________
From: thomasdardanic tomaj567@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, January 17, 2013 5:42 PM
Subject: [smf_addin] Analyst Concensus Estimates
Hi Everyone:
I am trying to figure out if anyone has ever been able to find analyst consensus estimates with the add-in? Specifically, I look at REITs which analyst estimate Funds From Operations ("FFO") not EPS.
Thoughts?
Marty
http://finance.
____________
From: thomasdardanic tomaj567@gmail.
To: smf_addin@yahoogrou
Sent: Thursday, January 17, 2013 5:42 PM
Subject: [smf_addin] Analyst Concensus Estimates
Hi Everyone:
I am trying to figure out if anyone has ever been able to find analyst consensus estimates with the add-in? Specifically, I look at REITs which analyst estimate Funds From Operations ("FFO"
Thoughts?
Thu Jan 17, 2013 4:40 pm (PST) . Posted by:
"hupsuli" hupsuli
I put all sorts of data into excel and the final look is something like this:
http://www.kolumbus.fi/cuddles/TMPStockCalc_screenshot.jpg
The .xls is posted in the Files and Uploads by forum members -section.
http://f1.grp.yahoofs.com/v1/gJD4UBMSOOAcLJLCdbicB3VjJPKVImnAwLHnoJH2zqyF7TqPuv9oAzh6YF9Gx781gdVjWAgElg_J2xGr1fygDATyEe6QAQ/Uploads%20by%20forum%20members/TMP%20Stock%20Calc.xls
http://www.kolumbus
The .xls is posted in the Files and Uploads by forum members -section.
http://f1.grp.
Fri Jan 18, 2013 6:36 am (PST) . Posted by:
"hupsuli" hupsuli
Thu Jan 17, 2013 7:19 pm (PST) . Posted by:
"Shubha Rajopadhye" rajops
Fri Jan 18, 2013 6:51 am (PST) . Posted by:
"iamruf" iamruf
Hi Randy, each of your revisions to my formulas are of course working very well. Many thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> It's probably still just a text string, so a numeric format wouldn't affect
> it. Instead of:
>
> =MID(D2,FIND("last",D2)+7,5)
>
> ...try:
>
> =0+MID(D2,FIND("last",D2)+7,5)
>
> The numeric operation will attempt to convert the string into a number and
> add it to zero, which just turns the original string into a number if it is
> a valid number. Another option would be:
>
> =VALUE(MID(D2,FIND("last",D2)+7,5))
>
> On Wed, Jan 16, 2013 at 6:18 PM, iamruf wrote:
>
> > I am using this formula =RCHGetWebData("
> > http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba \ck=jsonp1358089488792&symbols=ATL1879&webmasterId=101020&_=1358089550952
> > ",1,1000)
> > and then this formula to extract a value =MID(D2,FIND("last",D2)+7,5)which
> > returns:
> > ({"copyright":"Copyright (c) 2013 QuoteMedia,
> > Inc.","symbolcount";:1,"quotedata":[{"symbol":"ATL1879","datatype":"mutual
> > fund","entitlement";:"EOD";,"delaymin":null,"datetime":"2013-01-15T20:00:00-05:00","pricedata":{
> > "last":"11.4162", "change":"0.021", "changepercent":"0.184288",
> > "sharevolume":"0"}}]});
> >
> > In this case the result returned is 28.87 in general format.
> > When I click the format cell drop-down for currency, the $ symbol is
> > missing.
> > I have tried converting to text or number & back to currency but cannot
> > get the $ symbol.
> > Any suggestions? Thanks
> >
>
--- In smf_addin@yahoogrou
>
> It's probably still just a text string, so a numeric format wouldn't affect
> it. Instead of:
>
> =MID(D2,FIND(
>
> ...try:
>
> =0+MID(D2,FIND(
>
> The numeric operation will attempt to convert the string into a number and
> add it to zero, which just turns the original string into a number if it is
> a valid number. Another option would be:
>
> =VALUE(MID(D2,
>
> On Wed, Jan 16, 2013 at 6:18 PM, iamruf wrote:
>
> > I am using this formula =RCHGetWebData(
> > http://tmx.quotemed
> > ",1,1000)
> > and then this formula to extract a value =MID(D2,FIND(
> > returns:
> > ({"copyright&q
> > Inc.","
> > fund","
> > "last"
> > "sharevolume&q
> >
> > In this case the result returned is 28.87 in general format.
> > When I click the format cell drop-down for currency, the $ symbol is
> > missing.
> > I have tried converting to text or number & back to currency but cannot
> > get the $ symbol.
> > Any suggestions? Thanks
> >
>
Fri Jan 18, 2013 7:23 am (PST) . Posted by:
"iamruf" iamruf
Hi Randy,
The formula at the bottom is getting prices although I don`t understand how it works.
Is it possible to adapt the formula to get other data on this page.
Fund Type: Global Equity
52 Week High: 16.05
52 Week Low: 14.34
YTD Return (as of December 31, 2012): 11.69%
Load Type: Choice of Front or Back
MER: 2.94%
Eligiblity: RRSP
Who Should Invest
Consider this Fund if: the tax consequences of a mutual fund corporation are more suitable to your investment program or that of your registered plan; you want the growth potential of equity securities of foreign companies; you're investing for the longer term; you tolerate medium risk; with respect to Series T and Series V securities, you prefer monthly distribution of capital.(This is a box varies in length)
=RCHGetWebData("http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba \ck=jsonp1358089488792&symbols=AGF2107&webmasterId=101020&_=1358089550952",1,1000)
The formula at the bottom is getting prices although I don`t understand how it works.
Is it possible to adapt the formula to get other data on this page.
Fund Type: Global Equity
52 Week High: 16.05
52 Week Low: 14.34
YTD Return (as of December 31, 2012): 11.69%
Load Type: Choice of Front or Back
MER: 2.94%
Eligiblity: RRSP
Who Should Invest
Consider this Fund if: the tax consequences of a mutual fund corporation are more suitable to your investment program or that of your registered plan; you want the growth potential of equity securities of foreign companies; you're investing for the longer term; you tolerate medium risk; with respect to Series T and Series V securities, you prefer monthly distribution of capital.(This is a box varies in length)
=RCHGetWebData(
Tidak ada komentar:
Posting Komentar