10 Messages
Digest #3578
Messages
Wed Dec 9, 2015 11:29 am (PST) . Posted by:
matthewpdobbins
I can get the version number, but I can't get the RCHGetYahooQuotes("SPY","l1") value: that returns N/A.
I am particularly interested in the cover and DCF tabs, but those are returning errors as well. I can get a chart of the 10 year stock price, though.
Is there something else I could try to populate these tabs?
I am particularly interested in the cover and DCF tabs, but those are returning errors as well. I can get a chart of the 10 year stock price, though.
Is there something else I could try to populate these tabs?
Wed Dec 9, 2015 3:50 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You'll need to mention the workbook in the subject line, or the author of
the workbook may never see your question. I have no idea what workbook
you're asking about.
However, this formula works fine for me:
=RCHGetYahooQuotes("SPY","l1")
I'm not sure how you can get "N/A", since that's not a value the add-in
would fill in, and I don't think I've ever seen Yahoo return that value for
last price -- especially on SPY.
On Wed, Dec 9, 2015 at 12:29 PM, matthewpdobbins@... wrote:
>
> I can get the version number, but I can't get the
> RCHGetYahooQuotes("SPY","l1") value: that returns N/A.
>
> I am particularly interested in the cover and DCF tabs, but those are
> returning errors as well. I can get a chart of the 10 year stock price,
> though.
>
> Is there something else I could try to populate these tabs?
>
the workbook may never see your question. I have no idea what workbook
you're asking about.
However, this formula works fine for me:
=RCHGetYahooQuotes(
I'm not sure how you can get "N/A"
would fill in, and I don't think I've ever seen Yahoo return that value for
last price -- especially on SPY.
On Wed, Dec 9, 2015 at 12:29 PM, matthewpdobbins@
>
> I can get the version number, but I can't get the
> RCHGetYahooQuotes(
>
> I am particularly interested in the cover and DCF tabs, but those are
> returning errors as well. I can get a chart of the 10 year stock price,
> though.
>
> Is there something else I could try to populate these tabs?
>
Wed Dec 9, 2015 3:27 pm (PST) . Posted by:
"The Kuffels" kuffel
After years of flawless use, RCHGetYahooQuotes stopped functioning in the middle of a session. Worked, went away for a few minutes, came back, not working.
Any ides what is going on?
Any ides what is going on?
Wed Dec 9, 2015 3:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There have been a few people noting issues in the past week or so...I'm
assuming Yahoo glitches.
I suggest array-entering the RCHGetYahooQuotes() functions, so you have as
few as possible. It may not get rid of the problem, but it should minimize
how frustrating they can be, since you won't get a mix of some working and
some not working on the same recalculation. And recalculation should be
much faster.
On Wed, Dec 9, 2015 at 11:36 AM, 'The Kuffels' kuffel@...wrote:
>
> After years of flawless use, RCHGetYahooQuotes stopped functioning in the
> middle of a session. Worked, went away for a few minutes, came back, not
> working.
>
> Any ides what is going on?
>
>
assuming Yahoo glitches.
I suggest array-entering the RCHGetYahooQuotes(
few as possible. It may not get rid of the problem, but it should minimize
how frustrating they can be, since you won't get a mix of some working and
some not working on the same recalculation. And recalculation should be
much faster.
On Wed, Dec 9, 2015 at 11:36 AM, 'The Kuffels' kuffel@...wrote:
>
> After years of flawless use, RCHGetYahooQuotes stopped functioning in the
> middle of a session. Worked, went away for a few minutes, came back, not
> working.
>
> Any ides what is going on?
>
>
Wed Dec 9, 2015 4:13 pm (PST) . Posted by:
"The Kuffels" kuffel
<< RCHGetYahooQuotes stopped functioning >>
Working again. Appears the problem was with my ISP. Not a total failure but enough to cause several problems.
Working again. Appears the problem was with my ISP. Not a total failure but enough to cause several problems.
Wed Dec 9, 2015 4:48 pm (PST) . Posted by:
"Thomas Carnevale" tc_nyc85
Yahoo has also been redirecting me to their new Beta homepage, which
fortunately does not affect the detailed stock quotes. Their new website is
horrible - I'm definitely going to miss the old homepage view.
*Tom Carnevale*
*401-644-2790*
*Investing:Decoded
<http://t.sidekickopen33.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XZs4X9RWgW7fcz4z7fctX4VQBcsP56dykqf9dkfKW02?t=http%3A%2F%2Fwww.investingdecoded.com%2F&si=5166332943269888&pi=a7908123-8c4b-4382-e677-9108e75359f9>*
On Wed, Dec 9, 2015 at 7:13 PM, 'The Kuffels' kuffel@cyberport.net
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
>
> << RCHGetYahooQuotes stopped functioning >>
>
> Working again. Appears the problem was with my ISP. Not a total failure
> but enough to cause several problems.
>
>
>
fortunately does not affect the detailed stock quotes. Their new website is
horrible - I'm definitely going to miss the old homepage view.
*Tom Carnevale*
*401-644-2790*
*Investing:Decoded
<http://t.sidekickopen33.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XZs4X9RWgW7fcz4z7fctX4VQBcsP56dykqf9dkfKW02?t=http%3A%2F%2Fwww.investingdecoded.com%2F&si=5166332943269888&pi=a7908123-8c4b-4382-e677-9108e75359f9>*
On Wed, Dec 9, 2015 at 7:13 PM, 'The Kuffels' kuffel@cyberport.net
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
>
> << RCHGetYahooQuotes stopped functioning >>
>
> Working again. Appears the problem was with my ISP. Not a total failure
> but enough to cause several problems.
>
>
>
Wed Dec 9, 2015 3:43 pm (PST) . Posted by:
"Fred Wright" fredwwright
I am a subscriber to Zacks and wondered if anyone could help me figure out how to pull the Zacks Rank and Style scores from this section of the source code for IBM (www.zacks.com/stock/quote/IBM?q=ibm) - the Zacks Rank is "4-sell" and the style scores are value: A; Growth C and Momentum C -- cut/past from screen is below followed by a cut/paste of the relevant page source (I have bolded the relevant data points)
Thanks, Fred
Zacks Rank [?]: 4-Sell 4 Style Scores [?] : Value: A| Growth: C| Momentum: C
<div class="group3"> <div class="zr_rankbox"> <p><span class="float_left">Zacks Rank <sup class="help_text" title="Zacks Rank Explained"><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');" >[?]</a></sup>:</span> 4-Sell <span class="rank_chip rankrect_1"> </span> <span class="rank_chip rankrect_2"> </span> <span class="rank_chip rankrect_3"> </span> <span class="rank_chip rankrect_4">4</span> <span class="rank_chip rankrect_5"> </span> </p> </div><div class="composite_group"> <p> <span class="float_left">Style Scores <sup class="help_text" title="Zacks Style score Explained"><a href="javascript:void(0);" onclick="show('quote_style_score_ribbon');" onmouseout="hide('quote_style_score_ribbon');" ontouchstart="hide('quote_style_score_ribbon');" ontouchend="hide('quote_style_score_ribbon\);">[?]</a></sup> :</span> Value: <span class="composite_val">A</span>| Growth: <span class="composite_val">C</span>| Momentum: <span class="composite_val">C</span> </p> </div>
Thanks, Fred
Zacks Rank [?]: 4-Sell 4 Style Scores [?] : Value: A| Growth: C| Momentum: C
<div class="
Wed Dec 9, 2015 4:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfConvertData(smfStrExtr(smfStrExtr(smfGetTagContent($D$6,"p",1,"zr_rankbox"),">:<","<"),">","-"))
=smfGetTagContent($D$6,"span",1,"zr_rankbox","Value:")
=smfGetTagContent($D$6,"span",1,"zr_rankbox","Growth:")
=smfGetTagContent($D$6,"span",1,"zr_rankbox","Momentum:")
...replacing $D$6 with your created URL.
On Wed, Dec 9, 2015 at 4:43 PM, Fred Wright fredwwright@...wrote:
>
> I am a subscriber to Zacks and wondered if anyone could help me figure out
> how to pull the Zacks Rank and Style scores from this section of the source
> code for IBM (www.zacks.com/stock/quote/IBM?q=ibm) - the Zacks Rank is
> "4-sell" and the style scores are value: A; Growth C and Momentum C --
> cut/past from screen is below followed by a cut/paste of the relevant page
> source (I have bolded the relevant data points)
>
=smfConvertData(
=smfGetTagContent(
=smfGetTagContent(
=smfGetTagContent(
...replacing $D$6 with your created URL.
On Wed, Dec 9, 2015 at 4:43 PM, Fred Wright fredwwright@
>
> I am a subscriber to Zacks and wondered if anyone could help me figure out
> how to pull the Zacks Rank and Style scores from this section of the source
> code for IBM (www.zacks.com/
> "4-sell" and the style scores are value: A; Growth C and Momentum C --
> cut/past from screen is below followed by a cut/paste of the relevant page
> source (I have bolded the relevant data points)
>
Wed Dec 9, 2015 7:39 pm (PST) . Posted by:
zbgb952
RCHGetElementNumber(ticker,848) just gives me an ERROR message now?!?! What is up? I've used this for years...
If it doesn't work any more..can someone suggest another such stock rating function that is still available?!? Thanks.
If it doesn't work any more..can someone suggest another such stock rating function that is still available?!? Thanks.
Wed Dec 9, 2015 8:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Zacks closed up the security loophole so it's now only available to
subscribers.
Most of the ratings I've used in the past are now either gone or only
available to subscribers, except for maybe:
http://www.barchart.com/opinions/stocks/MMM
On Wed, Dec 9, 2015 at 8:39 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> RCHGetElementNumber(ticker,848) just gives me an ERROR message now?!?!
> What is up? I've used this for years...
>
> If it doesn't work any more..can someone suggest another such stock rating
> function that is still available?!? Thanks.
>
>
subscribers.
Most of the ratings I've used in the past are now either gone or only
available to subscribers, except for maybe:
http://www.barchart.com/opinions/stocks/MMM
On Wed, Dec 9, 2015 at 8:39 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> RCHGetElementNumber
> What is up? I've used this for years...
>
> If it doesn't work any more..can someone suggest another such stock rating
> function that is still available?!? Thanks.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar