6 New Messages
Digest #2649
1b
Re: what is the difference between Rch type formula and smf type for by "Randy Harmelink" rharmelink
Messages
Fri Jun 7, 2013 1:39 pm (PDT) . Posted by:
"Xin L" liucyndy
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@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Can you give me an example?
>
> Typical reasons for #VALUE! on an add-in function:
>
> - Improper parameter
> - A string being returned is too long for EXCEL. This mostly affects
> older versions of EXCEL.
>
> But if you're copying and pasting, that pretty much leaves the second
> item...
> On Fri, Jun 7, 2013 at 11:15 AM, Xin L <jgr1230@...> wrote:
>
> > but why most of smf functions I used does not work? for example,
> > =smfGetCSVFile, I hard copied the formula from your website to my excel but
> > it returned #VALUE!.
> >
>
1. select range b3:e5
2. input formula =smfGetCSVFile(
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
>
> Can you give me an example?
>
> Typical reasons for #VALUE! on an add-in function:
>
> - Improper parameter
> - A string being returned is too long for EXCEL. This mostly affects
> older versions of EXCEL.
>
> But if you're copying and pasting, that pretty much leaves the second
> item...
> On Fri, Jun 7, 2013 at 11:15 AM, Xin L <jgr1230@
>
> > but why most of smf functions I used does not work? for example,
> > =smfGetCSVFile, I hard copied the formula from your website to my excel but
> > it returned #VALUE!.
> >
>
Fri Jun 7, 2013 2:35 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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@gmail.com > 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!
>
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@gmail.
> 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!
>
Fri Jun 7, 2013 9:02 pm (PDT) . Posted by:
"Yang" murfyang
Hi there,I have been trying ways to best extract from this link:
http://www.fundsupermart.com/main/fundinfo/generateTable.svdo
there are 2 tables: the Performance Table & the fund info table.
By web query I am able to extract the Performance Table but not the fundinfo table.
I wrote a routine to do a select all on fundinfo & then pasting onto a sheet & then cleaning & extracting from that temp sheet, but that is a very time consuming routine.
Is there any way that i can use any of the add-ins to overcome this.
thanks greatly Randy!
http://www.fundsupe
there are 2 tables: the Performance Table & the fund info table.
By web query I am able to extract the Performance Table but not the fundinfo table.
I wrote a routine to do a select all on fundinfo & then pasting onto a sheet & then cleaning & extracting from that temp sheet, but that is a very time consuming routine.
Is there any way that i can use any of the add-ins to overcome this.
thanks greatly Randy!
Fri Jun 7, 2013 9:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry. I don't see a way to get the funds info with the add-in, since it is
a dynamically generated table.
On Fri, Jun 7, 2013 at 9:02 PM, Yang <murfyang@yahoo.com.sg > wrote:
> Hi there,I have been trying ways to best extract from this link:
>
> http://www.fundsupermart.com/main/fundinfo/generateTable.svdo
>
> there are 2 tables: the Performance Table & the fund info table.
>
> By web query I am able to extract the Performance Table but not the
> fundinfo table.
>
> I wrote a routine to do a select all on fundinfo & then pasting onto a
> sheet & then cleaning & extracting from that temp sheet, but that is a very
> time consuming routine.
>
> Is there any way that i can use any of the add-ins to overcome this.
>
> thanks greatly Randy!
>
a dynamically generated table.
On Fri, Jun 7, 2013 at 9:02 PM, Yang <murfyang@yahoo.
> Hi there,I have been trying ways to best extract from this link:
>
> http://www.fundsupe
>
> there are 2 tables: the Performance Table & the fund info table.
>
> By web query I am able to extract the Performance Table but not the
> fundinfo table.
>
> I wrote a routine to do a select all on fundinfo & then pasting onto a
> sheet & then cleaning & extracting from that temp sheet, but that is a very
> time consuming routine.
>
> Is there any way that i can use any of the add-ins to overcome this.
>
> thanks greatly Randy!
>
Fri Jun 7, 2013 11:00 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
I was experimenting, I think businessweek has sort of like a quota where u can retrieve like yahoo. maybe thats why a large number of data extraction may result in error extraction
on other issues, may i just ask a quick question?
as you can see for example
i tried to use this code to extract the ''LATEST NEWS ABOUT IBM''
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/overview?symbol= "&L1&"","Latest News",1,"",1)
from
http://www.reuters.com/finance/stocks/overview?symbol=IBM
but it gives me the wrong extraction.
is there any specific code to extract just the latest news and headlines on ibm?
on top of that, as you can see from the example
''IBM to buy website hosting service SoftLayer''
it is a hyperlink.
so i would prefer to have a code where i can click onto the hyperlink that can lead me to the article
is there a code for it?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> On one of those that errors out, try:
>
> =RCHGetWebData("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=
> "&B3)
>
> If that returns "Error", your problem is that you can't retrieve the web
> page for some reason.
>
> On Wed, Jun 5, 2013 at 6:54 PM, weekeewawa <weekeewawa@...> wrote:
>
> > is there any other code that u can recommend?
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > I don't know what to tell you. It worked fine for the four I tried out.
> > >
> > > On Wed, Jun 5, 2013 at 6:01 AM, weekeewawa <weekeewawa@> wrote:
> > > >
> > > > thats exactly what i did by coping down
> > > > but only the first two cell
> > > >
> > > > =smfConvertData(smfGetTagContent("
> > > >
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=
> > "&B3,"div",3,">Return
> > > > on Assets"))
> > > >
> > > > namely B3 and B4 displayed answer'
> >
>
I was experimenting, I think businessweek has sort of like a quota where u can retrieve like yahoo. maybe thats why a large number of data extraction may result in error extraction
on other issues, may i just ask a quick question?
as you can see for example
i tried to use this code to extract the ''LATEST NEWS ABOUT IBM''
=RCHGetHTMLTable(
from
http://www.reuters.
but it gives me the wrong extraction.
is there any specific code to extract just the latest news and headlines on ibm?
on top of that, as you can see from the example
''IBM to buy website hosting service SoftLayer'
it is a hyperlink.
so i would prefer to have a code where i can click onto the hyperlink that can lead me to the article
is there a code for it?
--- In smf_addin@yahoogrou
>
> On one of those that errors out, try:
>
> =RCHGetWebData(
> http://investing.
> "&B3)
>
> If that returns "Error"
> page for some reason.
>
> On Wed, Jun 5, 2013 at 6:54 PM, weekeewawa <weekeewawa@
>
> > is there any other code that u can recommend?
> >
> > --- In smf_addin@yahoogrou
> > >
> > > I don't know what to tell you. It worked fine for the four I tried out.
> > >
> > > On Wed, Jun 5, 2013 at 6:01 AM, weekeewawa <weekeewawa@
> > > >
> > > > thats exactly what i did by coping down
> > > > but only the first two cell
> > > >
> > > > =smfConvertData(
> > > >
> > http://investing.
> > "&B3,"
> > > > on Assets"
> > > >
> > > > namely B3 and B4 displayed answer'
> >
>
Sat Jun 8, 2013 12:11 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Do a search on the message archives. I think it's been discussed before...
On Fri, Jun 7, 2013 at 10:59 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hello randy,
>
> I was experimenting, I think businessweek has sort of like a quota where u
> can retrieve like yahoo. maybe thats why a large number of data extraction
> may result in error extraction
>
> on other issues, may i just ask a quick question?
>
> as you can see for example
>
> i tried to use this code to extract the ''LATEST NEWS ABOUT IBM''
>
> =RCHGetHTMLTable("http://www.reuters.com/finance/stocks/overview?symbol= "&L1&"","Latest
> News",1,"",1)
>
> from
>
> http://www.reuters.com/finance/stocks/overview?symbol=IBM
>
> but it gives me the wrong extraction.
>
> is there any specific code to extract just the latest news and headlines
> on ibm?
>
> on top of that, as you can see from the example
>
> ''IBM to buy website hosting service SoftLayer''
>
> it is a hyperlink.
>
> so i would prefer to have a code where i can click onto the hyperlink that
> can lead me to the article
>
> is there a code for it?
>
On Fri, Jun 7, 2013 at 10:59 PM, weekeewawa <weekeewawa@yahoo.
> hello randy,
>
> I was experimenting, I think businessweek has sort of like a quota where u
> can retrieve like yahoo. maybe thats why a large number of data extraction
> may result in error extraction
>
> on other issues, may i just ask a quick question?
>
> as you can see for example
>
> i tried to use this code to extract the ''LATEST NEWS ABOUT IBM''
>
> =RCHGetHTMLTable(
> News",1,
>
> from
>
> http://www.reuters.
>
> but it gives me the wrong extraction.
>
> is there any specific code to extract just the latest news and headlines
> on ibm?
>
> on top of that, as you can see from the example
>
> ''IBM to buy website hosting service SoftLayer'
>
> it is a hyperlink.
>
> so i would prefer to have a code where i can click onto the hyperlink that
> can lead me to the article
>
> is there a code for it?
>
Tidak ada komentar:
Posting Komentar