Senin, 02 September 2013

[smf_addin] Digest Number 2755

10 New Messages

Digest #2755

Messages

Sun Sep 1, 2013 4:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

As I understand it, add-ins are loaded when EXCEL starts up, and at that
time it copies the add-in to the Roaming directory. So that's NOT the one
you want to point to. I'm not sure of the details though.

On Sun, Sep 1, 2013 at 11:01 AM, Jim Ranum <amt2100@gmail.com> wrote:

>
>
> OK, I am perplexed by this. I just went to check on the Add-Ins and the
> SMF addin is in a different location than when I set it up.****
>
> ** **
>
> ****
>
> ** **
>
> Why/how would it move from the c:/program files/smf add-in/ folder to the
> AppData/Roaming/Microsoft/AddIns folder?****
>
> ** **
>
> And when I tried to point Excel back to the program files folder, it says
> "A file named c:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla
> already exists in this location. Do you want to replace it?"****
>
> ** **
>
> Do I?****
>
> What is the deal with this?****
>
>
>

Sun Sep 1, 2013 5:08 pm (PDT) . Posted by:

"Jim Ranum" amt2100

I'm sorry to be a pain on this, but how do I get it to point back to the Program Files location? I don't see how to do it. When I try to change it, it acts like it's already pointing there, but it's not.

Thanks,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Sunday, September 01, 2013 7:37 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013

As I understand it, add-ins are loaded when EXCEL starts up, and at that time it copies the add-in to the Roaming directory. So that's NOT the one you want to point to. I'm not sure of the details though.

On Sun, Sep 1, 2013 at 11:01 AM, Jim Ranum <amt2100@gmail.com> wrote:

OK, I am perplexed by this. I just went to check on the Add-Ins and the SMF addin is in a different location than when I set it up.

Why/how would it move from the c:/program files/smf add-in/ folder to the AppData/Roaming/Microsoft/AddIns folder?

And when I tried to point Excel back to the program files folder, it says "A file named c:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla already exists in this location. Do you want to replace it?"

Do I?

What is the deal with this?

Sun Sep 1, 2013 7:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Best way to reset:

1. Go to add-in manager and uncheck the add-in
2. Exit EXCEL
3. Restart EXCEL
4. Go to add-in manager and re-add the add-in
5. Exit EXCEL
6. Restart EXCEL

(5) and (6) are usually unnecessary, but I prefer to have it save the
correct settings before I start doing other things. (1) and (2) undo the
add-in and remove any pointers that might exist -- some, in the past, seem
to have had registry entries for it, and this appears to remove them.

On Sun, Sep 1, 2013 at 5:08 PM, Jim Ranum <amt2100@gmail.com> wrote:

>
> I'm sorry to be a pain on this, but how do I get it to point back to the
> Program Files location? I don't see how to do it. When I try to change it,
> it acts like it's already pointing there, but it's not.
>

Sun Sep 1, 2013 7:48 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Thanks Randy.

That's what I ended up doing and got it working.

I really appreciate this tool you've provided and especially supporting it the way you do!

Take care,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Sunday, September 01, 2013 10:38 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013

Best way to reset:

1. Go to add-in manager and uncheck the add-in
2. Exit EXCEL
3. Restart EXCEL
4. Go to add-in manager and re-add the add-in
5. Exit EXCEL
6. Restart EXCEL

(5) and (6) are usually unnecessary, but I prefer to have it save the correct settings before I start doing other things. (1) and (2) undo the add-in and remove any pointers that might exist -- some, in the past, seem to have had registry entries for it, and this appears to remove them.

On Sun, Sep 1, 2013 at 5:08 PM, Jim Ranum <amt2100@gmail.com> wrote:

I'm sorry to be a pain on this, but how do I get it to point back to the Program Files location? I don't see how to do it. When I try to change it, it acts like it's already pointing there, but it's not.

Sun Sep 1, 2013 4:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

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@gmail.com> 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?
>

Sun Sep 1, 2013 4:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

With the lack of detail you've provided, all I can say is to use the URL
for the next page of headlines. It should have a similar extraction process.

On Sun, Sep 1, 2013 at 10:21 AM, <nadstradamus1982@yahoo.com> wrote:

>
> I am trying to import headlines (with links) into excel. I have a process
> that gets me the most recent 20 headlines. What i am looking to do is
> import the next 20 headlines with the ability to keep hitting next for an
> additional 20. Any thoughts on this?
>

Sun Sep 1, 2013 6:20 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Hi Dan,

I finally got the bugs worked out with my "location" problems. Thanks for this file. I looks like you've learned a lot about using the add-in instructions.

A great spreadsheet.

Thanks again,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of dan-carroll@yahoo.com
Sent: Sunday, September 01, 2013 7:34 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RE: Fixes to 10 year model - GuruFocus

Version 4 is up.

I changed the dates at the top so that you have a numeric date there now instead of a text string.

Data that is pulled from GuruFocus is taken over with an ISNUMBER check to clean up the sheet.

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

This string is to isolate fixes needed on the 10 year GuruFocus-based model. I will flag that I am nowhere near in the league of Randy & co, so if VB skills are needed, I'm out. This is just my best effort at producing something to replace the 10 year ADVfn model by Mr. McGinnis, which was so helpful to me.

Formatting changes I can do, but I'd rather prioritize bugs and errors.

I'd also welcome anyone else having a go at building on this. Just please attach a version number and flag the changes on this thread.

One last note: though Gurufocus does standardize the data, not all fields occur for each stock. If the sheet attempts to pull data that isn't there, you will get "Error". In some cases where I've gotten this I've modified the rows to put zeroes if "Error" is returned, but I haven't done it for the whole sheet (too lazy I guess :-)) The data for "Inventory&quot; and "Days Inventory" and "Inventory Turnover" were examples. See the light green blocked data on rows 117/118 of v3 for an example.

I have just uploaded Version 3 of the sheet

Changes made in previous iteration:

· Stock Price in A4 – changed to =RCHGetYahooQuotes(Ticker,"l1"), per Randy's Suggestion

Issues addressed this iteration (v3):

Kermit:

1. Cells O2 – S2 return "Error" =RCHGetTableCell("http://www.gurufocus.com/financials/"&$A$1,O$3,"except for per share",">"&$B2) in my copy A1 thru b3 is a merged cell defined as Ticker

· I went back and did a global change of $A$1 to Ticker. That was an oversight on my part, for which I apologize. I'm not used to producing sheets for others to use, so I tend to skimp on the cleanup and user-friendliness.

· Which ticker are you using? The sheet had some problems with companies that have a short history, which I hoped I had fixed, but maybe not. Let me know the ticker and I'll see what I error I get and try to come up with a fix.

2. Rows 87 – 96 are totally blank except a return "Error" =RCHGetElementNumber(Ticker,1)

· That block should return the "company description" from MSN. It does for some tickers, not for others. You can delete it if you want.

3. Row "N" has no heading, but I noticed starting in Cell N130 thru N136 they are Averages I would enter AVG in Cell N129

· Done. Also put the label in Row 5. The column is mostly there to separate annual from quarterly numbers, but for valuation I thought I'd throw in some averages

4. I was a little confused as to what rows 123 thru 128 were the growth rate of. Seems to me those rows should be right after row 24

· On location, I prefer to get the three financial statements in first. Feel free to move the rows around as you prefer. If a lot of people would prefer that format, let me know and I'll do it.

· As to what they are the growth rates of, I thought the rows were labeled clearly. They are Y/Y growth rates for Revenues, EBITDA, etc. Let me know if the labeling is confusing.

5. I noticed a later email that you had made a change. I downloaded at 9:55am U.S. EST so I may not have latest level. So might I suggest that you include a version level maybe in cell C4.

· The only change in that version was to the price in A4, as noted above.

Randy:

Cell C135 has a #REF error...

· Fixed – my bad.

For me, rows 138 and 139 show up as "######" because the format is too wide for the columns. You can probably drop everything to the right of the decimal point.

· Done. I tend to look at smaller cap stocks, so I left a single decimal place for the income, balance sheet and CF statements.

Other Changes:

I went ahead and moved some of the data from below the 3 major statements around – moved margins and growth to just below description block, as I think those are higher priority. I also moved some of the balance sheet measures to the balance sheet block from "Misc" and Capital Efficiency. Also renamed "Capital Efficiency" to "Returns"

As noted at the top, I also modified certain rows where the data is not always there, to replace "Error" messages with zeroes - "Treasury Stock" is an example.

Mon Sep 2, 2013 12:35 am (PDT) . Posted by:

jmk1957


Hi Dan, All the Field descriptions, are Hyperlinked to MMM, If
you want to remove the hyper links.

1. Enter 1 into a blank cell,

2. Copy the cell Cntrl-C

3. Highlight all the field Descriptions.

4. Select Edit Special

5. Select the Multiply option and then past.



Thanks for the Sheet


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


Hi Dan,



I finally got the bugs worked out with my
"location" problems. Thanks for this file. I looks
like you've learned a lot about using the add-in
instructions.

A great spreadsheet.



Thanks again,

Jim





From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com] On Behalf Of dan-carroll@...
Sent: Sunday, September 01, 2013 7:34 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RE: Fixes to 10 year model - GuruFocus





Version 4 is up.

I changed the dates at the top so that you have a numeric date
there now instead of a text string.

Data that is pulled from GuruFocus is taken over with an ISNUMBER
check to clean up the sheet.



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

This string is to isolate fixes needed on the 10 year
GuruFocus-based model. I will flag that I am nowhere near in the
league of Randy & co, so if VB skills are needed, I'm out. This
is just my best effort at producing something to replace the 10
year ADVfn model by Mr. McGinnis, which was so helpful to me.



Formatting changes I can do, but I'd rather prioritize bugs and
errors.



I'd also welcome anyone else having a go at building on this.
Just please attach a version number and flag the changes on this
thread.



One last note: though Gurufocus does standardize the data, not
all fields occur for each stock. If the sheet attempts to pull
data that isn't there, you will get "Error". In some cases where
I've gotten this I've modified the rows to put zeroes if "Error"
is returned, but I haven't done it for the whole sheet (too lazy
I guess :-)) The data for "Inventory&quot; and "Days Inventory" and
"Inventory Turnover" were examples. See the light green blocked
data on rows 117/118 of v3 for an example.



I have just uploaded Version 3 of the sheet



Changes made in previous iteration:

· Stock Price in A4 – changed to
=RCHGetYahooQuotes(Ticker,"l1"), per Randy's Suggestion

Issues addressed this iteration (v3):

Kermit:

1. Cells O2 – S2 return "Error"
=RCHGetTableCell("http://www.gurufocus.com/financials/
<http://www.gurufocus.com/financials/> "&$A$1,O$3,"except for per
share",">"&$B2) in my copy A1 thru b3 is a merged cell defined
as Ticker

· I went back and did a global change of $A$1 to
Ticker. That was an oversight on my part, for which I apologize.
I'm not used to producing sheets for others to use, so I
tend to skimp on the cleanup and user-friendliness.

· Which ticker are you using? The sheet had some
problems with companies that have a short history, which I hoped
I had fixed, but maybe not. Let me know the ticker and
I'll see what I error I get and try to come up with a fix.

2. Rows 87 – 96 are totally blank except a return
"Error" =RCHGetElementNumber(Ticker,1)

· That block should return the "company
description" from MSN. It does for some tickers, not for
others. You can delete it if you want.

3. Row "N" has no heading, but I noticed
starting in Cell N130 thru N136 they are Averages I would enter
AVG in Cell N129

· Done. Also put the label in Row 5. The column is
mostly there to separate annual from quarterly numbers, but for
valuation I thought I'd throw in some averages

4. I was a little confused as to what rows 123 thru 128 were
the growth rate of. Seems to me those rows should be right after
row 24

· On location, I prefer to get the three financial
statements in first. Feel free to move the rows around as you
prefer. If a lot of people would prefer that format, let me know
and I'll do it.

· As to what they are the growth rates of, I thought
the rows were labeled clearly. They are Y/Y growth rates for
Revenues, EBITDA, etc. Let me know if the labeling is confusing.

5. I noticed a later email that you had made a change. I
downloaded at 9:55am U.S. EST so I may not have latest level. So
might I suggest that you include a version level maybe in cell
C4.

· The only change in that version was to the price in
A4, as noted above.



Randy:

Cell C135 has a #REF error...



· Fixed – my bad.

For me, rows 138 and 139 show up as "######" because the format
is too wide for the columns. You can probably drop everything to
the right of the decimal point.

· Done. I tend to look at smaller cap stocks, so I
left a single decimal place for the income, balance sheet and CF
statements.

Other Changes:

I went ahead and moved some of the data from below the 3 major
statements around – moved margins and growth to just below
description block, as I think those are higher priority. I also
moved some of the balance sheet measures to the balance sheet
block from "Misc" and Capital Efficiency. Also
renamed "Capital Efficiency" to
"Returns"

As noted at the top, I also modified certain rows where the data
is not always there, to replace "Error" messages with zeroes -
"Treasury Stock" is an example.


Sun Sep 1, 2013 8:32 pm (PDT) . Posted by:

jsmanzi13

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.

Sun Sep 1, 2013 8:39 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The earnings.com website no longer exists. It was moved to
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@gmail.com> 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.
>
Diposting oleh EXCEL FEED LEARNING di 00.49

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)