10 New Messages
Digest #2401
Messages
Thu Nov 15, 2012 7:21 am (PST) . Posted by:
"José Azevedo" jma_resende
Hello!
I try to write in cell the Sector of some company and in other the PER of
this sector.
Like:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&B4;1;"Sector:") where
B4 are, in this case: CVA
and are ok.
I have in cell F31="*Indu**strial Goods*"
But I want the P/E of this sector, and I write:
=RCHGetTableCell("http://biz.yahoo.com/p/s_conameu.html ";3;""&F31)
and I have ERROR
If I choose other stock with other sector, like Healthcare i do not have
problem.
Some suggest to correct?
Many Thanks
Jose
I try to write in cell the Sector of some company and in other the PER of
this sector.
Like:
=RCHGetTableCell(
B4 are, in this case: CVA
and are ok.
I have in cell F31="*Indu**
But I want the P/E of this sector, and I write:
=RCHGetTableCell(
and I have ERROR
If I choose other stock with other sector, like Healthcare i do not have
problem.
Some suggest to correct?
Many Thanks
Jose
Thu Nov 15, 2012 7:46 am (PST) . Posted by:
"José Azevedo" jma_resende
Other question:
Later I want the PER of the Industry for some stock.
But this is not so easy for me.
After I have the name in cell how I can access the link in this industry?
If I try explain:
Example:
With this
F33 =RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&F4;1;"Industry:")
The name are put in G34, in this casa "Waste Management"
But, how I access this page for extract the PER?
I thought:
It is possible extract the link of this web "
http://finance.yahoo.com/q/pr?s= "&F4;1;"Industry:"
and put this link in command RCH?
Many thanks
Jose
On 15 November 2012 15:20, José Azevedo <jmazevedo@gmail.com > wrote:
> Hello!
>
> I try to write in cell the Sector of some company and in other the PER of
> this sector.
> Like:
> =RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&B4;1;"Sector:")
> where B4 are, in this case: CVA
> and are ok.
> I have in cell F31="*Indu**strial Goods*"
>
> But I want the P/E of this sector, and I write:
> =RCHGetTableCell("http://biz.yahoo.com/p/s_conameu.html ";3;""&F31)
> and I have ERROR
>
> If I choose other stock with other sector, like Healthcare i do not have
> problem.
> Some suggest to correct?
>
> Many Thanks
> Jose
>
Later I want the PER of the Industry for some stock.
But this is not so easy for me.
After I have the name in cell how I can access the link in this industry?
If I try explain:
Example:
With this
F33 =RCHGetTableCell(
The name are put in G34, in this casa "Waste Management"
But, how I access this page for extract the PER?
I thought:
It is possible extract the link of this web "
http://finance.
and put this link in command RCH?
Many thanks
Jose
On 15 November 2012 15:20, José Azevedo <jmazevedo@gmail.
> Hello!
>
> I try to write in cell the Sector of some company and in other the PER of
> this sector.
> Like:
> =RCHGetTableCell(
> where B4 are, in this case: CVA
> and are ok.
> I have in cell F31="*Indu**
>
> But I want the P/E of this sector, and I write:
> =RCHGetTableCell(
> and I have ERROR
>
> If I choose other stock with other sector, like Healthcare i do not have
> problem.
> Some suggest to correct?
>
> Many Thanks
> Jose
>
Thu Nov 15, 2012 1:05 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You're getting an error because the coding for the
http://biz.yahoo.com/p/s_conameu.html web page has a line feed between
"Industrial" and "Goods". Which is also why "Healthcare" works -- no line
feed in the middle.
Additionally, the add-in strips out line feeds and carriage returns from a
web page when it processes it, so you could try something like:
=RCHGetTableCell("http://biz.yahoo.com/p/s_conameu.html ",3,SUBSTITUTE(F31,"
",""))
On Thu, Nov 15, 2012 at 8:20 AM, José Azevedo <jmazevedo@gmail.com > wrote:
>
> I try to write in cell the Sector of some company and in other the PER of
> this sector.
> Like:
> =RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&B4;1;"Sector:")
> where B4 are, in this case: CVA
> and are ok.
> I have in cell F31="*Indu**strial Goods*"
>
> But I want the P/E of this sector, and I write:
> =RCHGetTableCell("http://biz.yahoo.com/p/s_conameu.html ";3;""&F31)
> and I have ERROR
>
> If I choose other stock with other sector, like Healthcare i do not have
> problem.
> Some suggest to correct?
>
http://biz.yahoo.
"Industrial" and "Goods". Which is also why "Healthcare" works -- no line
feed in the middle.
Additionally, the add-in strips out line feeds and carriage returns from a
web page when it processes it, so you could try something like:
=RCHGetTableCell(
",""))
On Thu, Nov 15, 2012 at 8:20 AM, José Azevedo <jmazevedo@gmail.
>
> I try to write in cell the Sector of some company and in other the PER of
> this sector.
> Like:
> =RCHGetTableCell(
> where B4 are, in this case: CVA
> and are ok.
> I have in cell F31="*Indu**
>
> But I want the P/E of this sector, and I write:
> =RCHGetTableCell(
> and I have ERROR
>
> If I choose other stock with other sector, like Healthcare i do not have
> problem.
> Some suggest to correct?
>
Thu Nov 15, 2012 1:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
What is a PER?
On Thu, Nov 15, 2012 at 8:45 AM, José Azevedo <jmazevedo@gmail.com > wrote:
>
> Other question:
>
> Later I want the PER of the Industry for some stock.
> But this is not so easy for me.
> After I have the name in cell how I can access the link in this industry?
> If I try explain:
> Example:
> With this
> F33 =RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&F4;1;"Industry:")
> The name are put in G34, in this casa "Waste Management"
>
> But, how I access this page for extract the PER?
>
> I thought:
> It is possible extract the link of this web "
> http://finance.yahoo.com/q/pr?s= "&F4;1;"Industry:"
> and put this link in command RCH?
>
>
On Thu, Nov 15, 2012 at 8:45 AM, José Azevedo <jmazevedo@gmail.
>
> Other question:
>
> Later I want the PER of the Industry for some stock.
> But this is not so easy for me.
> After I have the name in cell how I can access the link in this industry?
> If I try explain:
> Example:
> With this
> F33 =RCHGetTableCell(
> The name are put in G34, in this casa "Waste Management"
>
> But, how I access this page for extract the PER?
>
> I thought:
> It is possible extract the link of this web "
> http://finance.
> and put this link in command RCH?
>
>
Thu Nov 15, 2012 10:12 am (PST) . Posted by:
"Dave Charlaff" copthornelabs
Randy,
I'm looking for the:
Total Debt(mrq)
Enterprise Value(latest)
Shares outstanding
From this Yahoo page.
http://finance.yahoo.com/q/ks?s=pwe
<http://finance.yahoo.com/q/ks?s=pwe&ql=1 > &ql=1
I cannot seem to get any of the element numbers to work in the
rchgetelementnumber function.
I want to array enter this also for a list of symbols when the element
number issue is resolved.
Can you help here please.
Dave C
I'm looking for the:
Total Debt(mrq)
Enterprise Value(latest)
Shares outstanding
From this Yahoo page.
http://finance.
<http://finance.
I cannot seem to get any of the element numbers to work in the
rchgetelementnumber function.
I want to array enter this also for a list of symbols when the element
number issue is resolved.
Can you help here please.
Dave C
Thu Nov 15, 2012 10:43 am (PST) . Posted by:
"Ron Spruell" hashky
RCHGetElementNumber()
966
942
981
>________________________________
> From: Dave Charlaff <davecharlaff@hotmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, November 15, 2012 12:12 PM
>Subject: [smf_addin] element numbers
>
>
>
>Randy,
>I’m looking for the:
>
>Total Debt(mrq)
>Enterprise Value(latest)
>Shares outstanding
>
>From this Yahoo page.
>http://finance.yahoo.com/q/ks?s=pwe&ql=1
>
>I cannot seem to get any of the element numbers to work in the rchgetelementnumber function.
>
>I want to array enter this also for a list of symbols when the element number issue is resolved.
>
>Can you help here please.
>Dave C
>
>
>
966
942
981
>___________
> From: Dave Charlaff <davecharlaff@
>To: smf_addin@yahoogrou
>Sent: Thursday, November 15, 2012 12:12 PM
>Subject: [smf_addin] element numbers
>
>
>
>Randy,
>I’m looking for the:
>
>Total Debt(mrq)
>Enterprise Value(latest)
>Shares outstanding
>
>From this Yahoo page.
>http://finance.
>
>I cannot seem to get any of the element numbers to work in the rchgetelementnumber function.
>
>I want to array enter this also for a list of symbols when the element number issue is resolved.
>
>Can you help here please.
>Dave C
>
>
>
Thu Nov 15, 2012 11:01 am (PST) . Posted by:
"Dave Charlaff" copthornelabs
Thx Ron, I am using these element numbers but they return Error for me.
Any Thoughts as to why?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
Sent: Thursday, November 15, 2012 1:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] element numbers
RCHGetElementNumber()
966
942
981
_____
From: Dave Charlaff <davecharlaff@hotmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, November 15, 2012 12:12 PM
Subject: [smf_addin] element numbers
Randy,
I’m looking for the:
Total Debt(mrq)
Enterprise Value(latest)
Shares outstanding
From this Yahoo page.
http://finance.yahoo.com/q/ks?s=pwe <http://finance.yahoo.com/q/ks?s=pwe&ql=1 > &ql=1
I cannot seem to get any of the element numbers to work in the rchgetelementnumber function.
I want to array enter this also for a list of symbols when the element number issue is resolved.
Can you help here please.
Dave C
Any Thoughts as to why?
From: smf_addin@yahoogrou
Sent: Thursday, November 15, 2012 1:43 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] element numbers
RCHGetElementNumber
966
942
981
_____
From: Dave Charlaff <davecharlaff@
To: smf_addin@yahoogrou
Sent: Thursday, November 15, 2012 12:12 PM
Subject: [smf_addin] element numbers
Randy,
I’m looking for the:
Total Debt(mrq)
Enterprise Value(latest)
Shares outstanding
From this Yahoo page.
http://finance.
I cannot seem to get any of the element numbers to work in the rchgetelementnumber function.
I want to array enter this also for a list of symbols when the element number issue is resolved.
Can you help here please.
Dave C
Thu Nov 15, 2012 1:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I tried the element number Ron gave, and they work fine here. At least for
PWE. You may get an error if you don't use US Regional settings.
You would NOT be able to array-enter a formula for the extraction from a
web page -- there's no advantage to doing so. Individual formulas are just
as fast. The array-entered advantage comes when web sites provide CSV files
that can contain specificly requested data.
On Thu, Nov 15, 2012 at 11:12 AM, Dave Charlaff <davecharlaff@hotmail.com >wrote:
> I’m looking for the:
>
>
>
> Total Debt(mrq)
>
> Enterprise Value(latest)
>
> Shares outstanding
>
>
>
> From this Yahoo page.
>
> http://finance.yahoo.com/q/ks?s=pwe&ql=1
>
>
>
> I cannot seem to get any of the element numbers to work in the
> rchgetelementnumber function.
>
>
>
> I want to array enter this also for a list of symbols when the element
> number issue is resolved.
>
>
> On Thu, Nov 15, 2012 at 12:01 PM, Dave Charlaff <davecharlaff@hotmail.com >wrote:
>
>
> Thx Ron, I am using these element numbers but they return Error for me.***
> *
>
> Any Thoughts as to why?****
>
> ** **
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] *On
> Behalf Of *Ron Spruell
> *Sent:* Thursday, November 15, 2012 1:43 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] element numbers****
>
> ** **
>
> ****
>
> RCHGetElementNumber()****
>
> 966****
>
> 942****
>
> 981
>
PWE. You may get an error if you don't use US Regional settings.
You would NOT be able to array-enter a formula for the extraction from a
web page -- there's no advantage to doing so. Individual formulas are just
as fast. The array-entered advantage comes when web sites provide CSV files
that can contain specificly requested data.
On Thu, Nov 15, 2012 at 11:12 AM, Dave Charlaff <davecharlaff@
> I’m looking for the:
>
>
>
> Total Debt(mrq)
>
> Enterprise Value(latest)
>
> Shares outstanding
>
>
>
> From this Yahoo page.
>
> http://finance.
>
>
>
> I cannot seem to get any of the element numbers to work in the
> rchgetelementnumber function.
>
>
>
> I want to array enter this also for a list of symbols when the element
> number issue is resolved.
>
>
> On Thu, Nov 15, 2012 at 12:01 PM, Dave Charlaff <davecharlaff@
>
>
> Thx Ron, I am using these element numbers but they return Error for me.***
> *
>
> Any Thoughts as to why?****
>
> ** **
>
> *From:* smf_addin@yahoogrou
> Behalf Of *Ron Spruell
> *Sent:* Thursday, November 15, 2012 1:43 PM
> *To:* smf_addin@yahoogrou
> *Subject:* Re: [smf_addin] element numbers****
>
> ** **
>
> ****
>
> RCHGetElementNumber
>
> 966****
>
> 942****
>
> 981
>
Thu Nov 15, 2012 1:34 pm (PST) . Posted by:
"Dave Charlaff" copthornelabs
US Regional settings? I am unfamiliar with this.
Is that a setting in IE? Or Yahoo specific?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, November 15, 2012 4:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] element numbers
I tried the element number Ron gave, and they work fine here. At least for PWE. You may get an error if you don't use US Regional settings.
You would NOT be able to array-enter a formula for the extraction from a web page -- there's no advantage to doing so. Individual formulas are just as fast. The array-entered advantage comes when web sites provide CSV files that can contain specificly requested data.
On Thu, Nov 15, 2012 at 11:12 AM, Dave Charlaff <davecharlaff@hotmail.com > wrote:
I’m looking for the:
Total Debt(mrq)
Enterprise Value(latest)
Shares outstanding
From this Yahoo page.
http://finance.yahoo.com/q/ks?s=pwe <http://finance.yahoo.com/q/ks?s=pwe&ql=1 > &ql=1
I cannot seem to get any of the element numbers to work in the rchgetelementnumber function.
I want to array enter this also for a list of symbols when the element number issue is resolved.
On Thu, Nov 15, 2012 at 12:01 PM, Dave Charlaff <davecharlaff@hotmail.com > wrote:
Thx Ron, I am using these element numbers but they return Error for me.
Any Thoughts as to why?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
Sent: Thursday, November 15, 2012 1:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] element numbers
RCHGetElementNumber()
966
942
981
Is that a setting in IE? Or Yahoo specific?
From: smf_addin@yahoogrou
Sent: Thursday, November 15, 2012 4:13 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] element numbers
I tried the element number Ron gave, and they work fine here. At least for PWE. You may get an error if you don't use US Regional settings.
You would NOT be able to array-enter a formula for the extraction from a web page -- there's no advantage to doing so. Individual formulas are just as fast. The array-entered advantage comes when web sites provide CSV files that can contain specificly requested data.
On Thu, Nov 15, 2012 at 11:12 AM, Dave Charlaff <davecharlaff@
I’m looking for the:
Total Debt(mrq)
Enterprise Value(latest)
Shares outstanding
From this Yahoo page.
http://finance.
I cannot seem to get any of the element numbers to work in the rchgetelementnumber function.
I want to array enter this also for a list of symbols when the element number issue is resolved.
On Thu, Nov 15, 2012 at 12:01 PM, Dave Charlaff <davecharlaff@
Thx Ron, I am using these element numbers but they return Error for me.
Any Thoughts as to why?
From: smf_addin@yahoogrou
Sent: Thursday, November 15, 2012 1:43 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] element numbers
RCHGetElementNumber
966
942
981
Thu Nov 15, 2012 2:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's an operating system setting...
If you're not located outside the U.S., it's probably not an issue.
On Thu, Nov 15, 2012 at 2:34 PM, Dave Charlaff <davecharlaff@hotmail.com >wrote:
>
> US Regional settings? I am unfamiliar with this.****
>
> ** **
>
> Is that a setting in IE? Or Yahoo specific?
>
If you're not located outside the U.S., it's probably not an issue.
On Thu, Nov 15, 2012 at 2:34 PM, Dave Charlaff <davecharlaff@
>
> US Regional settings? I am unfamiliar with this.****
>
> ** **
>
> Is that a setting in IE? Or Yahoo specific?
>
Tidak ada komentar:
Posting Komentar