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
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.
>
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
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?
>
>
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:
Posting Komentar