3 Messages
Digest #3286
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"),"~","<"))
...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' tickers...
>
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol=
"&C5,"
...where cell C5 contains the ticker symbol.
On Sun, Jan 4, 2015 at 1:09 AM, jfgilmore@..
>
> 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&#
>
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?
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...
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:
Posting Komentar