Jumat, 19 Desember 2014

[smf_addin] Digest Number 3269

4 Messages

Digest #3269

Messages

Thu Dec 18, 2014 8:09 am (PST) . Posted by:

indinvestor111

Hi,


Is anybody else having trouble pulling up the most recent five years of income statements and balance sheets? All of a sudden my sheet is only showing the oldest five years of IS and BS data but the full 10 years if CF data....all symbols.


It's also happening with the quarterly data. The oldest data is there on the IS and BS, but all of it on the CF statement.


Thanks

Thu Dec 18, 2014 12:35 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

They must be working on it. I just used the
smfGetCSVFile-Template-MorningStar-Financials.xls template and IS and CF
came up fine, but BS only had the oldest years. However, if I look at it on
the web site, their BS web page is also screwed up:

http://financials.morningstar.com/balance-sheet/bs.html?t=MMM®ion=usa&culture=en-US

On Thu, Dec 18, 2014 at 9:09 AM, elandry@bmlcapital.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Is anybody else having trouble pulling up the most recent five years of
> income statements and balance sheets? All of a sudden my sheet is only
> showing the oldest five years of IS and BS data but the full 10 years if CF
> data....all symbols.
>
> It's also happening with the quarterly data. The oldest data is there on
> the IS and BS, but all of it on the CF statement.
>

Thu Dec 18, 2014 12:28 pm (PST) . Posted by:

jkslindsay

On a related note, I'd like to get the range of Target prices - the Yahoo "t8" is the average 1yr target, but on their AO page, they do indicate the High and the Low estimate.

http://finance.yahoo.com/q/ao?s=MMM+Analyst+Opinion http://finance.yahoo.com/q/ao?s=MMM+Analyst+Opinion

Any thoughts?

Thanks, Stewart

Thu Dec 18, 2014 12:38 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You can pull them from that web page, but it will be a single Internet
access for each ticker symbol:

=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM",1,"Mean Target:")
=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM",1,"Median Target:")
=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM",1,"High Target:")
=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM",1,"Low Target:")
=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM",1,"No. of Brokers:")

On Thu, Dec 18, 2014 at 9:33 AM, jkslindsay@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> On a related note, I'd like to get the range of Target prices - the Yahoo
> "t8" is the average 1yr target, but on their AO page, they do indicate the
> High and the Low estimate.
>
> http://finance.yahoo.com/q/ao?s=MMM+Analyst+Opinion
>
> Any thoughts?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar