Jumat, 01 Juni 2012

[smf_addin] Digest Number 2232[2 Attachments]

Messages In This Digest (11 Messages)

1a.
Re: element numbers From: NicholasDavid
1b.
Re: element numbers From: Randy Harmelink
2a.
Error in Formula From: Christina Guo
2b.
Re: Error in Formula From: Ron Spruell
2c.
Re: Error in Formula From: Christina Guo
2d.
Re: Error in Formula From: Randy Harmelink
2e.
Re: Error in Formula From: Christina Guo
2f.
Re: Error in Formula From: Ron Spruell
2g.
Re: Error in Formula From: Christina Guo
2h.
Re: Error in Formula From: Christina Guo
2i.
Re: Error in Formula [1 Attachment] From: Randy Harmelink

Messages

1a.

Re: element numbers

Posted by: "NicholasDavid" nicholasdavid@comcast.net   dnicholas4967

Thu May 31, 2012 8:51 am (PDT)



Where do I go to download the current "Elements Definitions" .....thanks!

----- Original Message -----
From: "Gordon" <gordonj5@aol.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Monday, May 28, 2012 1:48:04 PM
Subject: [smf_addin] element numbers

 

I looked at the elements definitions and I seen no change from previous.
I'm looking for the last price of a stock.
The element # should be 25 to bring this information in.
It doesn't.
Am I misinterpreting the information in element definitions or am I using the wrong formula.

Sorry that I can't seem to understand your answer about element definitions.

What replaces 25?
What replaces 30?
What replaces 31?

Thank you, Gordon Jones

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
1b.

Re: element numbers

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu May 31, 2012 9:21 am (PDT)



http://finance.groups.yahoo.com/group/smf_addin/message/18529

On Thu, May 31, 2012 at 8:51 AM, NicholasDavid <nicholasdavid@comcast.net>wrote:

>
> Where do I go to download the current "Elements Definitions" .....thanks!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2a.

Error in Formula

Posted by: "Christina Guo" cguo563@yahoo.com   cguo563

Thu May 31, 2012 12:05 pm (PDT)



Hi Randy,
 
I'm trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I looked at the templates, but they all displayed Error cellswhen I opened the worksheets.
 
I came up with this formula:
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"annual",1,">Revenue")
 
But I get Error.
 
This formula works:
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&E1,1,">Revenue")
 
But this won't let me look at other years?
 
Thanks so much!
 

 
Christina Guo
Harvard College 2013
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2b.

Re: Error in Formula

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Thu May 31, 2012 12:37 pm (PDT)



Try
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"annual",2,"Annual Data",,">Revenue")

For Revenue 

Change the Cell# to move to the other years, i.e., 3, 4.

>________________________________
> From: Christina Guo <cguo563@yahoo.com>
>To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
>Sent: Thursday, May 31, 2012 1:40 PM
>Subject: [smf_addin] Error in Formula
>
>
> 
>Hi Randy,
> 
>I'm trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I looked at the templates, but they all displayed Error cellswhen I opened the worksheets.
> 
>I came up with this formula:
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"annual",1,">Revenue")
> 
>But I get Error.
> 
>This formula works:
>=RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&E1,1,">Revenue")
> 
>But this won't let me look at other years?
> 
>Thanks so much!
> 
>
> 
>Christina Guo
>Harvard College 2013
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2c.

Re: Error in Formula

Posted by: "Christina Guo" cguo563@yahoo.com   cguo563

Thu May 31, 2012 1:01 pm (PDT)

[Attachment(s) from Christina Guo included below]

Thanks for the help, Ron. But it's still giving me Error for some reason. I've attached my Excel sheet here. Thank you so much for you help!
 
Christina
Harvard College 2013


________________________________
From: Ron Spruell <hashky@yahoo.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Thursday, May 31, 2012 12:37 PM
Subject: Re: [smf_addin] Error in Formula


 

Try
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"annual",2,"Annual Data",,">Revenue")
For Revenue 

Change the Cell# to move to the other years, i.e., 3, 4.

>________________________________
> From: Christina Guo <cguo563@yahoo.com>
>To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
>Sent: Thursday, May 31, 2012 1:40 PM
>Subject: [smf_addin] Error in Formula
>
>
> 
>Hi Randy,
>
>I'm trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I looked at the templates, but they all displayed Error cellswhen I opened the worksheets.
>
>I came up with this formula:
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"annual",1,">Revenue")
>
>But I get Error.
>
>This formula works:
>=RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&E1,1,">Revenue")
>
>But this won't let me look at other years?
>
>Thanks so much!
>
>
> 
>Christina Guo
>Harvard College 2013
>
>

Attachment(s) from Christina Guo

1 of 1 File(s)

With Add-in.xlsx
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2d.

Re: Error in Formula

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu May 31, 2012 1:18 pm (PDT)



You're getting errors because your URL is wrong. You're telling it to
concatenate "annual" directly to the ticker symbol, so instead of a ticker
symbol of MMM, you end up with MMMannual.

You need an additional ampersand directly in front of "annual", as part of
the literal.

Also, I don't see a line item defined by ">Revenue", at least for ticker
MMM. And the leading ">" only works if they code the web page that way.
Here, they don't.

And, as Ron noted, you need to vary the "1" parameter to look at additional
table cells following the search string. Check the documentation for the
function for more information.

Instead, try:

=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Total
Revenue")
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",2,"Total
Revenue")
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",3,"Total
Revenue")

On Thu, May 31, 2012 at 11:40 AM, Christina Guo <cguo563@yahoo.com> wrote:

>
> I'm trying to input Revenue and Net Income from YahooFinance for a list of
> 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I
> looked at the templates, but they all displayed Error cellswhen I opened
> the worksheets.
>
> I came up with this formula:
> =RCHGetTableCell("
> http://finance.yahoo.com/q/is?s="&A1&"annual",1,">Revenue")
>
> But I get Error.
>
> This formula works:
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&E1,1,">Revenue")
>
> But this won't let me look at other years?
>
> Thanks so much!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2e.

Re: Error in Formula

Posted by: "Christina Guo" cguo563@yahoo.com   cguo563

Thu May 31, 2012 1:33 pm (PDT)



Thank you so much, Randy! It works and I really appreciate it.
 
Just one last quick thing: How would I change the formula for Net Income? I tried replacing "Total Revenue" with "Net Income" but got Search in the cell.
 
Christina Guo
Harvard College 2013


________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, May 31, 2012 1:18 PM
Subject: Re: [smf_addin] Error in Formula


 

You're getting errors because your URL is wrong. You're telling it to concatenate "annual" directly to the ticker symbol, so instead of a ticker symbol of MMM, you end up with MMMannual.

You need an additional ampersand directly in front of "annual", as part of the literal.

Also, I don't see a line item defined by ">Revenue", at least for ticker MMM. And the leading ">" only works if they code the web page that way. Here, they don't.

And, as Ron noted, you need to vary the "1" parameter to look at additional table cells following the search string. Check the documentation for the function for more information.

Instead, try:

=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Total Revenue")
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",2,"Total Revenue")
=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",3,"Total Revenue")

On Thu, May 31, 2012 at 11:40 AM, Christina Guo <cguo563@yahoo.com> wrote:

 
>
>I'm trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I looked at the templates, but they all displayed Error cellswhen I opened the worksheets.
>
>I came up with this formula:
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s=%22&A1&%22annual%22,1,%22%3ERevenue")
>
>But I get Error.
>
>This formula works:
>=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=%22&E1,1,%22%3ERevenue")
>
>But this won't let me look at other years?
>
>Thanks so much!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2f.

Re: Error in Formula

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Thu May 31, 2012 1:59 pm (PDT)



You have to position the reference further down the page with something like "Other Items".  There are several "Net Incomes" on the page.

=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Other Items","Net Income")

>________________________________
> From: Christina Guo <cguo563@yahoo.com>
>To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
>Sent: Thursday, May 31, 2012 3:33 PM
>Subject: Re: [smf_addin] Error in Formula
>
>
> 
>Thank you so much, Randy! It works and I really appreciate it.
> 
>Just one last quick thing: How would I change the formula for Net Income? I tried replacing "Total Revenue" with "Net Income" but got Search in the cell.
> 
>Christina Guo
>Harvard College 2013
>
>From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, May 31, 2012 1:18 PM
>Subject: Re: [smf_addin] Error in Formula
>
>
> 
>You're getting errors because your URL is wrong. You're telling it to concatenate "annual" directly to the ticker symbol, so instead of a ticker symbol of MMM, you end up with MMMannual.
>
>You need an additional ampersand directly in front of "annual", as part of the literal.
>
>Also, I don't see a line item defined by ">Revenue", at least for ticker MMM. And the leading ">" only works if they code the web page that way. Here, they don't.
>
>And, as Ron noted, you need to vary the "1" parameter to look at additional table cells following the search string. Check the documentation for the function for more information.
>
>Instead, try:
>
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Total Revenue")
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",2,"Total Revenue")
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",3,"Total Revenue")
>
>
>On Thu, May 31, 2012 at 11:40 AM, Christina Guo <cguo563@yahoo.com> wrote:
>
> 
>>
>>I'm trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I looked at the templates, but they all displayed Error cellswhen I opened the worksheets.
>> 
>>I came up with this formula:
>>=RCHGetTableCell("http://finance.yahoo.com/q/is?s=%22&A1&%22annual%22,1,%22%3ERevenue")
>> 
>>But I get Error.
>> 
>>This formula works:
>>=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=%22&E1,1,%22%3ERevenue")
>> 
>>But this won't let me look at other years?
>> 
>>Thanks so much!
>>
>
>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2g.

Re: Error in Formula

Posted by: "Christina Guo" cguo563@yahoo.com   cguo563

Thu May 31, 2012 4:04 pm (PDT)



Great, thanks so much! Everything works.

________________________________
From: Ron Spruell <hashky@yahoo.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Thursday, May 31, 2012 1:59 PM
Subject: Re: [smf_addin] Error in Formula


 

You have to position the reference further down the page with something like "Other Items".  There are several "Net Incomes" on the page.

=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Other Items","Net Income")

>________________________________
> From: Christina Guo <cguo563@yahoo.com>
>To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
>Sent: Thursday, May 31, 2012 3:33 PM
>Subject: Re: [smf_addin] Error in Formula
>
>
> 
>Thank you so much, Randy! It works and I really appreciate it.
> 
>Just one last quick thing: How would I change the formula for Net Income? I tried replacing "Total Revenue" with "Net Income" but got Search in the cell.
>
>Christina Guo
>Harvard College 2013
>
>
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, May 31, 2012 1:18 PM
>Subject: Re: [smf_addin] Error in Formula
>
>
> 
>You're getting errors because your URL is wrong. You're telling it to concatenate "annual" directly to the ticker symbol, so instead of a ticker symbol of MMM, you end up with MMMannual.
>
>You need an additional ampersand directly in front of "annual", as part of the literal.
>
>Also, I don't see a line item defined by ">Revenue", at least for ticker MMM. And the leading ">" only works if they code the web page that way. Here, they don't.
>
>And, as Ron noted, you need to vary the "1" parameter to look at additional table cells following the search string. Check the documentation for the function for more information.
>
>Instead, try:
>
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Total Revenue")
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",2,"Total Revenue")
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",3,"Total Revenue")
>
>
>On Thu, May 31, 2012 at 11:40 AM, Christina Guo <cguo563@yahoo.com> wrote:
>
> 
>>
>>I'm trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I looked at the templates, but they all displayed Error cellswhen I opened the worksheets.
>>
>>I came up with this formula:
>>=RCHGetTableCell("http://finance.yahoo.com/q/is?s=%22&A1&%22annual%22,1,%22%3ERevenue")
>>
>>But I get Error.
>>
>>This formula works:
>>=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=%22&E1,1,%22%3ERevenue")
>>
>>But this won't let me look at other years?
>>
>>Thanks so much!
>>
>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2h.

Re: Error in Formula

Posted by: "Christina Guo" cguo563@yahoo.com   cguo563

Thu May 31, 2012 4:22 pm (PDT)

[Attachment(s) from Christina Guo included below]

Darn, I thought everything was running smoothly. But here's my spreadsheet once more. Do you know why the formula stopped working for the chunk of data from line 49-86?
 
Christina Guo
Harvard College 2013


________________________________
From: Ron Spruell <hashky@yahoo.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Thursday, May 31, 2012 1:59 PM
Subject: Re: [smf_addin] Error in Formula


 

You have to position the reference further down the page with something like "Other Items".  There are several "Net Incomes" on the page.

=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Other Items","Net Income")

>________________________________
> From: Christina Guo <cguo563@yahoo.com>
>To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
>Sent: Thursday, May 31, 2012 3:33 PM
>Subject: Re: [smf_addin] Error in Formula
>
>
> 
>Thank you so much, Randy! It works and I really appreciate it.
> 
>Just one last quick thing: How would I change the formula for Net Income? I tried replacing "Total Revenue" with "Net Income" but got Search in the cell.
>
>Christina Guo
>Harvard College 2013
>
>
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, May 31, 2012 1:18 PM
>Subject: Re: [smf_addin] Error in Formula
>
>
> 
>You're getting errors because your URL is wrong. You're telling it to concatenate "annual" directly to the ticker symbol, so instead of a ticker symbol of MMM, you end up with MMMannual.
>
>You need an additional ampersand directly in front of "annual", as part of the literal.
>
>Also, I don't see a line item defined by ">Revenue", at least for ticker MMM. And the leading ">" only works if they code the web page that way. Here, they don't.
>
>And, as Ron noted, you need to vary the "1" parameter to look at additional table cells following the search string. Check the documentation for the function for more information.
>
>Instead, try:
>
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",1,"Total Revenue")
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",2,"Total Revenue")
>=RCHGetTableCell("http://finance.yahoo.com/q/is?s="&A1&"&annual",3,"Total Revenue")
>
>
>On Thu, May 31, 2012 at 11:40 AM, Christina Guo <cguo563@yahoo.com> wrote:
>
> 
>>
>>I'm trying to input Revenue and Net Income from YahooFinance for a list of 100 companies for 2009, 2010, and 2011 into Excel usingRCHGetTableCell. I looked at the templates, but they all displayed Error cellswhen I opened the worksheets.
>>
>>I came up with this formula:
>>=RCHGetTableCell("http://finance.yahoo.com/q/is?s=%22&A1&%22annual%22,1,%22%3ERevenue")
>>
>>But I get Error.
>>
>>This formula works:
>>=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=%22&E1,1,%22%3ERevenue")
>>
>>But this won't let me look at other years?
>>
>>Thanks so much!
>>
>
>
>
>
>

Attachment(s) from Christina Guo

1 of 1 File(s)

With Add-in.xlsx
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2i.

Re: Error in Formula [1 Attachment]

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu May 31, 2012 4:36 pm (PDT)



Lines 49-86 worked fine here, except for those with bad ticker symbols.

On Thu, May 31, 2012 at 4:22 PM, Christina Guo <cguo563@yahoo.com> wrote:

>
> Darn, I thought everything was running smoothly. But here's my spreadsheet
> once more. Do you know why the formula stopped working for the chunk of
> data from line 49-86?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.25

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)