Kamis, 10 Desember 2015

[smf_addin] Digest Number 3578

10 Messages

Digest #3578
1a
1b
Re: Not pulling in stock data by "Randy Harmelink" rharmelink
2a
Down? by "The Kuffels" kuffel
2b
Re: Down? by "Randy Harmelink" rharmelink
2c
Re: Down? by "The Kuffels" kuffel
2d
Re: Down? by "Thomas Carnevale" tc_nyc85
3a
Re: Zacks Rank for zacks subscribers? by "Fred Wright" fredwwright
3b
Re: Zacks Rank for zacks subscribers? by "Randy Harmelink" rharmelink
4b

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?

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?
>

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?

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?
>
>

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.

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.
>
>
>

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&#39;);" 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&#39;);" onmouseout="hide('quote_style_score_ribbon&#39;);" ontouchstart="hide('quote_style_score_ribbon');" ontouchend="hide('quote_style_score_ribbon&#92;);">[?]</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>            

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)
>

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.



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.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar