Senin, 29 Agustus 2016

[smf_addin] Digest Number 3785

3 Messages

Digest #3785

Messages

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.


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.





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

Tidak ada komentar:

Poskan Komentar