8 New Messages
Digest #2467
2a
RCHGetTableCell has almost completely stopped working on web sites by "twopourdrummer" twopourdrummer
2b
Re: RCHGetTableCell has almost completely stopped working on web sit by "Randy Harmelink" rharmelink
2c
Re: RCHGetTableCell has almost completely stopped working on web sit by "twopourdrummer" twopourdrummer
2d
Re: RCHGetTableCell has almost completely stopped working on web sit by "Randy Harmelink" rharmelink
Messages
Mon Jan 14, 2013 7:33 am (PST) . Posted by:
"Steven" stevenletzer
Now that the morningstar data element number are obsolete, how do we get the annual Morningstar data points into a worksheet?
For example, at http://financials.morningstar.com/ratios/r.html?t=ABT®ion=USA&culture=en-us, a simple gettablecell returns an error.
RCHGetTableCell("http://financials.morningstar.com/ratios/r.html?t=ABT ", 1,"Payout Ratio %"), returns an Error.
Any solutions?
For example, at http://financials.
RCHGetTableCell(
Any solutions?
Mon Jan 14, 2013 9:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/20506
On Mon, Jan 14, 2013 at 8:33 AM, Steven stevenletzer@yahoo.com > wrote:
> Now that the morningstar data element number are obsolete, how do we get
> the annual Morningstar data points into a worksheet?
>
> For example, at
> http://financials.morningstar.com/ratios/r.html?t=ABT®ion=USA&culture=en-us,
> a simple gettablecell returns an error.
>
> RCHGetTableCell("http://financials.morningstar.com/ratios/r.html?t=ABT ",
> 1,"Payout Ratio %"), returns an Error.
>
> Any solutions?
>
On Mon, Jan 14, 2013 at 8:33 AM, Steven stevenletzer@
> Now that the morningstar data element number are obsolete, how do we get
> the annual Morningstar data points into a worksheet?
>
> For example, at
> http://financials.
> a simple gettablecell returns an error.
>
> RCHGetTableCell(
> 1,"Payout Ratio %"), returns an Error.
>
> Any solutions?
>
Mon Jan 14, 2013 7:52 am (PST) . Posted by:
"twopourdrummer" twopourdrummer
The web sites that I use to get my stock data has changed recently so I get error in the cell. Troubleshooting the issue, I noticed the web site changes to https instead of http. So I change the URL in the cell but now get #value for everything I try to pull from the site. Anybody have any ideas? Here is the formula
=RCHGetTableCell("https://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=aapl ",1,"Currency")
I've also changed currency to Trade time, with no results. I have formatted the cell to all options and nothing changes.
=RCHGetTableCell(
I've also changed currency to Trade time, with no results. I have formatted the cell to all options and nothing changes.
Mon Jan 14, 2013 10:03 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I just tried your formula below, and it worked fine for me...
Usually, a #VALUE! error in such a situation means one of the parameters is
of the wrong type, but everything looks fine to me.
What do you get with:
=RCHGetWebData("
https://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=aapl
","Currency",100)
On Mon, Jan 14, 2013 at 8:50 AM, twopourdrummer twopourdrummer@yahoo.com >wrote:
> The web sites that I use to get my stock data has changed recently so I
> get error in the cell. Troubleshooting the issue, I noticed the web site
> changes to https instead of http. So I change the URL in the cell but now
> get #value for everything I try to pull from the site. Anybody have any
> ideas? Here is the formula
>
> =RCHGetTableCell("
> https://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=aapl
> ",1,"Currency")
>
> I've also changed currency to Trade time, with no results. I have
> formatted the cell to all options and nothing changes.
>
Usually, a #VALUE! error in such a situation means one of the parameters is
of the wrong type, but everything looks fine to me.
What do you get with:
=RCHGetWebData(
https://eresearch.
","
On Mon, Jan 14, 2013 at 8:50 AM, twopourdrummer twopourdrummer@
> The web sites that I use to get my stock data has changed recently so I
> get error in the cell. Troubleshooting the issue, I noticed the web site
> changes to https instead of http. So I change the URL in the cell but now
> get #value for everything I try to pull from the site. Anybody have any
> ideas? Here is the formula
>
> =RCHGetTableCell(
> https://eresearch.
> ",1,"
>
> I've also changed currency to Trade time, with no results. I have
> formatted the cell to all options and nothing changes.
>
Mon Jan 14, 2013 12:13 pm (PST) . Posted by:
"twopourdrummer" twopourdrummer
I get #name when I put it in, however, I noticed you are using RCHGetWebData and I use RCHGetTableCell. Did you use RCHGetTableCell when you tested mine.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I just tried your formula below, and it worked fine for me...
>
> Usually, a #VALUE! error in such a situation means one of the parameters is
> of the wrong type, but everything looks fine to me.
>
> What do you get with:
>
> =RCHGetWebData("
> https://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=aapl
> ","Currency",100)
>
> On Mon, Jan 14, 2013 at 8:50 AM, twopourdrummer wrote:
>
> > The web sites that I use to get my stock data has changed recently so I
> > get error in the cell. Troubleshooting the issue, I noticed the web site
> > changes to https instead of http. So I change the URL in the cell but now
> > get #value for everything I try to pull from the site. Anybody have any
> > ideas? Here is the formula
> >
> > =RCHGetTableCell("
> > https://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=aapl
> > ",1,"Currency")
> >
> > I've also changed currency to Trade time, with no results. I have
> > formatted the cell to all options and nothing changes.
> >
>
--- In smf_addin@yahoogrou
>
> I just tried your formula below, and it worked fine for me...
>
> Usually, a #VALUE! error in such a situation means one of the parameters is
> of the wrong type, but everything looks fine to me.
>
> What do you get with:
>
> =RCHGetWebData(
> https://eresearch.
> ","
>
> On Mon, Jan 14, 2013 at 8:50 AM, twopourdrummer wrote:
>
> > The web sites that I use to get my stock data has changed recently so I
> > get error in the cell. Troubleshooting the issue, I noticed the web site
> > changes to https instead of http. So I change the URL in the cell but now
> > get #value for everything I try to pull from the site. Anybody have any
> > ideas? Here is the formula
> >
> > =RCHGetTableCell(
> > https://eresearch.
> > ",1,"
> >
> > I've also changed currency to Trade time, with no results. I have
> > formatted the cell to all options and nothing changes.
> >
>
Mon Jan 14, 2013 1:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The most likely reason for #NAME? is that the add-in isn't active any more.
Go to the add-in manager and make sure it's still got a check box on it.
I did use your RCHGetTableCell() function, as you had it written. I just
did a copy and paste...
On Mon, Jan 14, 2013 at 1:13 PM, twopourdrummer twopourdrummer@yahoo.com >wrote:
> I get #name when I put it in, however, I noticed you are using
> RCHGetWebData and I use RCHGetTableCell. Did you use RCHGetTableCell when
> you tested mine.
>
Go to the add-in manager and make sure it's still got a check box on it.
I did use your RCHGetTableCell(
did a copy and paste...
On Mon, Jan 14, 2013 at 1:13 PM, twopourdrummer twopourdrummer@
> I get #name when I put it in, however, I noticed you are using
> RCHGetWebData and I use RCHGetTableCell. Did you use RCHGetTableCell when
> you tested mine.
>
Mon Jan 14, 2013 6:16 pm (PST) . Posted by:
"thomasdardanic" thomasdardanic
Hi everyone. Where can I get a file of what the Element numbers are? for example: 4665, 4666,4667, etc?
Email: tomaj567@gmail.com
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> "Undefined" typically means you don't have the element definition files in
> the same directory as the add-in -- the "smf-elements-n.txt" files. Most of
> the element definitions are EXTERNAL to the add-in, for easier update.
> That's why the installation instructions says to "extract all of the files
> from the ZIP archive".
>
> On Thu, Jan 10, 2013 at 4:33 PM, bholscher@... <
> bholscher@...> wrote:
>
> > My RCHGetElementNumber string seems to be returning "undefined" for each
> > data piece I try to retrieve....
> >
> > Anyone know why this is or what could be causing it?
> >
> > Even the templates saved within the Files section are returning "undefined"
> >
> > I have tried element numbers 1 - 700 with different tickers and still
> > getting the "undefined"
> >
> > My RCHGetYahooQuotes and RCHGetYahooHistory are working fine
> >
>
Email: tomaj567@gmail.
--- In smf_addin@yahoogrou
>
> "Undefined&quo
> the same directory as the add-in -- the "smf-elements-
> the element definitions are EXTERNAL to the add-in, for easier update.
> That's why the installation instructions says to "extract all of the files
> from the ZIP archive"
>
> On Thu, Jan 10, 2013 at 4:33 PM, bholscher@..
> bholscher@..
>
> > My RCHGetElementNumber string seems to be returning "undefined&quo
> > data piece I try to retrieve....
> >
> > Anyone know why this is or what could be causing it?
> >
> > Even the templates saved within the Files section are returning "undefined&quo
> >
> > I have tried element numbers 1 - 700 with different tickers and still
> > getting the "undefined&quo
> >
> > My RCHGetYahooQuotes and RCHGetYahooHistory are working fine
> >
>
Mon Jan 14, 2013 6:19 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
They are in the XLS file that was one of the files in the ZIP archive you
downloaded...
On Mon, Jan 14, 2013 at 7:01 PM, thomasdardanic tomaj567@gmail.com > wrote:
> Hi everyone. Where can I get a file of what the Element numbers are? for
> example: 4665, 4666,4667, etc?
>
downloaded..
On Mon, Jan 14, 2013 at 7:01 PM, thomasdardanic tomaj567@gmail.
> Hi everyone. Where can I get a file of what the Element numbers are? for
> example: 4665, 4666,4667, etc?
>
Tidak ada komentar:
Posting Komentar