Minggu, 04 Januari 2015

[smf_addin] Digest Number 3286

3 Messages

Digest #3286
Re: StockGrader? by "Randy Harmelink" rharmelink
Re: StockGrader? by analyst101010
Re: StockGrader? by analyst101010


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

"Randy Harmelink" rharmelink

This worked just fine for me:


...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:



I always wondered how this worked


where B1 = the concatenation of

C1 = stock ticker


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:


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:

Posting Komentar