2 New Messages
Digest #2652
1b
Re: what is the difference between Rch type formula and smf type for by "Randy Harmelink" rharmelink
Messages
Mon Jun 10, 2013 10:08 am (PDT) . Posted by:
"Xin L" liucyndy
Thanks so much! It works this time! But still, I have one puzzle. How many tickers' data can I get one time? It seems that I can only get about 30 tickers' data. or am I wrong? I have a ticker list much longer than 30. Thanks again!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Aha! Try smfJoin() functions instead of sfJoin() functions.
>
> The sfJoin() was a personal function of mine. where the "sf" prefix means
> "string function". At the time I mentioned it there, I also gave the
> function, which you needed to make available if you wanted to use it.
>
> Later, I decided to add this utility function to the add-in as smfJoin(),
> since I was using it quite a bit in examples of concatenating a range of
> strings.
>
> On Fri, Jun 7, 2013 at 1:39 PM, Xin L <jgr1230@...> wrote:
>
> > I basically copied your example. Pls see below, what I did is
> > 1. select range b3:e5
> > 2. input formula =smfGetCSVFile("http://finviz.com/export.ashx?v=151&T=
> > "&sfJoin(A3:A5,",")&"&c="&sfJoin(B1:E1,","))
> > 3. press ctrl+shift+enter
> > anything wrong?
> >
> > 14 55 56 65
> > Dividend Yield 50-Day High 50-Day Low Price
> > IBM #VALUE! #VALUE! #VALUE! #VALUE!
> > NFLX #VALUE! #VALUE! #VALUE! #VALUE!
> > SPY #VALUE! #VALUE! #VALUE! #VALUE!
> >
>
--- In smf_addin@yahoogrou
>
> Aha! Try smfJoin() functions instead of sfJoin() functions.
>
> The sfJoin() was a personal function of mine. where the "sf" prefix means
> "string function"
> function, which you needed to make available if you wanted to use it.
>
> Later, I decided to add this utility function to the add-in as smfJoin(),
> since I was using it quite a bit in examples of concatenating a range of
> strings.
>
> On Fri, Jun 7, 2013 at 1:39 PM, Xin L <jgr1230@
>
> > I basically copied your example. Pls see below, what I did is
> > 1. select range b3:e5
> > 2. input formula =smfGetCSVFile(
> > "&sfJoin(
> > 3. press ctrl+shift+enter
> > anything wrong?
> >
> > 14 55 56 65
> > Dividend Yield 50-Day High 50-Day Low Price
> > IBM #VALUE! #VALUE! #VALUE! #VALUE!
> > NFLX #VALUE! #VALUE! #VALUE! #VALUE!
> > SPY #VALUE! #VALUE! #VALUE! #VALUE!
> >
>
Mon Jun 10, 2013 10:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure I ever tested for a limit.
If you have a lot, maybe it would be easier to just grab the WHOLE file,
and use VLOOKUP() on the returned results to get the individual data items
you want?
On Mon, Jun 10, 2013 at 10:08 AM, Xin L <jgr1230@gmail.com > wrote:
> Thanks so much! It works this time! But still, I have one puzzle. How many
> tickers' data can I get one time? It seems that I can only get about 30
> tickers' data. or am I wrong? I have a ticker list much longer than
> 30. Thanks again!
>
If you have a lot, maybe it would be easier to just grab the WHOLE file,
and use VLOOKUP() on the returned results to get the individual data items
you want?
On Mon, Jun 10, 2013 at 10:08 AM, Xin L <jgr1230@gmail.
> Thanks so much! It works this time! But still, I have one puzzle. How many
> tickers' data can I get one time? It seems that I can only get about 30
> tickers' data. or am I wrong? I have a ticker list much longer than
> 30. Thanks again!
>
Tidak ada komentar:
Posting Komentar