15 New Messages
Digest #2816
Messages
Fri Oct 18, 2013 3:24 am (PDT) . Posted by:
puuteknikko
Those cells still show the errors :( Funny thing is that cells G23, G25 and G29 do not have this issue.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Those cells all contain information coming from AdvFN. You'll get errors on those unless you are using the new beta version of the add-in from the "Works in Progress" folder from the FILES area of the group. That's because AdvFN is messing around with the their URL structure.
On Thu, Oct 17, 2013 at 5:39 AM, <boulder08@... mailto:boulder08@...> wrote:
I'm trying to use the spreadsheet but for some reason, cells G24, G26-28, G30-31 and K5 only show "Error". The cell K14 (and K24 as a result) shows "#VALUE!", but is that due to a different decimal separator?
---In smf_addin@yahoogrou
Those cells all contain information coming from AdvFN. You'll get errors on those unless you are using the new beta version of the add-in from the "Works in Progress" folder from the FILES area of the group. That's because AdvFN is messing around with the their URL structure.
On Thu, Oct 17, 2013 at 5:39 AM, <boulder08@
I'm trying to use the spreadsheet but for some reason, cells G24, G26-28, G30-31 and K5 only show "Error"
Fri Oct 18, 2013 3:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Is it possible you're attempting it on a financial services company? They
have different line items and these factors don't apply.
I'm getting data for NTE, the ticker that is there to start with. And for
MMM, when I change it. But if I try WFC, I get all kinds of cells with
#N/A, "Error", and #VALUE!. But I do get values in cells G23, G25, G27, and
G29.
On Fri, Oct 18, 2013 at 3:24 AM, <boulder08@gmail.com> wrote:
> Those cells still show the errors :( Funny thing is that cells G23, G25
> and G29 do not have this issue.
> ---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
>
> Those cells all contain information coming from AdvFN. You'll get errors
> on those unless you are using the new beta version of the add-in from the
> "Works in Progress" folder from the FILES area of the group. That's because
> AdvFN is messing around with the their URL structure.
>
> On Thu, Oct 17, 2013 at 5:39 AM, <boulder08@...> wrote:
>
> I'm trying to use the spreadsheet but for some reason, cells G24,
> G26-28, G30-31 and K5 only show "Error". The cell K14 (and K24 as a result)
> shows "#VALUE!", but is that due to a different decimal separator?
>
>
have different line items and these factors don't apply.
I'm getting data for NTE, the ticker that is there to start with. And for
MMM, when I change it. But if I try WFC, I get all kinds of cells with
#N/A, "Error"
G29.
On Fri, Oct 18, 2013 at 3:24 AM, <boulder08@gmail.
> Those cells still show the errors :( Funny thing is that cells G23, G25
> and G29 do not have this issue.
> ---In smf_addin@yahoogrou
>
> Those cells all contain information coming from AdvFN. You'll get errors
> on those unless you are using the new beta version of the add-in from the
> "Works in Progress" folder from the FILES area of the group. That's because
> AdvFN is messing around with the their URL structure.
>
> On Thu, Oct 17, 2013 at 5:39 AM, <boulder08@
>
> I'm trying to use the spreadsheet but for some reason, cells G24,
> G26-28, G30-31 and K5 only show "Error"
> shows "#VALUE!
>
>
Fri Oct 18, 2013 4:15 am (PDT) . Posted by:
puuteknikko
I've tested it on MSFT so it should work.
What comes to the problem in cell K14, it seems that there value that is divided by 1000 is not a number according to Excel. For example with MSFT it's 290.88B :/
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Is it possible you're attempting it on a financial services company? They have different line items and these factors don't apply.
I'm getting data for NTE, the ticker that is there to start with. And for MMM, when I change it. But if I try WFC, I get all kinds of cells with #N/A, "Error", and #VALUE!. But I do get values in cells G23, G25, G27, and G29.
On Fri, Oct 18, 2013 at 3:24 AM, <boulder08@... mailto:boulder08@...> wrote:
Those cells still show the errors :( Funny thing is that cells G23, G25 and G29 do not have this issue.
---In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Those cells all contain information coming from AdvFN. You'll get errors on those unless you are using the new beta version of the add-in from the "Works in Progress" folder from the FILES area of the group. That's because AdvFN is messing around with the their URL structure.
On Thu, Oct 17, 2013 at 5:39 AM, <boulder08@... mailto:boulder08@...> wrote:
I'm trying to use the spreadsheet but for some reason, cells G24, G26-28, G30-31 and K5 only show "Error". The cell K14 (and K24 as a result) shows "#VALUE!", but is that due to a different decimal separator?
What comes to the problem in cell K14, it seems that there value that is divided by 1000 is not a number according to Excel. For example with MSFT it's 290.88B :/
---In smf_addin@yahoogrou
Is it possible you're attempting it on a financial services company? They have different line items and these factors don't apply.
I'm getting data for NTE, the ticker that is there to start with. And for MMM, when I change it. But if I try WFC, I get all kinds of cells with #N/A, "Error"
On Fri, Oct 18, 2013 at 3:24 AM, <boulder08@
Those cells still show the errors :( Funny thing is that cells G23, G25 and G29 do not have this issue.
---In smf_addin@yahoogrou
Those cells all contain information coming from AdvFN. You'll get errors on those unless you are using the new beta version of the add-in from the "Works in Progress" folder from the FILES area of the group. That's because AdvFN is messing around with the their URL structure.
On Thu, Oct 17, 2013 at 5:39 AM, <boulder08@
I'm trying to use the spreadsheet but for some reason, cells G24, G26-28, G30-31 and K5 only show "Error"
Fri Oct 18, 2013 4:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
MSFT works fine here...
You mentioned the decimal separator. If you don't use U.S. Regional
settings, VBA won't work right...which is probably why you're getting the
290.88B returned for the calculation in cell K14.
On Fri, Oct 18, 2013 at 4:15 AM, <boulder08@gmail.com> wrote:
> I've tested it on MSFT so it should work.
>
> What comes to the problem in cell K14, it seems that there value that is
> divided by 1000 is not a number according to Excel. For example with MSFT
> it's 290.88B :/
>
You mentioned the decimal separator. If you don't use U.S. Regional
settings, VBA won't work right...which is probably why you're getting the
290.88B returned for the calculation in cell K14.
On Fri, Oct 18, 2013 at 4:15 AM, <boulder08@gmail.
> I've tested it on MSFT so it should work.
>
> What comes to the problem in cell K14, it seems that there value that is
> divided by 1000 is not a number according to Excel. For example with MSFT
> it's 290.88B :/
>
Fri Oct 18, 2013 5:45 am (PDT) . Posted by:
petekoch
In my original version of Altman-Piotroski, I used Cells G23-31 as a check to verify the other calculations and they almost always matched. Randy is correct: they use AdvFN elements and most do not work. A few still do, i.e., 'Error' is not returned, but I'm not certain that the results are correct, i.e., if the '1' is valid for the stock ticker in question. I simply left them in. Remove the formulae in Cells G23-31, if you wish. No harm.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
MSFT works fine here...
You mentioned the decimal separator. If you don't use U.S. Regional settings, VBA won't work right...which is probably why you're getting the 290.88B returned for the calculation in cell K14.
On Fri, Oct 18, 2013 at 4:15 AM, <boulder08@... mailto:boulder08@...> wrote:
I've tested it on MSFT so it should work.
What comes to the problem in cell K14, it seems that there value that is divided by 1000 is not a number according to Excel. For example with MSFT it's 290.88B :/
---In smf_addin@yahoogrou
MSFT works fine here...
You mentioned the decimal separator. If you don't use U.S. Regional settings, VBA won't work right...which is probably why you're getting the 290.88B returned for the calculation in cell K14.
On Fri, Oct 18, 2013 at 4:15 AM, <boulder08@
I've tested it on MSFT so it should work.
What comes to the problem in cell K14, it seems that there value that is divided by 1000 is not a number according to Excel. For example with MSFT it's 290.88B :/
Fri Oct 18, 2013 8:11 am (PDT) . Posted by:
joelfp2000
Randy,
I entered the =RCHGetYahooQuotes("mmm") in as an array and it works just fine. I'm not sure what I was thinking...
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumber("MMM";,848) doesn't work for me.
joel
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
This:
=RCHGetYahooQuotes("mmm")
...would just return "MMM" if you enter it into a single cell. The default first column of data is to return the ticker symbol. You need to array-enter it over multiple columns to retrieve the other default data items.
Does this work for you?
=0+smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
Or, what happens if you go to this URL using the EXCEL Web Query dialog (alt+d+d+w):
http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates
Do you see a Zacks rank?
On Thu, Oct 17, 2013 at 8:40 PM, <joel.andrews@... mailto:joel.andrews@...> wrote:
The RCHGetElementNumber("MMM",848) returns an ERROR and the RCHGetYahooQuotes("mmm") returns MMM. I have downloaded all of your "works in progress" files into my SMF folder and all of my other elements work just fine.
Any ideas would be greatly appreciated?
I entered the =RCHGetYahooQuotes(
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumbe
joel
---In smf_addin@yahoogrou
This:
=RCHGetYahooQuotes(
...would just return "MMM" if you enter it into a single cell. The default first column of data is to return the ticker symbol. You need to array-enter it over multiple columns to retrieve the other default data items.
Does this work for you?
=0+smfstrExtr(
Or, what happens if you go to this URL using the EXCEL Web Query dialog (alt+d+d+w):
http://www.zacks.
Do you see a Zacks rank?
On Thu, Oct 17, 2013 at 8:40 PM, <joel.andrews@
The RCHGetElementNumber
Any ideas would be greatly appreciated?
Fri Oct 18, 2013 8:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If that formula doesn't work, the element won't work. Because that *is* the
definition of the element.
So what do you get returned for just:
=smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
Rank:")
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@lpl.com> wrote:
> This formula does not work for me and returns a #Value! in the cell.
> =0+smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
> Rank:"),": ","-")
>
> The EXCEL Web Query works and I get the Zack's rating in the cell. (I
> would use the Excel web query in my spreadsheets but I haven't been able to
> figure out the formula for the query to reference a particular cell in my
> spreadsheet for the stock symbol.)
>
> I am still baffled why the =RCHGetElementNumber("MMM";,848) doesn't work
> for me.
>
definition of the element.
So what do you get returned for just:
=smfGetTagContent(
Rank:")
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@
> This formula does not work for me and returns a #Value! in the cell.
> =0+smfstrExtr(
> http://www.zacks.
> Rank:")
>
> The EXCEL Web Query works and I get the Zack's rating in the cell. (I
> would use the Excel web query in my spreadsheets but I haven't been able to
> figure out the formula for the query to reference a particular cell in my
> spreadsheet for the stock symbol.)
>
> I am still baffled why the =RCHGetElementNumbe
> for me.
>
Fri Oct 18, 2013 9:40 am (PDT) . Posted by:
joelfp2000
This is what I get...
Zacks Rank: 2-Buy <a href="javascript:void(0);" onclick="show('quote_rank_ribbon');" onmouseout="hide('quote_rank_ribbon');" onTouchStart="hide('quote_rank_ribbon');" onTouchEnd="hide('quote_rank_ribbon');" > <img src="http://b7d61a7c6b8c307bf531-a92a66b9587e2a0aa805bd4e70b98407.r95.cf2.rackcdn.com/images/zacks/icons/help_12x12.png" alt="" /></a>
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
If that formula doesn't work, the element won't work. Because that *is* the definition of the element.
So what do you get returned for just:
=smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:")
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@... mailto:joel.andrews@...> wrote:
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumber("MMM";,848) doesn't work for me.
Zacks Rank: 2-Buy <a href="javascri
---In smf_addin@yahoogrou
If that formula doesn't work, the element won't work. Because that *is* the definition of the element.
So what do you get returned for just:
=smfGetTagContent(
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumbe
Fri Oct 18, 2013 9:49 am (PDT) . Posted by:
joelfp2000
This is what I get.
Zacks Rank: 2-Buy <a href="javascript:void(0);" onclick="show('quote_rank_ribbon');" onmouseout="hide('quote_rank_ribbon');" onTouchStart="hide('quote_rank_ribbon');" onTouchEnd="hide('quote_rank_ribbon');" > <img src="http://b7d61a7c6b8c307bf531-a92a66b9587e2a0aa805bd4e70b98407.r95.cf2.rackcdn.com/images/zacks/icons/help_12x12.png" alt="" /></a>
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
If that formula doesn't work, the element won't work. Because that *is* the definition of the element.
So what do you get returned for just:
=smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:")
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@... mailto:joel.andrews@...> wrote:
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumber("MMM";,848) doesn't work for me.
Zacks Rank: 2-Buy <a href="javascri
---In smf_addin@yahoogrou
If that formula doesn't work, the element won't work. Because that *is* the definition of the element.
So what do you get returned for just:
=smfGetTagContent(
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumbe
Fri Oct 18, 2013 11:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's what you should get back. And it's what smfStrExtr() should be
extracting the data from.
Hmmm. Do you have an older version of EXCEL? It could be that the string
being returned exceeds its limitations. It's returning a string longer than
255 bytes.
Let's see. What do you get with:
=smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
Rank:"),": ","-")
Or, split out the two formulas:
D1: =smfGetTagContent("
http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
Rank:")
D2: =smfstrExtr(D1,": ","-")
That formula in D1 should work. It's what you just sent back. What do you
get in cell D2?
Does this version, with a shorter internal string, work?
=smfstrExtr(RCHGetWebData("
http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks
Rank:",30),": ","-")
On Fri, Oct 18, 2013 at 9:40 AM, <joel.andrews@lpl.com> wrote:
> This is what I get...
> Zacks Rank: 2-Buy <a href="javascript:void(0);"
> onclick="show('quote_rank_ribbon');"
> onmouseout="hide('quote_rank_ribbon');"
> onTouchStart="hide('quote_rank_ribbon');"
> onTouchEnd="hide('quote_rank_ribbon');" > <img
> src="http://b7d61a7c6b8c307bf531-a92a66b9587e2a0aa805bd4e70b98407.r95.cf2.rackcdn.com/images/zacks/icons/help_12x12.png"
> alt="" /></a> <http://www.zacks.com/stock/quote/MMM/detailed-estimates>
>
>
> ---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
>
> If that formula doesn't work, the element won't work. Because that *is*
> the definition of the element.
>
> So what do you get returned for just:
>
> =smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
> Rank:")
>
> On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@...> wrote:
>
> This formula does not work for me and returns a #Value! in the cell.
> =0+smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
> Rank:"),": ","-")
>
> The EXCEL Web Query works and I get the Zack's rating in the cell. (I
> would use the Excel web query in my spreadsheets but I haven't been able to
> figure out the formula for the query to reference a particular cell in my
> spreadsheet for the stock symbol.)
>
> I am still baffled why the =RCHGetElementNumber("MMM";,848) doesn't work
> for me.
>
>
>
>
>
>
extracting the data from.
Hmmm. Do you have an older version of EXCEL? It could be that the string
being returned exceeds its limitations. It's returning a string longer than
255 bytes.
Let's see. What do you get with:
=smfStrExtr(
http://www.zacks.
Rank:")
Or, split out the two formulas:
D1: =smfGetTagContent(
http://www.zacks.
Rank:")
D2: =smfstrExtr(
That formula in D1 should work. It's what you just sent back. What do you
get in cell D2?
Does this version, with a shorter internal string, work?
=smfstrExtr(
http://www.zacks.
Rank:",
On Fri, Oct 18, 2013 at 9:40 AM, <joel.andrews@
> This is what I get...
> Zacks Rank: 2-Buy <a href="javascri
> onclick="
> onmouseout="
> onTouchStart=
> onTouchEnd="
> src="http://b7d61a7c6b8c
> alt="" /></a> <http://www.zacks.
>
>
> ---In smf_addin@yahoogrou
>
> If that formula doesn't work, the element won't work. Because that *is*
> the definition of the element.
>
> So what do you get returned for just:
>
> =smfGetTagContent(
> Rank:")
>
> On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@
>
> This formula does not work for me and returns a #Value! in the cell.
> =0+smfstrExtr(
> http://www.zacks.
> Rank:")
>
> The EXCEL Web Query works and I get the Zack's rating in the cell. (I
> would use the Excel web query in my spreadsheets but I haven't been able to
> figure out the formula for the query to reference a particular cell in my
> spreadsheet for the stock symbol.)
>
> I am still baffled why the =RCHGetElementNumbe
> for me.
>
>
>
>
>
>
Fri Oct 18, 2013 12:46 pm (PDT) . Posted by:
joelfp2000
Yes, the shorter version does work. Also, splitting the formula up into the D1 and D2 works great. Thanks! I am using Excel 2003.
One last question...What do I use to replace the MMM symbol with the cell reference in my worksheet?
Thanks for your help with this...
Joel
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
That's what you should get back. And it's what smfStrExtr() should be extracting the data from.
Hmmm. Do you have an older version of EXCEL? It could be that the string being returned exceeds its limitations. It's returning a string longer than 255 bytes.
Let's see. What do you get with:
=smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
Or, split out the two formulas:
D1: =smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:")
D2: =smfstrExtr(D1,": ","-")
That formula in D1 should work. It's what you just sent back. What do you get in cell D2?
Does this version, with a shorter internal string, work?
=smfstrExtr(RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks Rank:",30),": ","-")
On Fri, Oct 18, 2013 at 9:40 AM, <joel.andrews@... mailto:joel.andrews@...> wrote:
This is what I get...
Zacks Rank: 2-Buy <a href="javascript:void(0);" onclick="show('quote_rank_ribbon');" onmouseout="hide('quote_rank_ribbon');" onTouchStart="hide('quote_rank_ribbon');" onTouchEnd="hide('quote_rank_ribbon');" > <img src="http://b7d61a7c6b8c307bf531-a92a66b9587e2a0aa805bd4e70b98407.r95.cf2.rackcdn.com/images/zacks/icons/help_12x12.png" alt="" /></a>
---In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, <rharmelink@...> wrote:
If that formula doesn't work, the element won't work. Because that *is* the definition of the element.
So what do you get returned for just:
=smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:")
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@... mailto:joel.andrews@...> wrote:
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumber("MMM";,848) doesn't work for me.
One last question...What do I use to replace the MMM symbol with the cell reference in my worksheet?
Thanks for your help with this...
Joel
---In smf_addin@yahoogrou
That's what you should get back. And it's what smfStrExtr() should be extracting the data from.
Hmmm. Do you have an older version of EXCEL? It could be that the string being returned exceeds its limitations. It's returning a string longer than 255 bytes.
Let's see. What do you get with:
=smfStrExtr(
Or, split out the two formulas:
D1: =smfGetTagContent(
D2: =smfstrExtr(
That formula in D1 should work. It's what you just sent back. What do you get in cell D2?
Does this version, with a shorter internal string, work?
=smfstrExtr(
On Fri, Oct 18, 2013 at 9:40 AM, <joel.andrews@
This is what I get...
Zacks Rank: 2-Buy <a href="javascri
---In smf_addin@yahoogrou
If that formula doesn't work, the element won't work. Because that *is* the definition of the element.
So what do you get returned for just:
=smfGetTagContent(
On Fri, Oct 18, 2013 at 8:11 AM, <joel.andrews@
This formula does not work for me and returns a #Value! in the cell. =0+smfstrExtr(
The EXCEL Web Query works and I get the Zack's rating in the cell. (I would use the Excel web query in my spreadsheets but I haven't been able to figure out the formula for the query to reference a particular cell in my spreadsheet for the stock symbol.)
I am still baffled why the =RCHGetElementNumbe
Fri Oct 18, 2013 1:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
OK. So it's EXCEL 2003 that was the problem. That may be an issue on a few
other element definitions as well.
This should do what you need:
=smfConvertData(smfstrExtr(RCHGetWebData("http://www.zacks.com/stock/quote/"&C3&"/detailed-estimates","Zacks
Rank:",30),": ","-"))
...where the ticker symbol is in cell C3.
On Fri, Oct 18, 2013 at 12:46 PM, <joel.andrews@lpl.com> wrote:
>
> Yes, the shorter version does work. Also, splitting the formula up into
> the D1 and D2 works great. Thanks! I am using Excel 2003.
>
> One last question...What do I use to replace the MMM symbol with the cell
> reference in my worksheet?
>
other element definitions as well.
This should do what you need:
=smfConvertData(
Rank:",
...where the ticker symbol is in cell C3.
On Fri, Oct 18, 2013 at 12:46 PM, <joel.andrews@
>
> Yes, the shorter version does work. Also, splitting the formula up into
> the D1 and D2 works great. Thanks! I am using Excel 2003.
>
> One last question...What do I use to replace the MMM symbol with the cell
> reference in my worksheet?
>
Fri Oct 18, 2013 1:47 pm (PDT) . Posted by:
joelfp2000
Yes sir e bob...that did the trick.
I will work on getting a newer version of excel. The formula and spreadsheet is working great.
Have a nice weekend!
Joel
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
OK. So it's EXCEL 2003 that was the problem. That may be an issue on a few other element definitions as well.
This should do what you need:
=smfConvertData(smfstrExtr(RCHGetWebData("http://www.zacks.com/stock/quote/ http://www.zacks.com/stock/quote/"&C3&"/detailed-estimates","Zacks Rank:",30),": ","-"))
...where the ticker symbol is in cell C3.
On Fri, Oct 18, 2013 at 12:46 PM, <joel.andrews@... mailto:joel.andrews@...> wrote:
Yes, the shorter version does work. Also, splitting the formula up into the D1 and D2 works great. Thanks! I am using Excel 2003.
One last question...What do I use to replace the MMM symbol with the cell reference in my worksheet?
I will work on getting a newer version of excel. The formula and spreadsheet is working great.
Have a nice weekend!
Joel
---In smf_addin@yahoogrou
OK. So it's EXCEL 2003 that was the problem. That may be an issue on a few other element definitions as well.
This should do what you need:
=smfConvertData(
...where the ticker symbol is in cell C3.
On Fri, Oct 18, 2013 at 12:46 PM, <joel.andrews@
Yes, the shorter version does work. Also, splitting the formula up into the D1 and D2 works great. Thanks! I am using Excel 2003.
One last question...What do I use to replace the MMM symbol with the cell reference in my worksheet?
Fri Oct 18, 2013 3:12 pm (PDT) . Posted by:
analyst101010
I've been crawling through the RCH index of functions... but can anyone throw me a bone and let me know where I can get benchmark metrics like YTD total return, past year total return, index yield, etc. for S&P500 vs DJIA vs. FTSE vs. others? I suppose I could use 'tickers' for the indexes but am unaware which ones will work. Any thoughts?
Thanks
JG
Thanks
JG
Fri Oct 18, 2013 4:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I would suggest using the ETFs based on the indexes. Then, it's a matter of
what information you need. It used to be easy to collect data from Yahoo's
ETF browser, but since they changed it, getting data from it is a
nightmare. Things even seem to be missing.
CNN has a solid set of data:
http://money.cnn.com/quote/etf/etf.html?symb=SPY
Or you could go directly to the source:
https://www.spdrs.com/product/fund.seam?ticker=spy
Or MarketWatch:
http://www.marketwatch.com/investing/fund/spy/profile
On Fri, Oct 18, 2013 at 3:12 PM, <jfgilmore@gmail.com> wrote:
>
> I've been crawling through the RCH index of functions... but can anyone
> throw me a bone and let me know where I can get benchmark metrics like YTD
> total return, past year total return, index yield, etc. for S&P500 vs DJIA
> vs. FTSE vs. others? I suppose I could use 'tickers' for the indexes but
> am unaware which ones will work. Any thoughts?
>
what information you need. It used to be easy to collect data from Yahoo's
ETF browser, but since they changed it, getting data from it is a
nightmare. Things even seem to be missing.
CNN has a solid set of data:
http://money.
Or you could go directly to the source:
https://www.
Or MarketWatch:
http://www.marketwa
On Fri, Oct 18, 2013 at 3:12 PM, <jfgilmore@gmail.
>
> I've been crawling through the RCH index of functions... but can anyone
> throw me a bone and let me know where I can get benchmark metrics like YTD
> total return, past year total return, index yield, etc. for S&P500 vs DJIA
> vs. FTSE vs. others? I suppose I could use 'tickers&#
> am unaware which ones will work. Any thoughts?
>
Tidak ada komentar:
Posting Komentar