Messages

1a

Mon Nov 24, 2014 4:14 pm (PST) . Posted by:

I had been using (for a long time so am not sure exactly how I cam up with it) the following link to pull the MarketGrader Grade from the web without any log-in issues: =RCHGetWebData("http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol="&A3,"final overall grade of", 4,23)

where A3 is the symbol to pull the Stock Grade that Barrons' uses -- here is a link to the barrons page (unfortunatley you need to log in): http://online.barrons.com/page/stock_grader.html?symbol=agx

It used to work fine for me but stopped today? Perhaps MarketGrader has started charging/requiring a log-in to pull an individual stock? Does anyone else pull this number using Randy's wonderful tool? Fred

I'm assuming the "no log-in issue" is simply a hole in their security.

On Mon, Nov 24, 2014 at 5:11 PM, Fred Wright fredwwright@... wrote:

> > I had been using (for a long time so am not sure exactly how I cam up with > it) the following link to pull the MarketGrader Grade from the web without > any log-in issues: > > =RCHGetWebData(" > http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol="&A3,"final > overall grade of", 4,23) > > where A3 is the symbol to pull the Stock Grade that Barrons' uses -- here > is a link to the barrons page (unfortunatley you need to log in): > > http://online.barrons.com/page/stock_grader.html?symbol=agx > > It used to work fine for me but stopped today? Perhaps MarketGrader has > started charging/requiring a log-in to pull an individual stock? Does > anyone else pull this number using Randy's wonderful tool? >

2

Tue Nov 25, 2014 1:42 am (PST) . Posted by:

Starting from line 143 column D,F,G,H,K,L and M are showing "Error" all of a sudden. The formula are constant. I confirmed the website that they pointed to and the data to be extracted are there. Not sure what happened.