[smf_addin] Digest Number 4342

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #4342

1a

Re: Did Zacks change their website again? by caleb.mullins25

1b

Re: Did Zacks change their website again? by "Randy Harmelink" rharmelink

2a

Zacks Brokerage Recommendation Table by caleb.mullins25

2b

Re: Zacks Brokerage Recommendation Table by "Randy Harmelink" rharmelink

2c

Re: Zacks Brokerage Recommendation Table by caleb.mullins25

2d

Re: Zacks Brokerage Recommendation Table by "Randy Harmelink" rharmelink

2e

Re: Zacks Brokerage Recommendation Table by caleb.mullins25

Messages

1a

Re: Did Zacks change their website again?

Tue Jun 12, 2018 9:11 am (PDT) . Posted by:

caleb.mullins25

Hi Randy,

I was using these links for Strong buy, Buy, Hold figure in Brokerage Recommendations table

RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,1)
RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,2)
RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,3)

It stopped working after the recent change. What change is needed to make it work again?

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

1b

Re: Did Zacks change their website again?

Tue Jun 12, 2018 9:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

All three formulas are working fine here.

On Tue, Jun 12, 2018 at 9:10 AM, naeem_4tk@
​...
wrote:

>
> I was using these links for Strong buy, Buy, Hold figure in Brokerage
> Recommendations table
>
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,1)
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,2)
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,3)
>
> It stopped working after the recent change. What change is needed to make
> it work again?
>
>
>

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

2a

Zacks Brokerage Recommendation Table

Tue Jun 12, 2018 9:14 am (PDT) . Posted by:

caleb.mullins25

Hi Randy,


I was using these links to grab figure in front of Strong buy, Buy, Hold, Sell and Strong Sell figure (Today column).
RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,1)

RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,2)

RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,3)

RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,4)

RCHGetTableCell("https://www.zacks.com/stock/research/MMM/brokerage-recommendations",-5,"1 Week Ago",,,,5)



It has stopped working after the recent change and i am failing to sort it out. Please tell me what change is required to make it work. Thanks

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

2b

Re: Zacks Brokerage Recommendation Table

Tue Jun 12, 2018 9:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

All five formulas are working fine here. Maybe the Zacks site was down
temporarily?

However, instead of skipping rows, I would have done something like:

=RCHGetTableCell("
https://www.zacks.com/stock/research/MMM/brokerage-recommendations",1,">1
Week Ago",">Buy")

Then it's more self-documenting as well.

On Tue, Jun 12, 2018 at 9:14 AM, naeem_4tk@
​...
wrote:

> I was using these links to grab figure in front of Strong buy, Buy, Hold,
> Sell and Strong Sell figure (Today column).
>
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,1)
>
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,2)
>
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,3)
>
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,4)
>
> RCHGetTableCell("https://www.zacks.com/stock/research/MMM/
> brokerage-recommendations",-5,"1 Week Ago",,,,5)
>
> It has stopped working after the recent change and i am failing to sort it
> out. Please tell me what change is required to make it work. Thanks
>

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

2c

Re: Zacks Brokerage Recommendation Table

Tue Jun 12, 2018 10:03 am (PDT) . Posted by:

caleb.mullins25

Hmm yes that looks a better way to do it. Both ways are still not working for me. I will try it again tomorrow. Thanks

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

2d

Re: Zacks Brokerage Recommendation Table

Tue Jun 12, 2018 10:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Have you been doing a large number of data retrievals from them? There was
an instance a few years ago where someone had their IP address suspended
temporarily. What do you see if you access that web page using the IE
object within EXCEL (alt+d+d+w)? Does it look normal to you?

On Tue, Jun 12, 2018 at 10:03 AM, naeem_4tk@
​...
wrote:

>
> Hmm yes that looks a better way to do it. Both ways are still not working
> for me. I will try it again tomorrow. Thanks
>
>
>

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

2e

Re: Zacks Brokerage Recommendation Table

Tue Jun 12, 2018 10:43 am (PDT) . Posted by:

caleb.mullins25

Yes i do have large number of data retrievals i.e. 120. The link opens normally in Opera. In excel, it just gives "Error." It looks normal to me. I am using google web cache link to retrieve that for now. But it does not work for 25% and that is not right way to do that in the long run. I also though there might be Zacks problem but it's nearly a week now.

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

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

Visit Your Group

• New Members 6

• Privacy • Unsubscribe • Terms of Use