Kamis, 05 September 2013

[smf_addin] Digest Number 2759

7 New Messages

Digest #2759
1a
The only one? by "PeteA" option2z
1b
Re: The only one? by "rex" bios007a
1c
Re: The only one? by "Bey Melamed" BEYMELAMED
3a
Re: Gurufocus Model by hamishthedenizen
4b
Re: Error in RCHGetElementNumber 1421-1512 by "Randy Harmelink" rharmelink

Messages

Wed Sep 4, 2013 11:05 am (PDT) . Posted by:

"PeteA" option2z

Am I the only one who reads this forum every day.surely to learn more about
SMF.. But mostly to watch how a generous, consummate expert deals with a
barrage of sometimes simple; sometimes difficult questions.

Thanks Randy, you're an inspiration AND a fount of knowledge!

Pete A

Wed Sep 4, 2013 11:20 am (PDT) . Posted by:

"rex" bios007a

PeteA <optionzz@gmail.com> [2013-09-04 11:05]:
>
> Am I the only one who reads this forum every day…surely to learn more
> about SMF.. But mostly to watch how a generous, consummate expert deals
> with a barrage of sometimes simple; sometimes difficult questions.

Nope.

> Thanks Randy, you're an inspiration AND a fount of knowledge!

Yep. Randy is peerless. No one I've seen even comes close to the
level of support Randy provides.

But, I wish he'd give his blessing to a multiplatform solution,
LibreOffice, say.

-rex
--
"Never let a man who cannot be bothered with details fly the aircraft."
-rex

Wed Sep 4, 2013 1:15 pm (PDT) . Posted by:

"Bey Melamed" BEYMELAMED

I second that (except, I don't read all but am still amazed by Randy's dedication - and apologize for flooding your inbox with yet another message)
Bey

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of PeteA
Sent: Wednesday, September 04, 2013 2:05 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] The only one?

Am I the only one who reads this forum every day...surely to learn more about SMF.. But mostly to watch how a generous, consummate expert deals with a barrage of sometimes simple; sometimes difficult questions.

Thanks Randy, you're an inspiration AND a fount of knowledge!

Pete A

---------------------------------------------------------- CONFIDENTIALITY NOTICE: This communication is confidential, may be privileged and is meant only for the intended recipient. If you are not the intended recipient, you may not disclose, copy or use it. Please notify the sender ASAP and delete any copies from your system You should protect your system from viruses etc.; we accept no responsibility for damage that may be caused by them. ----------------------------------------------------------

Wed Sep 4, 2013 12:03 pm (PDT) . Posted by:

petekoch

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?




Wed Sep 4, 2013 1:47 pm (PDT) . Posted by:

hamishthedenizen


I put a fix into a new version of the sheet. Click on yellow cell
A6, and a dropdown menu lets you choose how many years of data
you'd like to see.



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

Thanks. After deleting years 2003 thru 2007 I had to change cell
C1 and C4 to 6 and it works great.

Wed Sep 4, 2013 8:30 pm (PDT) . Posted by:

cmertz36


I have been using the Old School Spreadsheet for over a year and
have always kept up to date with all the latest work in process
changes you have issued. It had been a few weeks since I last
used the spreadsheet and noticed that I know longer was getting
and data transfers loaded. I saw your post concerning
smf-elements-8.txt and went about making the change as I have
done before with other changes you have authored. I made sure
that EXCEL was not running when I went into the C:SMF folder to
install the new element file. I am using EXCEL-2003 and have not
had any problems before doing updates. Also if I click on
fulldisclosure.com, it takes me into reuters.com. Any advice
would be great.

Chuck


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

The earnings.com <http://earnings.com> website no longer exists.
It was moved to fulldisclosure.com <http://fulldisclosure.com> .
You can find the new element definition file in the "Works in
Progress" folder:

smf-elements-8.txt

You should replace that file in your add-in folder when EXCEL is
not up and running.

On Sun, Sep 1, 2013 at 8:32 PM, <jsmanzi13@...> wrote:

I have been trying to pull some dividend data for stocks however
I get an error message when I try to use the RCHGetElementNumber.
Any help would be appreciated. Thank you.

Wed Sep 4, 2013 9:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Interesting. And frustrating. When I go to:

http://fulldisclosure.com

...I am indeed redirected to reuters.com. However, if I use:

http://fulldisclosure.com/company.asp?client=cb&ticker=MMM

...I am not. That is the URL used by element #1421, which is working here.

You can always check to see the definition loaded for a particular element
with:

=smfGetAParms(1421)

...which for me currently returns:

Earnings;Dividends -- Amount -- 1;
http://fulldisclosure.com/company.asp?client=cb&ticker=~~~~~;2;>Upcoming;>Dividends<;;>Ex-Date;
;1;SPACER.GIF;0;0

But if element #1421 is not working for you with that definition, I'm not
sure what to tell you. If you use the full URL for MMM above, in your
browser, do you get to the desired page? Or are you redirected to
reuters.com?

On Wed, Sep 4, 2013 at 8:05 PM, <cmertz36@yahoo.com> wrote:

> I have been using the Old School Spreadsheet for over a year and have
> always kept up to date with all the latest work in process changes you have
> issued. It had been a few weeks since I last used the spreadsheet and
> noticed that I know longer was getting and data transfers loaded. I saw
> your post concerning smf-elements-8.txt and went about making the change as
> I have done before with other changes you have authored. I made sure that
> EXCEL was not running when I went into the C:SMF folder to install the new
> element file. I am using EXCEL-2003 and have not had any problems before
> doing updates. Also if I click on fulldisclosure.com, it takes me into
> reuters.com. Any advice would be great.
>
>

Tidak ada komentar:

Posting Komentar