Minggu, 09 Desember 2012

[smf_addin] Digest Number 2428

7 New Messages

Digest #2428

Messages

Sat Dec 8, 2012 5:12 pm (PST) . Posted by:

"cocoaacc" cocoaacc

Dear Randy,
I am trying to upload my excel spreadsheet to blog.

I try to open SMF spreadsheet in blog and my excel software has add the SMF function, I am wondering if the function work well. ???

If someone has not add SMF function in his excel software and he try to open the SMF spreadsheet in blog, I am wondering if it works......???

Thanks!
Will

Sat Dec 8, 2012 5:30 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I have no idea what you're even asking...the concept of opening
a spreadsheet in a blog is foreign to me.

On Sat, Dec 8, 2012 at 6:12 PM, cocoaacc <cocoaacc@yahoo.com.hk> wrote:

> I am trying to upload my excel spreadsheet to blog.
>
> I try to open SMF spreadsheet in blog and my excel software has add the
> SMF function, I am wondering if the function work well. ???
>
> If someone has not add SMF function in his excel software and he try to
> open the SMF spreadsheet in blog, I am wondering if it works......???
>

Sat Dec 8, 2012 5:46 pm (PST) . Posted by:

"cocoaacc" cocoaacc

Dear Randy,
I am trying to upload my excel spreadsheet to blog.

I try to open SMF spreadsheet in blog and my excel software has add the SMF function, I am wondering if the function work well. ???

If someone has not add SMF function in his excel software and he try to open the SMF spreadsheet in blog, I am wondering if it works......???

Thanks!
Will

Sat Dec 8, 2012 8:33 pm (PST) . Posted by:

"zbgb952" zbgb952

How does one use this in an Excel spreadsheet. It tried typing it into a spreadsheet and all that came up was:

Growth Profitability and Financial Ratios for 3M Co

When I click on the http part only, the spreadsheet is downloaded, but I need something that imports it into an existing spreadsheet that I am working with.

Why does only the title appear when i try this?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The M* web page it came from no longer exists. They've added it to a
> dynamically generated web page, which means there is no data in the source
> code of that web page to extract.
>
> I've been suggesting people use this on a separate worksheet, and grab the
> data from it:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
>
> On Fri, Dec 7, 2012 at 12:10 AM, zbgb952 <mb0329@...> wrote:
>
> > Randy, I am finding several are returning me an 'error' message in all
> > cases. This one is supposed to return eps 3 yr growth. Any idea why?
> >
>

Sat Dec 8, 2012 11:31 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You need to array-enter it over a range.

On Sat, Dec 8, 2012 at 9:33 PM, zbgb952 <mb0329@msn.com> wrote:

> How does one use this in an Excel spreadsheet. It tried typing it into a
> spreadsheet and all that came up was:
>
> Growth Profitability and Financial Ratios for 3M Co
>
> When I click on the http part only, the spreadsheet is downloaded, but I
> need something that imports it into an existing spreadsheet that I am
> working with.
>
> Why does only the title appear when i try this?
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > I've been suggesting people use this on a separate worksheet, and grab
> the
> > data from it:
> >
> > =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
>

Sun Dec 9, 2012 1:34 am (PST) . Posted by:

"zbgb952" zbgb952

Can this be fixed. It worked a couple weeks ago, not it returns error.
878 is SECTOR.

It seems like a lot of these have died lately.

thx.

Sun Dec 9, 2012 1:40 am (PST) . Posted by:

"zbgb952" zbgb952

Also..please note that I did download your new smf-elements-4.txt file
prior to running my spreadsheet which supposely updated this. I still got error message for sector.

--- In smf_addin@yahoogroups.com, "zbgb952" <mb0329@...> wrote:
>
> Can this be fixed. It worked a couple weeks ago, not it returns error.
> 878 is SECTOR.
>
> It seems like a lot of these have died lately.
>
> thx.
>

Tidak ada komentar:

Posting Komentar