15 New Messages
Digest #2754
Messages
Sun Sep 1, 2013 3:33 am (PDT) . Posted by:
"Gururaj Rao" gurujapan
On Sun, Sep 1, 2013 at 4:15 PM, <vins2k@yahoo.co.uk > wrote:
>
> Thanks Gururaj. Thats excellent.
>
> Do you know if we can extract PE data using the smf add-in from
> moneyworks4you?
>
>
> No, I'm sorry. I guess you'll have to ask Randy or some of the other
members familiar with the add-in. However, it would be better to look for a
site that offers extensive data not just P/E. Incidentally, I found a site
that gives 10 year data on Indian stocks today: http://www.way2wealth.com/
Maybe you can try to use the smf add-in for this site, and if you get
stuck, ask for assistance in this forum.
All the best,
Gururaj
>
> Thanks Gururaj. Thats excellent.
>
> Do you know if we can extract PE data using the smf add-in from
> moneyworks4you?
>
>
> No, I'm sorry. I guess you'll have to ask Randy or some of the other
members familiar with the add-in. However, it would be better to look for a
site that offers extensive data not just P/E. Incidentally, I found a site
that gives 10 year data on Indian stocks today: http://www.way2weal
Maybe you can try to use the smf add-in for this site, and if you get
stuck, ask for assistance in this forum.
All the best,
Gururaj
Sun Sep 1, 2013 5:37 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi all,
I am trying to utilize this file that Dan-carroll was so kind to upload, but it doesn't update the info when I change the ticker. It has put references to the xla file on the C: drive in the cells, even though I have my files setup in the same exact locations. What do I need to do to get this file working?
Thank you,
Jim
From: Yahoo Groups Updates [mailto:groupsupdates@yahoogroups.com ]
Sent: Sunday, September 01, 2013 8:04 AM
To: amt2100@gmail.com
Subject: Updates in Your Groups, September 1, 2013
<http://l.yimg.com/a/i/us/yg/em/up/2/logo_ybang.gif >
Updates in Your Groups
<http://groups.yahoo.com/group/smf_addin/?prop=eupdate > smf_addin-EXCEL Stock Market Functions Add-in
<http://l.yimg.com/a/i/us/yg/em/up/2/icon_file_v2.gif >
<http://profiles.yahoo.com/dan-carroll > dan-carroll posted a file "10 year model - GuruFocus.xlsx"; to the <http://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members?prop=eupdate > Uploads by forum members folder
<http://l.yimg.com/a/i/us/yg/logo/grp.gif >
To learn more about Yahoo!'s use of personal information, including the use of web beacons <http://info.yahoo.com/privacy/us/yahoo/webbeacons/details.html > in HTML-based email, please read our Privacy Policy <http://info.yahoo.com/privacy/us/yahoo/ > .
Visit Your Groups <http://groups.yahoo.com/mygroups > | Yahoo! Groups Terms of Use <http://docs.yahoo.com/info/terms/ > | Unsubscribe from the Updates Email <http://groups.yahoo.com/unsubscribe/updates/b6BOFX8fw12ldlD034vVMFVy_k1bsdSd > <http://geo.yahoo.com/b?s=1158100159&t=6084861 >
I am trying to utilize this file that Dan-carroll was so kind to upload, but it doesn't update the info when I change the ticker. It has put references to the xla file on the C: drive in the cells, even though I have my files setup in the same exact locations. What do I need to do to get this file working?
Thank you,
Jim
From: Yahoo Groups Updates [mailto:groupsupdates@
Sent: Sunday, September 01, 2013 8:04 AM
To: amt2100@gmail.
Subject: Updates in Your Groups, September 1, 2013
<http://l.yimg.
Updates in Your Groups
<http://groups.
<http://l.yimg.
<http://profiles.
<http://l.yimg.
To learn more about Yahoo!'s use of personal information, including the use of web beacons <http://info.
Visit Your Groups <http://groups.
Sun Sep 1, 2013 5:44 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. If your files were in the same location AND pointed at by the add-in
manager, the references should have been resolved automatically by EXCEL.
In any case, you can manually fix that. Either try running the smfFixLinks
macro from the add-in or check out the "Location Error" entry in the LINKS
area of the Yahoo group.
I should also mention that element #25 from MSN now returns the closing
price of the previous day. That's how MSN defined "Last Price" when they
updated the print page for stocks. Instead, I would use:
=RCHGetYahooQuotes(A1,"l1")
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@gmail.com > wrote:
> ****
> I am trying to utilize this file that Dan-carroll was so kind to upload,
> but it doesn't update the info when I change the ticker. It has put
> references to the xla file on the C: drive in the cells, even though I have
> my files setup in the same exact locations. What do I need to do to get
> this file working?
>
> ****
>
>
manager, the references should have been resolved automatically by EXCEL.
In any case, you can manually fix that. Either try running the smfFixLinks
macro from the add-in or check out the "Location Error" entry in the LINKS
area of the Yahoo group.
I should also mention that element #25 from MSN now returns the closing
price of the previous day. That's how MSN defined "Last Price" when they
updated the print page for stocks. Instead, I would use:
=RCHGetYahooQuotes(
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@gmail.
> ****
> I am trying to utilize this file that Dan-carroll was so kind to upload,
> but it doesn't update the info when I change the ticker. It has put
> references to the xla file on the C: drive in the cells, even though I have
> my files setup in the same exact locations. What do I need to do to get
> this file working?
>
> ****
>
>
Sun Sep 1, 2013 5:57 am (PDT) . Posted by:
dan-carroll
Randy, I updated the file accordingly. Happy to make any other
changes that people suggest.
--- In smf_addin@yahoogroups.com , <rharmelink@...> wrote:
Hmmm. If your files were in the same location AND pointed at by
the add-in manager, the references should have been resolved
automatically by EXCEL.
In any case, you can manually fix that. Either try running the
smfFixLinks macro from the add-in or check out the "Location
Error" entry in the LINKS area of the Yahoo group.
I should also mention that element #25 from MSN now returns the
closing price of the previous day. That's how MSN defined "Last
Price" when they updated the print page for stocks. Instead, I
would use:
=RCHGetYahooQuotes(A1,"l1")
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@...> wrote:
I am trying to utilize this file that Dan-carroll was so kind to
upload, but it doesn't update the info when I change the
ticker. It has put references to the xla file on the C: drive in
the cells, even though I have my files setup in the same exact
locations. What do I need to do to get this file working?
changes that people suggest.
--- In smf_addin@yahoogrou
Hmmm. If your files were in the same location AND pointed at by
the add-in manager, the references should have been resolved
automatically by EXCEL.
In any case, you can manually fix that. Either try running the
smfFixLinks macro from the add-in or check out the "Location
Error" entry in the LINKS area of the Yahoo group.
I should also mention that element #25 from MSN now returns the
closing price of the previous day. That's how MSN defined "Last
Price" when they updated the print page for stocks. Instead, I
would use:
=RCHGetYahooQuotes(
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@
I am trying to utilize this file that Dan-carroll was so kind to
upload, but it doesn't update the info when I change the
ticker. It has put references to the xla file on the C: drive in
the cells, even though I have my files setup in the same exact
locations. What do I need to do to get this file working?
Sun Sep 1, 2013 7:59 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Dan, I noticed a few areas that seems to be broke in my case.
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
2. Rows 87 – 96 are totally blank except a return "Error" =RCHGetElementNumber(Ticker,1)
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
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
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.
Just my thoughts, but I must admit I am not one who uses this information for making trades. So my opinions may not be of value to those that use this data.
VERY NICE JOB, I'm sure many user will find this very helpful.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of dan-carroll@yahoo.com
Sent: Sunday, September 01, 2013 8:58 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
Randy, I updated the file accordingly. Happy to make any other changes that people suggest.
--- In smf_addin@yahoogroups.com , <rharmelink@...> wrote:
Hmmm. If your files were in the same location AND pointed at by the add-in manager, the references should have been resolved automatically by EXCEL.
In any case, you can manually fix that. Either try running the smfFixLinks macro from the add-in or check out the "Location Error" entry in the LINKS area of the Yahoo group.
I should also mention that element #25 from MSN now returns the closing price of the previous day. That's how MSN defined "Last Price" when they updated the print page for stocks. Instead, I would use:
=RCHGetYahooQuotes(A1,"l1")
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@...> wrote:
I am trying to utilize this file that Dan-carroll was so kind to upload, but it doesn't update the info when I change the ticker. It has put references to the xla file on the C: drive in the cells, even though I have my files setup in the same exact locations. What do I need to do to get this file working?
1. Cells O2 – S2 return "Error" =RCHGetTableCell(
2. Rows 87 – 96 are totally blank except a return "Error" =RCHGetElementNumbe
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
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
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.
Just my thoughts, but I must admit I am not one who uses this information for making trades. So my opinions may not be of value to those that use this data.
VERY NICE JOB, I'm sure many user will find this very helpful.
Kermit
From: smf_addin@yahoogrou
Sent: Sunday, September 01, 2013 8:58 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
Randy, I updated the file accordingly. Happy to make any other changes that people suggest.
--- In smf_addin@yahoogrou
Hmmm. If your files were in the same location AND pointed at by the add-in manager, the references should have been resolved automatically by EXCEL.
In any case, you can manually fix that. Either try running the smfFixLinks macro from the add-in or check out the "Location Error" entry in the LINKS area of the Yahoo group.
I should also mention that element #25 from MSN now returns the closing price of the previous day. That's how MSN defined "Last Price" when they updated the print page for stocks. Instead, I would use:
=RCHGetYahooQuotes(
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@
I am trying to utilize this file that Dan-carroll was so kind to upload, but it doesn't update the info when I change the ticker. It has put references to the xla file on the C: drive in the cells, even though I have my files setup in the same exact locations. What do I need to do to get this file working?
Sun Sep 1, 2013 8:10 am (PDT) . Posted by:
"Jim Ranum" amt2100
Unfortunately, I am getting the same error I posted about earlier, before Dan did an update.
It is still giving showing it's pointing to the c: drive vs. the Internet site. I haven't gotten a chance to search and try the remedies Randy mentioned yet.
I'm only posting to say the update didn't seem to do anything.
Best,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Kermit W. Prather
Sent: Sunday, September 01, 2013 11:00 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
Dan, I noticed a few areas that seems to be broke in my case.
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
2. Rows 87 – 96 are totally blank except a return "Error" =RCHGetElementNumber(Ticker,1)
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
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
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.
Just my thoughts, but I must admit I am not one who uses this information for making trades. So my opinions may not be of value to those that use this data.
VERY NICE JOB, I'm sure many user will find this very helpful.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of dan-carroll@yahoo.com
Sent: Sunday, September 01, 2013 8:58 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
Randy, I updated the file accordingly. Happy to make any other changes that people suggest.
--- In smf_addin@yahoogroups.com , <rharmelink@...> wrote:
Hmmm. If your files were in the same location AND pointed at by the add-in manager, the references should have been resolved automatically by EXCEL.
In any case, you can manually fix that. Either try running the smfFixLinks macro from the add-in or check out the "Location Error" entry in the LINKS area of the Yahoo group.
I should also mention that element #25 from MSN now returns the closing price of the previous day. That's how MSN defined "Last Price" when they updated the print page for stocks. Instead, I would use:
=RCHGetYahooQuotes(A1,"l1")
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@...> wrote:
I am trying to utilize this file that Dan-carroll was so kind to upload, but it doesn't update the info when I change the ticker. It has put references to the xla file on the C: drive in the cells, even though I have my files setup in the same exact locations. What do I need to do to get this file working?
It is still giving showing it's pointing to the c: drive vs. the Internet site. I haven't gotten a chance to search and try the remedies Randy mentioned yet.
I'm only posting to say the update didn't seem to do anything.
Best,
Jim
From: smf_addin@yahoogrou
Sent: Sunday, September 01, 2013 11:00 AM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
Dan, I noticed a few areas that seems to be broke in my case.
1. Cells O2 – S2 return "Error" =RCHGetTableCell(
2. Rows 87 – 96 are totally blank except a return "Error" =RCHGetElementNumbe
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
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
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.
Just my thoughts, but I must admit I am not one who uses this information for making trades. So my opinions may not be of value to those that use this data.
VERY NICE JOB, I'm sure many user will find this very helpful.
Kermit
From: smf_addin@yahoogrou
Sent: Sunday, September 01, 2013 8:58 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
Randy, I updated the file accordingly. Happy to make any other changes that people suggest.
--- In smf_addin@yahoogrou
Hmmm. If your files were in the same location AND pointed at by the add-in manager, the references should have been resolved automatically by EXCEL.
In any case, you can manually fix that. Either try running the smfFixLinks macro from the add-in or check out the "Location Error" entry in the LINKS area of the Yahoo group.
I should also mention that element #25 from MSN now returns the closing price of the previous day. That's how MSN defined "Last Price" when they updated the print page for stocks. Instead, I would use:
=RCHGetYahooQuotes(
On Sun, Sep 1, 2013 at 5:37 AM, Jim Ranum <amt2100@
I am trying to utilize this file that Dan-carroll was so kind to upload, but it doesn't update the info when I change the ticker. It has put references to the xla file on the C: drive in the cells, even though I have my files setup in the same exact locations. What do I need to do to get this file working?
Sun Sep 1, 2013 8:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The file opened fine for me. Two issues I noted:
1. Cell C135 has a #REF error...
2. 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.
On Sun, Sep 1, 2013 at 5:57 AM, <dan-carroll@yahoo.com > wrote:
>
> Randy, I updated the file accordingly. Happy to make any other changes
> that people suggest.
>
1. Cell C135 has a #REF error...
2. For me, rows 138 and 139 show up as "######
too wide for the columns. You can probably drop everything to the right of
the decimal point.
On Sun, Sep 1, 2013 at 5:57 AM, <dan-carroll@
>
> Randy, I updated the file accordingly. Happy to make any other changes
> that people suggest.
>
Sun Sep 1, 2013 8:56 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
I did the "replace all" as recommended in the Links section. The cells are still not updating when I enter a new ticker in the top left of the spreadsheet. The cells all look normal, but still have the data for MSFT.
I have no idea what is wrong. I have noticed another issue that wondered if it was normal. When I constructed my other spreadsheet extracting data from gurufocus, with about 20—30 tickers and about 6 data requests, the spreadsheet goes grey initially for several seconds, gives me "not responding" for several seconds and after about around a full minute to 90 seconds, the data comes up. Of course if I have more tickers, it's slower still.
Is that normal? If not, what would cause this and could this issue be related to the fact that Dan's file is not working on my computer?
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, September 01, 2013 11:34 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
The file opened fine for me. Two issues I noted:
1. Cell C135 has a #REF error...
2. 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.
On Sun, Sep 1, 2013 at 5:57 AM, <dan-carroll@yahoo.com > wrote:
Randy, I updated the file accordingly. Happy to make any other changes that people suggest.
I did the "replace all" as recommended in the Links section. The cells are still not updating when I enter a new ticker in the top left of the spreadsheet. The cells all look normal, but still have the data for MSFT.
I have no idea what is wrong. I have noticed another issue that wondered if it was normal. When I constructed my other spreadsheet extracting data from gurufocus, with about 20—30 tickers and about 6 data requests, the spreadsheet goes grey initially for several seconds, gives me "not responding" for several seconds and after about around a full minute to 90 seconds, the data comes up. Of course if I have more tickers, it's slower still.
Is that normal? If not, what would cause this and could this issue be related to the fact that Dan's file is not working on my computer?
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Sunday, September 01, 2013 11:34 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
The file opened fine for me. Two issues I noted:
1. Cell C135 has a #REF error...
2. For me, rows 138 and 139 show up as "######
On Sun, Sep 1, 2013 at 5:57 AM, <dan-carroll@
Randy, I updated the file accordingly. Happy to make any other changes that people suggest.
Sun Sep 1, 2013 9:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Sun, Sep 1, 2013 at 8:55 AM, Jim Ranum <amt2100@gmail.com > wrote:
>
>
> I did the "replace all" as recommended in the Links section. The cells are
> still not updating when I enter a new ticker in the top left of the
> spreadsheet. The cells all look normal, but still have the data for MSFT.
>
I have no explanation for that behavior.
****
>
> I have no idea what is wrong. I have noticed another issue that wondered
> if it was normal. When I constructed my other spreadsheet extracting data
> from gurufocus, with about 20—30 tickers and about 6 data requests, the
> spreadsheet goes grey initially for several seconds, gives me "not
> responding" for several seconds and after about around a full minute to 90
> seconds, the data comes up. Of course if I have more tickers, it's slower
> still.
>
> Is that normal? If not, what would cause this and could this issue be
> related to the fact that Dan's file is not working on my computer?
>
I just tried getting data items for the 30 DJIA stocks. Yes, the GuruFocus
website is VERY slow. Took several minutes, actually.
I tried it again with smfUpdateDownloadTable so I could time each request
individually. Most took under a second, but some took as long as 20 seconds.
>
>
> I did the "replace all" as recommended in the Links section. The cells are
> still not updating when I enter a new ticker in the top left of the
> spreadsheet. The cells all look normal, but still have the data for MSFT.
>
I have no explanation for that behavior.
****
>
> I have no idea what is wrong. I have noticed another issue that wondered
> if it was normal. When I constructed my other spreadsheet extracting data
> from gurufocus, with about 20—30 tickers and about 6 data requests, the
> spreadsheet goes grey initially for several seconds, gives me "not
> responding" for several seconds and after about around a full minute to 90
> seconds, the data comes up. Of course if I have more tickers, it's slower
> still.
>
> Is that normal? If not, what would cause this and could this issue be
> related to the fact that Dan's file is not working on my computer?
>
I just tried getting data items for the 30 DJIA stocks. Yes, the GuruFocus
website is VERY slow. Took several minutes, actually.
I tried it again with smfUpdateDownloadTa
individually. Most took under a second, but some took as long as 20 seconds.
Sun Sep 1, 2013 10:30 am (PDT) . Posted by:
dan-carroll
Jim, Kermit & Randy.
Jim, I can't help you with those issues unfortunately. Randy is
literally years ahead of any advice I could offer.
Kermit & Randy, I fixed the issues you described, see my answers
on the new Topic that I just started. No doubt there are plenty
of other bugs. I have only just built the model and tend to
discover issues when I try it on different stocks. Part of the
issue is that GuruFocus doesn't build in "zeroes" for standard
items if they are not in the reported data - they just delete the
line altogether.
Kermit - what ticker were you using - it would help me to
replicate the issues you were having, and I'll see if I can fix
them.
I hope to have this thing more or less settled in within a week
or two, so I've started another message thread to help collect
the bugs and fixes and update the sheet accordingly.
--- In smf_addin@yahoogroups.com , <rharmelink@...> wrote:
On Sun, Sep 1, 2013 at 8:55 AM, Jim Ranum <amt2100@...> wrote:
I did the "replace all" as recommended in the Links
section. The cells are still not updating when I enter a new
ticker in the top left of the spreadsheet. The cells all look
normal, but still have the data for MSFT.
I have no explanation for that behavior.
I have no idea what is wrong. I have noticed another issue that
wondered if it was normal. When I constructed my other
spreadsheet extracting data from gurufocus, with about
20—30 tickers and about 6 data requests, the spreadsheet
goes grey initially for several seconds, gives me "not
responding" for several seconds and after about around a
full minute to 90 seconds, the data comes up. Of course if I have
more tickers, it's slower still.
Is that normal? If not, what would cause this and could this
issue be related to the fact that Dan's file is not
working on my computer?
I just tried getting data items for the 30 DJIA stocks. Yes, the
GuruFocus website is VERY slow. Took several minutes, actually.
I tried it again with smfUpdateDownloadTable so I could time each
request individually. Most took under a second, but some took as
long as 20 seconds.
Jim, I can't help you with those issues unfortunately. Randy is
literally years ahead of any advice I could offer.
Kermit & Randy, I fixed the issues you described, see my answers
on the new Topic that I just started. No doubt there are plenty
of other bugs. I have only just built the model and tend to
discover issues when I try it on different stocks. Part of the
issue is that GuruFocus doesn't build in "zeroes" for standard
items if they are not in the reported data - they just delete the
line altogether.
Kermit - what ticker were you using - it would help me to
replicate the issues you were having, and I'll see if I can fix
them.
I hope to have this thing more or less settled in within a week
or two, so I've started another message thread to help collect
the bugs and fixes and update the sheet accordingly.
--- In smf_addin@yahoogrou
On Sun, Sep 1, 2013 at 8:55 AM, Jim Ranum <amt2100@
I did the "replace all" as recommended in the Links
section. The cells are still not updating when I enter a new
ticker in the top left of the spreadsheet. The cells all look
normal, but still have the data for MSFT.
I have no explanation for that behavior.
I have no idea what is wrong. I have noticed another issue that
wondered if it was normal. When I constructed my other
spreadsheet extracting data from gurufocus, with about
20—30 tickers and about 6 data requests, the spreadsheet
goes grey initially for several seconds, gives me "not
responding" for several seconds and after about around a
full minute to 90 seconds, the data comes up. Of course if I have
more tickers, it's slower still.
Is that normal? If not, what would cause this and could this
issue be related to the fact that Dan's file is not
working on my computer?
I just tried getting data items for the 30 DJIA stocks. Yes, the
GuruFocus website is VERY slow. Took several minutes, actually.
I tried it again with smfUpdateDownloadTa
request individually. Most took under a second, but some took as
long as 20 seconds.
Sun Sep 1, 2013 11:01 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi again,
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?
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, September 01, 2013 12:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
On Sun, Sep 1, 2013 at 8:55 AM, Jim Ranum <amt2100@gmail.com > wrote:
I did the "replace all" as recommended in the Links section. The cells are still not updating when I enter a new ticker in the top left of the spreadsheet. The cells all look normal, but still have the data for MSFT.
I have no explanation for that behavior.
I have no idea what is wrong. I have noticed another issue that wondered if it was normal. When I constructed my other spreadsheet extracting data from gurufocus, with about 20—30 tickers and about 6 data requests, the spreadsheet goes grey initially for several seconds, gives me "not responding" for several seconds and after about around a full minute to 90 seconds, the data comes up. Of course if I have more tickers, it's slower still.
Is that normal? If not, what would cause this and could this issue be related to the fact that Dan's file is not working on my computer?
I just tried getting data items for the 30 DJIA stocks. Yes, the GuruFocus website is VERY slow. Took several minutes, actually.
I tried it again with smfUpdateDownloadTable so I could time each request individually. Most took under a second, but some took as long as 20 seconds.
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/
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_
Do I?
What is the deal with this?
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Sunday, September 01, 2013 12:32 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] RE: FW: Updates in Your Groups, September 1, 2013
On Sun, Sep 1, 2013 at 8:55 AM, Jim Ranum <amt2100@gmail.
I did the "replace all" as recommended in the Links section. The cells are still not updating when I enter a new ticker in the top left of the spreadsheet. The cells all look normal, but still have the data for MSFT.
I have no explanation for that behavior.
I have no idea what is wrong. I have noticed another issue that wondered if it was normal. When I constructed my other spreadsheet extracting data from gurufocus, with about 20—30 tickers and about 6 data requests, the spreadsheet goes grey initially for several seconds, gives me "not responding" for several seconds and after about around a full minute to 90 seconds, the data comes up. Of course if I have more tickers, it's slower still.
Is that normal? If not, what would cause this and could this issue be related to the fact that Dan's file is not working on my computer?
I just tried getting data items for the 30 DJIA stocks. Yes, the GuruFocus website is VERY slow. Took several minutes, actually.
I tried it again with smfUpdateDownloadTa
Sun Sep 1, 2013 10:22 am (PDT) . Posted by:
dan-carroll
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"
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&quo
"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(
Issues addressed this iteration (v3):
Kermit:
1. Cells O2 – S2 return "Error"
=RCHGetTableCell(
<http://www.gurufocu
share",
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" =RCHGetElementNumbe
· 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 "######
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 4:34 pm (PDT) . Posted by:
dan-carroll
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@yahoogrou
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"
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&quo
"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(
Issues addressed this iteration (v3):
Kermit:
1. Cells O2 – S2 return "Error"
=RCHGetTableCell(
<http://www.gurufocu
share",
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" =RCHGetElementNumbe
· 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 "######
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 1:11 pm (PDT) . Posted by:
"yjeffs1" yjeffs1
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?
Could it be older SMF functions versions?
Any instructions how to work it?
Sun Sep 1, 2013 4:31 pm (PDT) . Posted by:
nadstradamus1982
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?
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?
Tidak ada komentar:
Posting Komentar