5 New Messages
Digest #2646
1a
Some assistance with RCHGetYahooQuotes part of spreadsheet by "thefishermanpedro15" thefishermanpedro15
Messages
Wed Jun 5, 2013 5:47 pm (PDT) . Posted by:
"thefishermanpedro15" thefishermanpedro15
I am using excel 2003 , on windows 7 and have an old spreadsheet based on above.
During time I last used it and now I have changed computers and the Add ins required were not on machine.
Have downloaded RCH_Stock_Market_Functions to Programme Files (x86) to a folder styled SMF Add-in.
When I try to refresh file I get a #NAME error.
Formula in spreadsheet is
='C:\Program Files\SMF-Addin\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A2:A100,B1:M1)
One of the stocks used in A2 is AGK.ax
I did try using Program Files rather than Program Files (x86) but same result (#NAME error)
It appears to me that I also need an add in styled RCHGetYahooQuotes
but am unable to find it.
Where am I going wrong?
Thanks
During time I last used it and now I have changed computers and the Add ins required were not on machine.
Have downloaded RCH_Stock_Market_
When I try to refresh file I get a #NAME error.
Formula in spreadsheet is
='C:\
One of the stocks used in A2 is AGK.ax
I did try using Program Files rather than Program Files (x86) but same result (#NAME error)
It appears to me that I also need an add in styled RCHGetYahooQuotes
but am unable to find it.
Where am I going wrong?
Thanks
Wed Jun 5, 2013 6:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See the location errors item in the LINKS area of the group.
On Wed, Jun 5, 2013 at 5:47 PM, thefishermanpedro15 <prob1@bigpond.net.au >wrote:
> I am using excel 2003 , on windows 7 and have an old spreadsheet based on
> above.
>
> During time I last used it and now I have changed computers and the Add
> ins required were not on machine.
> Have downloaded RCH_Stock_Market_Functions to Programme Files (x86) to a
> folder styled SMF Add-in.
> When I try to refresh file I get a #NAME error.
> Formula in spreadsheet is
> ='C:\Program
> Files\SMF-Addin\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A2:A100,B1:M1)
> One of the stocks used in A2 is AGK.ax
>
> I did try using Program Files rather than Program Files (x86) but same
> result (#NAME error)
>
> It appears to me that I also need an add in styled RCHGetYahooQuotes
> but am unable to find it.
>
> Where am I going wrong?
>
On Wed, Jun 5, 2013 at 5:47 PM, thefishermanpedro15 <prob1@bigpond.
> I am using excel 2003 , on windows 7 and have an old spreadsheet based on
> above.
>
> During time I last used it and now I have changed computers and the Add
> ins required were not on machine.
> Have downloaded RCH_Stock_Market_
> folder styled SMF Add-in.
> When I try to refresh file I get a #NAME error.
> Formula in spreadsheet is
> ='C:\
> Files\SMF-
> One of the stocks used in A2 is AGK.ax
>
> I did try using Program Files rather than Program Files (x86) but same
> result (#NAME error)
>
> It appears to me that I also need an add in styled RCHGetYahooQuotes
> but am unable to find it.
>
> Where am I going wrong?
>
Wed Jun 5, 2013 6:42 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy
it still shows the same error. no idea why is that so..
--- 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'
> >
> > the rest, ''ERROR'' i tried up to 20 cells from B3 to B23 btw
> >
>
it still shows the same error. no idea why is that so..
--- 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.
> > on Assets"
> >
> > namely B3 and B4 displayed answer'
> >
> > the rest, ''ERROR&#
> >
>
Wed Jun 5, 2013 6:54 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
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'
> >
> > the rest, ''ERROR'' i tried up to 20 cells from B3 to B23 btw
> >
>
--- 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.
> > on Assets"
> >
> > namely B3 and B4 displayed answer'
> >
> > the rest, ''ERROR&#
> >
>
Wed Jun 5, 2013 6:58 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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@yahoo.com > 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'
>
=RCHGetWebData(
http://investing.
"&B3)
If that returns "Error"
page for some reason.
On Wed, Jun 5, 2013 at 6:54 PM, weekeewawa <weekeewawa@yahoo.
> 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'
>
Tidak ada komentar:
Posting Komentar