9 New Messages
Digest #2473
Messages
Sat Jan 19, 2013 12:58 pm (PST) . Posted by:
"gobi5" gobi5
I have been having some luck pulling from the "print" pages for morningstar, but now I'm having trouble getting one to work.
From this page:
http://financials.morningstar.com/valuation/price-ratio.html?ops=p&t=RBCAA
How would I get the fourth column in the "Dividend Yield %" row in the first table?
From this page:
http://financials.
How would I get the fourth column in the "Dividend Yield %" row in the first table?
Sat Jan 19, 2013 1:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That web page is dynamically generated, using JavaScript. The JavaScript
code gets the data you're after from this web page:
http://financials.morningstar.com/valuation/current-valuation-list.action?&t=RBCAA
So, if "fourth column" means the fourth data column (first column is
actually the row description):
=RCHGetTableCell("
http://financials.morningstar.com/valuation/current-valuation-list.action?&t=RBCAA ",4,">Dividend
Yield")
On Sat, Jan 19, 2013 at 12:30 PM, gobi5 cmaxmagee@gmail.com > wrote:
> I have been having some luck pulling from the "print" pages for
> morningstar, but now I'm having trouble getting one to work.
>
> From this page:
>
> http://financials.morningstar.com/valuation/price-ratio.html?ops=p&t=RBCAA
>
> How would I get the fourth column in the "Dividend Yield %" row in the
> first table?
>
code gets the data you're after from this web page:
http://financials.
So, if "fourth column" means the fourth data column (first column is
actually the row description)
=RCHGetTableCell(
http://financials.
Yield")
On Sat, Jan 19, 2013 at 12:30 PM, gobi5 cmaxmagee@gmail.
> I have been having some luck pulling from the "print" pages for
> morningstar, but now I'm having trouble getting one to work.
>
> From this page:
>
> http://financials.
>
> How would I get the fourth column in the "Dividend Yield %" row in the
> first table?
>
Sat Jan 19, 2013 3:58 pm (PST) . Posted by:
"lewglenn" lewglenn
Do any of the add-ons return the Sharpe Ratio over specified periods for arbitrary ETFs or equities? I realize that these could be computed from the downloaded histories with the RCHGetYahooQuotes function but perhaps this has already been done in another add-on?
Thanks.
Thanks.
Sat Jan 19, 2013 5:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You can get the ratio from MorningStar for mutual funds and ETFs. For
example:
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=SPY
On Sat, Jan 19, 2013 at 4:58 PM, lewglenn lewglenn@yahoo.com > wrote:
> Do any of the add-ons return the Sharpe Ratio over specified periods for
> arbitrary ETFs or equities? I realize that these could be computed from the
> downloaded histories with the RCHGetYahooQuotes function but perhaps this
> has already been done in another add-on?
>
example:
http://quicktake.
On Sat, Jan 19, 2013 at 4:58 PM, lewglenn lewglenn@yahoo.
> Do any of the add-ons return the Sharpe Ratio over specified periods for
> arbitrary ETFs or equities? I realize that these could be computed from the
> downloaded histories with the RCHGetYahooQuotes function but perhaps this
> has already been done in another add-on?
>
Sun Jan 20, 2013 12:01 am (PST) . Posted by:
"calhandon" calhandon
Pulling up the "SMF-Template-Reuters-Ratios-Comparison.xls" template today and trying several stocks, all fields are "Error". Has Reuters stopped providing this information?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> No. Reuters dropped them from their web pages...
>
> On Thu, Dec 27, 2012 at 9:31 PM, rjemery7 wrote:
>
> > FWIW, given the template SMF-Template-Reuters-Ratios-Comparison.xls, the
> > S&P 500 function calls in the last column no longer seem to be valid.
> >
>
--- In smf_addin@yahoogrou
>
> No. Reuters dropped them from their web pages...
>
> On Thu, Dec 27, 2012 at 9:31 PM, rjemery7 wrote:
>
> > FWIW, given the template SMF-Template-
> > S&P 500 function calls in the last column no longer seem to be valid.
> >
>
Sun Jan 20, 2013 12:05 am (PST) . Posted by:
"calhandon" calhandon
Is there anywhere else to obtain any of this comparable data?
--- In smf_addin@yahoogroups.com , "calhandon" wrote:
>
> Pulling up the "SMF-Template-Reuters-Ratios-Comparison.xls" template today and trying several stocks, all fields are "Error". Has Reuters stopped providing this information?
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> >
> > No. Reuters dropped them from their web pages...
> >
> > On Thu, Dec 27, 2012 at 9:31 PM, rjemery7 wrote:
> >
> > > FWIW, given the template SMF-Template-Reuters-Ratios-Comparison.xls, the
> > > S&P 500 function calls in the last column no longer seem to be valid.
> > >
> >
>
--- In smf_addin@yahoogrou
>
> Pulling up the "SMF-Template-
>
>
>
> --- In smf_addin@yahoogrou
> >
> > No. Reuters dropped them from their web pages...
> >
> > On Thu, Dec 27, 2012 at 9:31 PM, rjemery7 wrote:
> >
> > > FWIW, given the template SMF-Template-
> > > S&P 500 function calls in the last column no longer seem to be valid.
> > >
> >
>
Sun Jan 20, 2013 12:16 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Depending on what you're after, you may be able to pick it up from Yahoo
for the SPY ETF...
But, unfortunately, Reuters dropped the S&P 500 data long ago.
On Sun, Jan 20, 2013 at 1:05 AM, calhandon bozo@donandcarla.com > wrote:
> Is there anywhere else to obtain any of this comparable data?
>
for the SPY ETF...
But, unfortunately, Reuters dropped the S&P 500 data long ago.
On Sun, Jan 20, 2013 at 1:05 AM, calhandon bozo@donandcarla.
> Is there anywhere else to obtain any of this comparable data?
>
Sun Jan 20, 2013 12:18 am (PST) . Posted by:
"calhandon" calhandon
It's not only the S&P 500 data, but company, sector and industry as well. All fields in the template are blank (Error).
I did find some of what I need on MSN and will look at Yahoo as well.
Thank you Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Depending on what you're after, you may be able to pick it up from Yahoo
> for the SPY ETF...
>
> But, unfortunately, Reuters dropped the S&P 500 data long ago.
>
> On Sun, Jan 20, 2013 at 1:05 AM, calhandon wrote:
>
> > Is there anywhere else to obtain any of this comparable data?
> >
>
I did find some of what I need on MSN and will look at Yahoo as well.
Thank you Randy.
--- In smf_addin@yahoogrou
>
> Depending on what you're after, you may be able to pick it up from Yahoo
> for the SPY ETF...
>
> But, unfortunately, Reuters dropped the S&P 500 data long ago.
>
> On Sun, Jan 20, 2013 at 1:05 AM, calhandon wrote:
>
> > Is there anywhere else to obtain any of this comparable data?
> >
>
Sun Jan 20, 2013 12:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Well, right now the web pages are empty. It may be because they are
updating things right now...
On Sun, Jan 20, 2013 at 1:18 AM, calhandon bozo@donandcarla.com > wrote:
> It's not only the S&P 500 data, but company, sector and industry as well.
> All fields in the template are blank (Error).
>
> I did find some of what I need on MSN and will look at Yahoo as well.
>
updating things right now...
On Sun, Jan 20, 2013 at 1:18 AM, calhandon bozo@donandcarla.
> It's not only the S&P 500 data, but company, sector and industry as well.
> All fields in the template are blank (Error).
>
> I did find some of what I need on MSN and will look at Yahoo as well.
>
Tidak ada komentar:
Posting Komentar