Selasa, 25 November 2014

[smf_addin] Digest Number 3250[1 Attachment]

3 Messages

Digest #3250
1a
StockGrader? by "Fred Wright" fredwwright
1b
Re: StockGrader? by "Randy Harmelink" rharmelink

Messages

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

"Fred Wright" fredwwright

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

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

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

Tidak ada komentar:

Poskan Komentar