3 Messages

Digest #3250

StockGrader? by "Fred Wright" fredwwright

Re: StockGrader? by "Randy Harmelink" rharmelink

Help: List was working fine at the beginning and the end but those i by tzewei_79

Messages

1a

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

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

1b

Re: StockGrader?

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

"Randy Harmelink" rharmelink

Is this the number you're after?

=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol=AGX
","div",-1,"companyrating"),"~","<"))

They may just have redesigned the web page.

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?
>

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

2 Help: List was working fine at the beginning and the end but those i

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

tzewei_79

Hi,

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.

Regards,
Lewis

Attachment(s) from

1 of 1 File(s)