[smf_addin] Digest Number 3785

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3785

1a

Re: why am i getting 'error' for zacks rating? by nelsonmuntz1000

1b

Re: why am i getting 'error' for zacks rating? by nelsonmuntz1000

1c

Re: why am i getting 'error' for zacks rating? by "Randy Harmelink" rharmelink

Messages

1a

Re: why am i getting 'error' for zacks rating?

Sun Aug 28, 2016 11:25 pm (PDT) . Posted by:

nelsonmuntz1000

Zacks ETF Rank

Hi Randy


Tried your formula from Jan 19, 2014


=smfConvertData(smfstrExtr(smfGetTagContent("http://www.zacks.com/funds/etf/SPY/profile http://www.zacks.com/funds/etf/SPY/profile","p",-1,"ETF Rank:"),":","-"))



and with modified URL =smfConvertData(smfstrExtr(smfGetTagContent("https://www.zacks.com/funds/etf/SPY/profile http://www.zacks.com/funds/etf/SPY/profile","p",-1,"ETF Rank:"),":","-"))


I don't get any result from this formula, not sure that it works. Value should be 3.


Link:
https://www.zacks.com/funds/etf/SPY/profile?q=SPY?q=SPY?q=SPY https://www.zacks.com/funds/etf/SPY/profile?q=SPY?q=SPY?q=SPY


Any help would be appreciated. Thanks for making this add-in available, it's a great tool.

Reply to sender . Reply to group . Reply via Web Post . All Messages (15) . Top ^

1b

Re: why am i getting 'error' for zacks rating?

Sun Aug 28, 2016 11:33 pm (PDT) . Posted by:

nelsonmuntz1000

Re: Zacks Rank for ETFs , your message dated January 19, 2014

Not Sure that this formula still works:


=smfConvertData(smfstrExtr(smfGetTagContent("http://www.zacks.com/funds/etf/SPY/profile http://www.zacks.com/funds/etf/SPY/profile","p",-1,"ETF Rank:"),":","-"))



Link:
https://www.zacks.com/funds/etf/SPY/profile?q=SPY?q=SPY?q=SPY https://www.zacks.com/funds/etf/SPY/profile?q=SPY?q=SPY?q=SPY


Your help would be appreciated. Thanks for this great tool.

Reply to sender . Reply to group . Reply via Web Post . All Messages (15) . Top ^

1c

Re: why am i getting 'error' for zacks rating?

Sun Aug 28, 2016 11:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfGetTagContent("
https://www.zacks.com/funds/etf/SPY/profile","span",1,">Zacks
Premium",">Zacks Premium",">Zacks ETF Rank"))

All Zacks data pages are "https" now, so any "http" URLs wouldn't work. But
stocks and ETFs have different web pages, so the extraction needs to be
different.

On Sun, Aug 28, 2016 at 9:05 PM, ccoupe300@
​...wrote:

>
> Zacks ETF Rank
>
> Hi Randy
>
> Tried your formula from Jan 19, 2014
>
> =smfConvertData(smfstrExtr(smfGetTagContent("http://www.
> zacks.com/funds/etf/SPY/profile","p",-1,"ETF Rank:"),":","-"))
>
> and with modified URL =smfConvertData(smfstrExtr(smfGetTagContent("
> https://www.zacks.com/funds/etf/SPY/profile
> <http://www.zacks.com/funds/etf/SPY/profile>","p",-1,"ETF
> Rank:"),":","-"))
>
> I don't get any result from this formula, not sure that it works. Value
> should be 3.
>
> Link:
> https://www.zacks.com/funds/etf/SPY/profile?q=SPY?q=SPY?q=SPY
>
> Any help would be appreciated. Thanks for making this add-in available,
> it's a great tool.
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (15) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 17

• Privacy • Unsubscribe • Terms of Use