Messages In This Digest (1 Message)

Message

1a.: Re: IBD and RCHGetTableCell Error

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu Feb 2, 2012 7:39 pm (PST)

The problem is that they have changed the URLs. It is no longer driven
simply by ticker symbol, so it's going to be more difficult to grab data.
For example, instead of:

http://www.investors.com/StockResearch/StockCheckup.aspx?symbol=MMM

...the URL now needs to be:

http://research.investors.com/StockCheckup/Nyse-Three-M-Company-MMM.aspx

On Thu, Feb 2, 2012 at 7:56 PM, Roger Diaz <rogerdiazb@gmail.com> wrote:

>
> I am a subscriber of IBD but I try to apply the formula for ratings
> information but always get Error.
> =RCHGetTableCell("
> http://www.investors.com/StockResearch/StockCheckup.aspx?symbol="&A$5,1,">RS
> Rating")
> I saw the post on this subject, but always fails. In Excel / Data / Web
> enter my username and pswd and see the results but not the formula does
> not extract the data.
> I will appreciate your answer.
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)