Minggu, 04 Januari 2015

[smf_addin] Digest Number 3286

3 Messages

Digest #3286
1a
Re: StockGrader? by "Randy Harmelink" rharmelink
1b
Re: StockGrader? by analyst101010
1c
Re: StockGrader? by analyst101010

Messages

Sun Jan 4, 2015 12:24 am (PST) . Posted by:

"Randy Harmelink" rharmelink

This worked just fine for me:

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

...where cell C5 contains the ticker symbol.

On Sun, Jan 4, 2015 at 1:09 AM, jfgilmore@... wrote:

>
> Would there be some way to pull that same # for a group of stocks down?
> I've tried that before, by inserting an excel cell reference inside the
> quotes where the HTML address is, but obviously that doesn't work...
>
> ...im' thinking - could you write a second set of cells where the HTML
> address is created from a group of stock tickers by concatenating the
> result?
>
> I'm just curious how that might work for say, a selected group of 10 or so
> 'comparison&#39; tickers...
>

Sun Jan 4, 2015 12:31 am (PST) . Posted by:

analyst101010

hehehe

I always wondered how this worked

=smfConvertData(smfstrExtr(smfGetTagContent(B1,"div",-1,"companyrating"),"~","<"))

where B1 = the concatenation of

C1 = stock ticker

and

D1 = html string, "http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol="

Is that what most people are doing to do batch pulldowns from things that otherwise need long HTML strings?

Sun Jan 4, 2015 12:34 am (PST) . Posted by:

analyst101010

Oh, its that easy? Jesus I seem to always find the clumsiest way to do things...

I think its just been that i've never really gotten all that hip to how HTML & text references work together in formulae...
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar