Thanks Randy.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That's the raw content of the table cell. RCHGetTableCell() would have done
> the extraction process on it and then converts the number based on your
> system settings. So you'll need to manually extract what you want from that
> string, such as:
>
> =smfstrExtr(D4,">","<")
>
> ..where D4 contains the raw data.
>
> On Sun, Sep 8, 2013 at 9:41 PM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> > I managed to get a number when I tried again but it has <b> before and
> > after the numbers. Is this normal or is there a way to avoid this? thanks.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2a

Re: Altman_Piotroski XLS

Mon Sep 9, 2013 5:35 am (PDT) . Posted by:

petekoch

It appears that CEF Connect has joined the club and sometime over
the last few days has changed its website, causing problems with
my workboot (CEFs_Data.xlsm). I'll try to correct it ASAP.

--- In smf_addin@yahoogroups.com, <petekoch@...> wrote:

To All,
I created the Altman-Piotroski worksheet. I've been messing with
closed-end funds and not individual stocks lately, so I didn't
notice. If/when I get the time, I'll see what I can do about
getting it in working condition. If you're into CEFs, I have a
sheet some might find useful. Give me some time to make it a bit
more user-friendly and to add explanations. It retrieves all data
from the 3 main CEF websites, CEF Connect, CEFA, and CEF Capital
Link.

Just a word about the grahaminvestor link above. I never trusted
it completely, finding that the numbers generated were too
generous, i.e., the Piotroski scores were generally too high. If
you subscribe to AAII, take a look at their Piotroski screen. It
spit out a few nice trades for me.

--- In smf_addin@yahoogroups.com, <pc_babe@...> wrote:

web page http://www.grahaminvestor.com/screens/piotroski-scores/

From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Sunday, September 1, 2013 7:41 PM
To: smf_addin@yahoogroups.com; smf_addin@yahoogroups.com;
smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Altman_Piotroski XLS

That's because it uses data from AdvFN, who has been tinkering
around with their data and web page processing over the past
month, so nothing from them is coming through at this point.

On Sun, Sep 1, 2013 at 1:11 PM, yjeffs1 <yjshaham@...> wrote:

All the data is in error and #value; any suggestion what is
missing?
Could it be older SMF functions versions?
Any instructions how to work it?

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

3a

Links

Mon Sep 9, 2013 5:47 am (PDT) . Posted by:

sleellano

Hi, I am new to SMF and can not open Links it is grayed out. Am I
missing something?
I downloaded the Functions file and opened a new Excel work sheet
and get: #VALUE!
in the Dividend Growth Rate (5-Year Annualized). I am using
Windows 7 Excel 2010
Thanks
Steve

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

3b

Re: Links

Mon Sep 9, 2013 5:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't know what you're referring to by "Links" or "Functions file" or
"Dividend Growth Rate (5-year annualized)".

If you're using specific formulas, please show them.

On Sun, Sep 8, 2013 at 1:08 PM, <sleellano@gmail.com> wrote:

>
> Hi, I am new to SMF and can not open Links it is grayed out. Am I missing
> something?
> I downloaded the Functions file and opened a new Excel work sheet and get:
> #VALUE!
> in the Dividend Growth Rate (5-Year Annualized). I am using Windows 7
> Excel 2010
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

3c

Re: Links

Mon Sep 9, 2013 6:47 am (PDT) . Posted by:

sleellano

The answer to my question apparently is in "Links" which in the
the "More drop down menu along with "Files, Database and
Attachments, Both Links and Database are grayed out, there for
none click able. If I can find out how to access Links I believe
I can figure the rest out.

Thanks for you help, Steve

--- In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I don't know what you're referring to by "Links" or "Functions
file" or "Dividend Growth Rate (5-year annualized)".

If you're using specific formulas, please show them.

On Sun, Sep 8, 2013 at 1:08 PM, <sleellano@...> wrote:

Hi, I am new to SMF and can not open Links it is grayed out. Am I
missing something?
I downloaded the Functions file and opened a new Excel work sheet
and get: #VALUE!
in the Dividend Growth Rate (5-Year Annualized). I am using
Windows 7 Excel 2010

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

3d

Re: Links

Mon Sep 9, 2013 7:31 am (PDT) . Posted by:

sleellano

It seems I am not being clear. The area I am referring to is in
the Yahoo Groups SMF_addin.

Links is where others have been refereed too for answers to
questions.

--- In smf_addin@yahoogroups.com, <sleellano@...> wrote:

The answer to my question apparently is in "Links" which in the
the "More drop down menu along with "Files, Database and
Attachments, Both Links and Database are grayed out, there for
none click able. If I can find out how to access Links I believe
I can figure the rest out.

Thanks for you help, Steve

--- In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I don't know what you're referring to by "Links" or "Functions
file" or "Dividend Growth Rate (5-year annualized)".

If you're using specific formulas, please show them.

On Sun, Sep 8, 2013 at 1:08 PM, <sleellano@...> wrote:

Hi, I am new to SMF and can not open Links it is grayed out. Am I
missing something?
I downloaded the Functions file and opened a new Excel work sheet
and get: #VALUE!
in the Dividend Growth Rate (5-Year Annualized). I am using
Windows 7 Excel 2010

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

3e

Re: Links

Mon Sep 9, 2013 7:42 am (PDT) . Posted by:

"Jim Ranum" amt2100

Those links, including "Links" are all greyed out because you're not logged into the group. It's happened to me a few times. Yahoo can be a pain in the arse.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of sleellano@gmail.com
Sent: Monday, September 09, 2013 10:32 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RE: Links

It seems I am not being clear. The area I am referring to is in the Yahoo Groups SMF_addin.

Links is where others have been refereed too for answers to questions.

--- In smf_addin@yahoogroups.com, <sleellano@...> wrote:

The answer to my question apparently is in "Links" which in the the "More drop down menu along with "Files, Database and Attachments, Both Links and Database are grayed out, there for none click able. If I can find out how to access Links I believe I can figure the rest out.

Thanks for you help, Steve

--- In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I don't know what you're referring to by "Links" or "Functions file" or "Dividend Growth Rate (5-year annualized)".

If you're using specific formulas, please show them.

On Sun, Sep 8, 2013 at 1:08 PM, <sleellano@...> wrote:

Hi, I am new to SMF and can not open Links it is grayed out. Am I missing something?
I downloaded the Functions file and opened a new Excel work sheet and get: #VALUE!
in the Dividend Growth Rate (5-Year Annualized). I am using Windows 7 Excel 2010

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

3f

Re: Links

Mon Sep 9, 2013 7:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The add-in shouldn't be doing anything with "Links", at least not with a
new worksheet. It does have to resolve links on an existing workbook when
you open it, if it uses the add-in. If that's what you mean, see the
"Location Errors" entry in the LINKS ares of the Yahoo group.

On Mon, Sep 9, 2013 at 6:47 AM, <sleellano@gmail.com> wrote:

> The answer to my question apparently is in "Links" which in the the
> "More drop down menu along with "Files, Database and Attachments, Both
> Links and Database are grayed out, there for none click able. If I can find
> out how to access Links I believe I can figure the rest out.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

3g

Re: Links

Mon Sep 9, 2013 7:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Ah, OK.

You do have to join the group to access that area.

On Mon, Sep 9, 2013 at 7:31 AM, <sleellano@gmail.com> wrote:

> It seems I am not being clear. The area I am referring to is in the
> Yahoo Groups SMF_addin.
>
> Links is where others have been refereed too for answers to questions.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

3h

Re: Links

Mon Sep 9, 2013 8:52 am (PDT) . Posted by:

sleellano

Yahoo Groups says I am signed in as sleellano to SMF. Is there
somewhere else I need to go. I was able to down load

smf_addin

--- In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Ah, OK.

You do have to join the group to access that area.

On Mon, Sep 9, 2013 at 7:31 AM, <sleellano@...> wrote:

It seems I am not being clear. The area I am referring to is in
the Yahoo Groups SMF_addin.

Links is where others have been refereed too for answers to
questions.

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

4a

Re: basic quote

Mon Sep 9, 2013 6:40 am (PDT) . Posted by:

"Jim Ranum" amt2100

Hi anyone,

I've looked at the example spreadsheets for yahoo quotes and they are all set up for tables. Is there a simple one cell instruction I can put into an existing spreadsheet to just give me the current price of a ticker in the adjacent column?

I just want to copy the cell down as I need it. Ticker-A1, Price-A2.

Thanks very much,

Jim

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4b

Re: basic quote

Mon Sep 9, 2013 7:08 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

=smfPricesByDates(B2, TODAY()) where ticker symbol is in cell B2

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Jim Ranum
Sent: Monday, September 09, 2013 9:40 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] basic quote

Hi anyone,

I've looked at the example spreadsheets for yahoo quotes and they are all set up for tables. Is there a simple one cell instruction I can put into an existing spreadsheet to just give me the current price of a ticker in the adjacent column?
I just want to copy the cell down as I need it. Ticker-A1, Price-A2.

Thanks very much,
Jim

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4c

Re: basic quote

Mon Sep 9, 2013 7:32 am (PDT) . Posted by:

"Jim Ranum" amt2100

Amazing.

Works perfectly. Thanks!!

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Kermit W. Prather
Sent: Monday, September 09, 2013 10:09 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] basic quote

=smfPricesByDates(B2, TODAY()) where ticker symbol is in cell B2

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Jim Ranum
Sent: Monday, September 09, 2013 9:40 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] basic quote

Hi anyone,

I've looked at the example spreadsheets for yahoo quotes and they are all set up for tables. Is there a simple one cell instruction I can put into an existing spreadsheet to just give me the current price of a ticker in the adjacent column?

I just want to copy the cell down as I need it. Ticker-A1, Price-A2.

Thanks very much,

Jim

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4d

Re: basic quote

Mon Sep 9, 2013 7:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Don't do that unless you want a volatile formula. It will recalculate
anytime something changes in the workbook, and be VERY slow if you have a
number of them.

Instead:

=RCHGetYahooQuotes(A2, "l1")

Check the documentation of that function for available Yahoo codes for
various data items.

Note that a large number of the above formulas will also makes your
worksheet slow. That's when you want to array-enter the formula as a table
-- so everything in the table is retrieved with a single Internet access,
instead of each individual formula needing an Internet access.

On Mon, Sep 9, 2013 at 7:08 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> =smfPricesByDates(B2, TODAY()) where ticker symbol is in cell B2
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5 GetTableCell Question

Mon Sep 9, 2013 8:36 am (PDT) . Posted by:

petekoch

I attempted to extract the distribution breakdown for ETG using
the following URL with the Distributions tab:

http://www.cefconnect.com/Details/Summary.aspx?ticker=ETG

using the following formula:

=RCHGetTableCell("http://www.cefconnect.com/Details/Summary.aspx?\
ticker-"&Ticker,3,"Distribution History","Declared Date",,,,2)

What is returned is "Distribution Amount", the header for the
value I want. I don't find the amount values in the page source,
leading me to believe that the values are dynamically generated
and not available in the source, similar to what Morningstar did
with their financials a while back.

I be thinkin' I be screwed. Am I right ?