15 New Messages
Digest #2644
Messages
Wed Jun 5, 2013 4:06 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
it seems that there is an amazing error
in
=smfConvertData(smfGetTagContent("http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ","div",3,">Return on Assets"))
when i keyed in the above code, it returns me with an answer
BUT
upon entering another quote on the same excel worksheet, it gives me an error.
and i tried ending 2 more quotes and still, it gives me an error
may i know what is wrong?
=smfConvertData(smfGetTagContent("http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=BMW:GR ","div",3,">Return on Assets"))
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Well, if you had looked at the web page coding, you would have seen that
> the table cells have multiple information in them, which is why you're
> seeing the labels and the amounts together. Also, using "open" as a search
> string was finding you the wrong "open" string, because it's too general a
> search term. It's just coincidental that the first table cell happened to
> be the open price.
>
> Instead, try:
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=IBM
> ","div",1,">Open"))
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ","div",3,">Return
> on Assets"))
>
> On Tue, Jun 4, 2013 at 6:16 PM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > on this page
> >
> >
> > http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=IBM
> >
> > i tried to extract information for example using this code
> >
> > =RCHGetTableCell("
> > http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=IBM
> > ",1,"Open")
> >
> > to extract the open price
> >
> > but the result that i was given is ''Open$208.60''
> >
> > is it possible to just have a code that extracts $208.60 instead?
> >
> > similarly,
> >
> > under this page
> >
> >
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM
> >
> > while using this code
> >
> > =RCHGetTableCell("
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ",0,"Return
> > on Assets")
> >
> > the result i was given is ''ReturnOnAssetsIndustryComparison11.68%"
> >
> > is there a way to extract just 11.68%?
> >
> >
>
it seems that there is an amazing error
in
=smfConvertData(
when i keyed in the above code, it returns me with an answer
BUT
upon entering another quote on the same excel worksheet, it gives me an error.
and i tried ending 2 more quotes and still, it gives me an error
may i know what is wrong?
=smfConvertData(
--- In smf_addin@yahoogrou
>
> Well, if you had looked at the web page coding, you would have seen that
> the table cells have multiple information in them, which is why you're
> seeing the labels and the amounts together. Also, using "open" as a search
> string was finding you the wrong "open" string, because it's too general a
> search term. It's just coincidental that the first table cell happened to
> be the open price.
>
> Instead, try:
>
> =smfConvertData(
> http://investing.
> ","
>
> =smfConvertData(
> http://investing.
> on Assets"
>
> On Tue, Jun 4, 2013 at 6:16 PM, weekeewawa <weekeewawa@
>
> >
> > on this page
> >
> >
> > http://investing.
> >
> > i tried to extract information for example using this code
> >
> > =RCHGetTableCell(
> > http://investing.
> > ",1,"
> >
> > to extract the open price
> >
> > but the result that i was given is ''Open$
> >
> > is it possible to just have a code that extracts $208.60 instead?
> >
> > similarly,
> >
> > under this page
> >
> >
> > http://investing.
> >
> > while using this code
> >
> > =RCHGetTableCell(
> > http://investing.
> > on Assets"
> >
> > the result i was given is ''ReturnOnA
> >
> > is there a way to extract just 11.68%?
> >
> >
>
Wed Jun 5, 2013 4:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know what to tell you -- your second formula worked fine for me. I
just cut and pasted it into my worksheet.
On Wed, Jun 5, 2013 at 4:06 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> it seems that there is an amazing error
>
> in
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ","div",3,">Return
> on Assets"))
>
> when i keyed in the above code, it returns me with an answer
>
> BUT
>
> upon entering another quote on the same excel worksheet, it gives me an
> error.
>
> and i tried ending 2 more quotes and still, it gives me an error
>
> may i know what is wrong?
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=BMW:GR ","div",3,">Return
> on Assets"))
>
just cut and pasted it into my worksheet.
On Wed, Jun 5, 2013 at 4:06 AM, weekeewawa <weekeewawa@yahoo.
>
> it seems that there is an amazing error
>
> in
>
> =smfConvertData(
> http://investing.
> on Assets"
>
> when i keyed in the above code, it returns me with an answer
>
> BUT
>
> upon entering another quote on the same excel worksheet, it gives me an
> error.
>
> and i tried ending 2 more quotes and still, it gives me an error
>
> may i know what is wrong?
>
> =smfConvertData(
> http://investing.
> on Assets"
>
Wed Jun 5, 2013 5:02 am (PDT) . Posted by:
"weekeewawa" weekeewawa
what i mean is, if i placed both quotes onto the same worksheet
which example i placed in sequence
IBM
GM
GE
GOOG
will only give me IBM
but ''ERROR'' for GM and any other quotes below IBM
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I don't know what to tell you -- your second formula worked fine for me. I
> just cut and pasted it into my worksheet.
>
> On Wed, Jun 5, 2013 at 4:06 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > it seems that there is an amazing error
> >
> > in
> >
> > =smfConvertData(smfGetTagContent("
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ","div",3,">Return
> > on Assets"))
> >
> > when i keyed in the above code, it returns me with an answer
> >
> > BUT
> >
> > upon entering another quote on the same excel worksheet, it gives me an
> > error.
> >
> > and i tried ending 2 more quotes and still, it gives me an error
> >
> > may i know what is wrong?
> >
> > =smfConvertData(smfGetTagContent("
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=BMW:GR ","div",3,">Return
> > on Assets"))
> >
>
which example i placed in sequence
IBM
GM
GE
GOOG
will only give me IBM
but ''ERROR&#
--- In smf_addin@yahoogrou
>
> I don't know what to tell you -- your second formula worked fine for me. I
> just cut and pasted it into my worksheet.
>
> On Wed, Jun 5, 2013 at 4:06 AM, weekeewawa <weekeewawa@
>
> >
> > it seems that there is an amazing error
> >
> > in
> >
> > =smfConvertData(
> > http://investing.
> > on Assets"
> >
> > when i keyed in the above code, it returns me with an answer
> >
> > BUT
> >
> > upon entering another quote on the same excel worksheet, it gives me an
> > error.
> >
> > and i tried ending 2 more quotes and still, it gives me an error
> >
> > may i know what is wrong?
> >
> > =smfConvertData(
> > http://investing.
> > on Assets"
> >
>
Wed Jun 5, 2013 5:21 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Works fine here:
IBM 0.1168 GM 0.0091 GE 0.0155 GOOG 0.0973
On Wed, Jun 5, 2013 at 5:02 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> what i mean is, if i placed both quotes onto the same worksheet
>
> which example i placed in sequence
> IBM
> GM
> GE
> GOOG
>
> will only give me IBM
> but ''ERROR'' for GM and any other quotes below IBM
>
IBM 0.1168 GM 0.0091 GE 0.0155 GOOG 0.0973
On Wed, Jun 5, 2013 at 5:02 AM, weekeewawa <weekeewawa@yahoo.
> what i mean is, if i placed both quotes onto the same worksheet
>
> which example i placed in sequence
> IBM
> GM
> GE
> GOOG
>
> will only give me IBM
> but ''ERROR&#
>
Wed Jun 5, 2013 5:31 am (PDT) . Posted by:
"weekeewawa" weekeewawa
sorry to add
the problem happens only when i point to a certain cell
for example
=smfConvertData(smfGetTagContent("http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return on Assets"))
=smfConvertData(smfGetTagContent("http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return on Assets"))
=smfConvertData(smfGetTagContent("http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return on Assets"))
the problems start from cell B5 and onwards
thats where i get all the ''ERROR'' message
--- In smf_addin@yahoogroups.com , "weekeewawa" <weekeewawa@...> wrote:
>
> hello randy,
>
> it seems that there is an amazing error
>
> in
>
> =smfConvertData(smfGetTagContent("http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ","div",3,">Return on Assets"))
>
> when i keyed in the above code, it returns me with an answer
>
> BUT
>
> upon entering another quote on the same excel worksheet, it gives me an error.
>
> and i tried ending 2 more quotes and still, it gives me an error
>
> may i know what is wrong?
>
> =smfConvertData(smfGetTagContent("http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=BMW:GR ","div",3,">Return on Assets"))
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Well, if you had looked at the web page coding, you would have seen that
> > the table cells have multiple information in them, which is why you're
> > seeing the labels and the amounts together. Also, using "open" as a search
> > string was finding you the wrong "open" string, because it's too general a
> > search term. It's just coincidental that the first table cell happened to
> > be the open price.
> >
> > Instead, try:
> >
> > =smfConvertData(smfGetTagContent("
> > http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=IBM
> > ","div",1,">Open"))
> >
> > =smfConvertData(smfGetTagContent("
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ","div",3,">Return
> > on Assets"))
> >
> > On Tue, Jun 4, 2013 at 6:16 PM, weekeewawa <weekeewawa@> wrote:
> >
> > >
> > > on this page
> > >
> > >
> > > http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=IBM
> > >
> > > i tried to extract information for example using this code
> > >
> > > =RCHGetTableCell("
> > > http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=IBM
> > > ",1,"Open")
> > >
> > > to extract the open price
> > >
> > > but the result that i was given is ''Open$208.60''
> > >
> > > is it possible to just have a code that extracts $208.60 instead?
> > >
> > > similarly,
> > >
> > > under this page
> > >
> > >
> > > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM
> > >
> > > while using this code
> > >
> > > =RCHGetTableCell("
> > > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker=IBM ",0,"Return
> > > on Assets")
> > >
> > > the result i was given is ''ReturnOnAssetsIndustryComparison11.68%"
> > >
> > > is there a way to extract just 11.68%?
> > >
> > >
> >
>
the problem happens only when i point to a certain cell
for example
=smfConvertData(
=smfConvertData(
=smfConvertData(
the problems start from cell B5 and onwards
thats where i get all the ''ERROR&#
--- In smf_addin@yahoogrou
>
> hello randy,
>
> it seems that there is an amazing error
>
> in
>
> =smfConvertData(
>
> when i keyed in the above code, it returns me with an answer
>
> BUT
>
> upon entering another quote on the same excel worksheet, it gives me an error.
>
> and i tried ending 2 more quotes and still, it gives me an error
>
> may i know what is wrong?
>
> =smfConvertData(
>
> --- In smf_addin@yahoogrou
> >
> > Well, if you had looked at the web page coding, you would have seen that
> > the table cells have multiple information in them, which is why you're
> > seeing the labels and the amounts together. Also, using "open" as a search
> > string was finding you the wrong "open" string, because it's too general a
> > search term. It's just coincidental that the first table cell happened to
> > be the open price.
> >
> > Instead, try:
> >
> > =smfConvertData(
> > http://investing.
> > ","
> >
> > =smfConvertData(
> > http://investing.
> > on Assets"
> >
> > On Tue, Jun 4, 2013 at 6:16 PM, weekeewawa <weekeewawa@
> >
> > >
> > > on this page
> > >
> > >
> > > http://investing.
> > >
> > > i tried to extract information for example using this code
> > >
> > > =RCHGetTableCell(
> > > http://investing.
> > > ",1,"
> > >
> > > to extract the open price
> > >
> > > but the result that i was given is ''Open$
> > >
> > > is it possible to just have a code that extracts $208.60 instead?
> > >
> > > similarly,
> > >
> > > under this page
> > >
> > >
> > > http://investing.
> > >
> > > while using this code
> > >
> > > =RCHGetTableCell(
> > > http://investing.
> > > on Assets"
> > >
> > > the result i was given is ''ReturnOnA
> > >
> > > is there a way to extract just 11.68%?
> > >
> > >
> >
>
Wed Jun 5, 2013 5:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
All of the formulas I had in the table I presented used cell references.
For example:
=smfConvertData(smfGetTagContent("
http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&C4,"div",3,">Return
on Assets"))
...which I copied down for the other 3 ticker symbols. No errors here.
Did you try smfForceRecalculation? Maybe the site was unavailable for a
short time, so all of the page retrievals errored out?
On Wed, Jun 5, 2013 at 5:31 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> sorry to add
>
> the problem happens only when i point to a certain cell
>
> for example
>
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return
> on Assets"))
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return
> on Assets"))
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return
> on Assets"))
>
> the problems start from cell B5 and onwards
>
> thats where i get all the ''ERROR'' message
>
For example:
=smfConvertData(
http://investing.
on Assets"
...which I copied down for the other 3 ticker symbols. No errors here.
Did you try smfForceRecalculati
short time, so all of the page retrievals errored out?
On Wed, Jun 5, 2013 at 5:31 AM, weekeewawa <weekeewawa@yahoo.
> sorry to add
>
> the problem happens only when i point to a certain cell
>
> for example
>
>
> =smfConvertData(
> http://investing.
> on Assets"
>
> =smfConvertData(
> http://investing.
> on Assets"
>
> =smfConvertData(
> http://investing.
> on Assets"
>
> the problems start from cell B5 and onwards
>
> thats where i get all the ''ERROR&#
>
Wed Jun 5, 2013 6:02 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
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@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> All of the formulas I had in the table I presented used cell references.
> For example:
>
> =smfConvertData(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&C4,"div",3,">Return
> on Assets"))
>
> ...which I copied down for the other 3 ticker symbols. No errors here.
>
> Did you try smfForceRecalculation? Maybe the site was unavailable for a
> short time, so all of the page retrievals errored out?
>
> On Wed, Jun 5, 2013 at 5:31 AM, weekeewawa <weekeewawa@...> wrote:
>
> > sorry to add
> >
> > the problem happens only when i point to a certain cell
> >
> > for example
> >
> >
> > =smfConvertData(smfGetTagContent("
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return
> > on Assets"))
> >
> > =smfConvertData(smfGetTagContent("
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return
> > on Assets"))
> >
> > =smfConvertData(smfGetTagContent("
> > http://investing.businessweek.com/research/stocks/financials/ratios.asp?ticker= "&B5&"","div",3,">Return
> > on Assets"))
> >
> > the problems start from cell B5 and onwards
> >
> > thats where i get all the ''ERROR'' message
> >
>
thats exactly what i did by coping down
but only the first two cell
=smfConvertData(
namely B3 and B4 displayed answer'
the rest, ''ERROR&#
--- In smf_addin@yahoogrou
>
> All of the formulas I had in the table I presented used cell references.
> For example:
>
> =smfConvertData(
> http://investing.
> on Assets"
>
> ...which I copied down for the other 3 ticker symbols. No errors here.
>
> Did you try smfForceRecalculati
> short time, so all of the page retrievals errored out?
>
> On Wed, Jun 5, 2013 at 5:31 AM, weekeewawa <weekeewawa@
>
> > sorry to add
> >
> > the problem happens only when i point to a certain cell
> >
> > for example
> >
> >
> > =smfConvertData(
> > http://investing.
> > on Assets"
> >
> > =smfConvertData(
> > http://investing.
> > on Assets"
> >
> > =smfConvertData(
> > http://investing.
> > on Assets"
> >
> > the problems start from cell B5 and onwards
> >
> > thats where i get all the ''ERROR&#
> >
>
Wed Jun 5, 2013 6:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
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@yahoo.com > 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
>
On Wed, Jun 5, 2013 at 6:01 AM, weekeewawa <weekeewawa@yahoo.
>
> 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 5:31 am (PDT) . Posted by:
"MLawson" mlawson3
I focused on code because I didn't think through the ways I could make the spreadsheet functions work together. But, yeah, I could set up three download tables, one for each financial statement, with the categories repeating in sequence for each year (sales t, COR t, sga t, then sales t-1, CORS t-1, sga t-1, etc) before transposing each section into individual columns (10 columns for 10 years of annual data). That's a good idea.
Thanks for your suggestion.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It only does it the one way, sorry.
>
> But rather than write all of your own code for a transposed version, why
> not just run it as-is and then transpose it, putting the output in another
> worksheet?
>
> On Tue, Jun 4, 2013 at 7:42 PM, MLawson <mlawson3@...> wrote:
>
> > I'd like to populate a typical financial statement spreadsheet, i.e.,
> > categories running from top to bottom along the left side of a table while
> > the reporting periods run left to right across the top, using a function
> > similar to the smfdowloadtableupdate (?name?). Before I start declaring
> > arrays and piggy-backing off the code you have written, do you have an
> > off-the-shelf version laying around? I am trying to avoid creating a
> > spreadsheet with a few hundred formulas in it for 10 years worth of
> > financial data.
> >
>
Thanks for your suggestion.
--- In smf_addin@yahoogrou
>
> It only does it the one way, sorry.
>
> But rather than write all of your own code for a transposed version, why
> not just run it as-is and then transpose it, putting the output in another
> worksheet?
>
> On Tue, Jun 4, 2013 at 7:42 PM, MLawson <mlawson3@
>
> > I'd like to populate a typical financial statement spreadsheet, i.e.,
> > categories running from top to bottom along the left side of a table while
> > the reporting periods run left to right across the top, using a function
> > similar to the smfdowloadtableupda
> > arrays and piggy-backing off the code you have written, do you have an
> > off-the-shelf version laying around? I am trying to avoid creating a
> > spreadsheet with a few hundred formulas in it for 10 years worth of
> > financial data.
> >
>
Wed Jun 5, 2013 6:18 am (PDT) . Posted by:
"Jim Ranum"
Hi Randy,
May I ask, how do you transpose an entire table into a new tab or
spreadsheet?
This is something I've needed to do before.
Thanks,
Jim
May I ask, how do you transpose an entire table into a new tab or
spreadsheet?
This is something I've needed to do before.
Thanks,
Jim
Wed Jun 5, 2013 6:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can do a copy and paste special, which has a transpose option
available. Works best for values, since some cell references don't
transpose well.
Or, use EXCEL's TRANSPOSE() function, which would need to be array-entered.
On Wed, Jun 5, 2013 at 6:16 AM, Jim Ranum <amt2100@gmail.com > wrote:
>
>
> May I ask, how do you transpose an entire table into a new tab or
> spreadsheet?****
>
> This is something I've needed to do before.****
>
>
>
available. Works best for values, since some cell references don't
transpose well.
Or, use EXCEL's TRANSPOSE() function, which would need to be array-entered.
On Wed, Jun 5, 2013 at 6:16 AM, Jim Ranum <amt2100@gmail.
>
>
> May I ask, how do you transpose an entire table into a new tab or
> spreadsheet?
>
> This is something I've needed to do before.****
>
>
>
Wed Jun 5, 2013 8:58 am (PDT) . Posted by:
"student.umich1000" student.umich1000
Hi Randy,
Is there a way to use the SMF add in to download data from 13F filings? I saw a post on this in the forum, but was unable to find a solution. Please advise.
Thanks.
Is there a way to use the SMF add in to download data from 13F filings? I saw a post on this in the forum, but was unable to find a solution. Please advise.
Thanks.
Wed Jun 5, 2013 9:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried it and had no problem. The hard part would be getting the URL
address of the 13-F filing.
On Wed, Jun 5, 2013 at 8:52 AM, student.umich1000 <
student.umich1000@yahoo.com > wrote:
>
> Is there a way to use the SMF add in to download data from 13F filings? I
> saw a post on this in the forum, but was unable to find a solution. Please
> advise.
>
address of the 13-F filing.
On Wed, Jun 5, 2013 at 8:52 AM, student.umich1000 <
student.umich1000@
>
> Is there a way to use the SMF add in to download data from 13F filings? I
> saw a post on this in the forum, but was unable to find a solution. Please
> advise.
>
Wed Jun 5, 2013 9:03 am (PDT) . Posted by:
"racecar00" racecar00
Randy,
This link was working fine until today. I am now getting an "Error" message for all funds listed. Was wondering if you made a change of if Yahoo! did.
Formula is written as follows:
=RCHGetElementNumber($B8,13862)
Thanks
This link was working fine until today. I am now getting an "Error" message for all funds listed. Was wondering if you made a change of if Yahoo! did.
Formula is written as follows:
=RCHGetElementNumbe
Thanks
Wed Jun 5, 2013 9:11 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried it on IBM, VFINX, and SPY, and all three returned names. But
it was very slow.
It gets data from MSN, not Yahoo.
On Wed, Jun 5, 2013 at 9:03 AM, racecar00 <agelhausen@gmail.com > wrote:
>
> This link was working fine until today. I am now getting an "Error"
> message for all funds listed. Was wondering if you made a change of if
> Yahoo! did.
>
> Formula is written as follows:
>
> =RCHGetElementNumber($B8,13862)
>
it was very slow.
It gets data from MSN, not Yahoo.
On Wed, Jun 5, 2013 at 9:03 AM, racecar00 <agelhausen@gmail.
>
> This link was working fine until today. I am now getting an "Error"
> message for all funds listed. Was wondering if you made a change of if
> Yahoo! did.
>
> Formula is written as follows:
>
> =RCHGetElementNumbe
>
Tidak ada komentar:
Posting Komentar