6 New Messages
Digest #2808
Messages
Sun Oct 13, 2013 7:07 am (PDT) . Posted by:
joelfp2000
Randy,
Thank you again for all of your work on this excel group! If I could figure out how to search previous posts I could probably answer my question, but I haven't mastered that yet.
How would I include the following yahoo page in my excel spreadsheet, not as a comment, but as a worksheet I can grab information from? Also, in your experience, does the information move around with each stock inquired about?
(http://finance.yahoo.com/q/bs?s=aapl+Balance+Sheet&annual)
Thanks!
Joel
Thank you again for all of your work on this excel group! If I could figure out how to search previous posts I could probably answer my question, but I haven't mastered that yet.
How would I include the following yahoo page in my excel spreadsheet, not as a comment, but as a worksheet I can grab information from? Also, in your experience, does the information move around with each stock inquired about?
(http://finance.
Thanks!
Joel
Sun Oct 13, 2013 9:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not quite sure what you're asking. Maybe this template will help:
RCHGetTableCell-Template-Yahoo-Balance-Sheet-Normal.xls
I think things can move around, depending on which line items are relevant
to the company. In fact, financial companies have almost all different line
items.
To search the messages, you just need to go to the group. The search bar at
the top of the page can be used to search conversations of the group.
On Sun, Oct 13, 2013 at 7:07 AM, <joel.andrews@lpl.com> wrote:
>
> Thank you again for all of your work on this excel group! If I could
> figure out how to search previous posts I could probably answer my
> question, but I haven't mastered that yet.
>
> How would I include the following yahoo page in my excel spreadsheet, not
> as a comment, but as a worksheet I can grab information from? Also, in
> your experience, does the information move around with each stock inquired
> about?
>
> (http://finance.yahoo.com/q/bs?s=aapl+Balance+Sheet&annual)
>
RCHGetTableCell-
I think things can move around, depending on which line items are relevant
to the company. In fact, financial companies have almost all different line
items.
To search the messages, you just need to go to the group. The search bar at
the top of the page can be used to search conversations of the group.
On Sun, Oct 13, 2013 at 7:07 AM, <joel.andrews@
>
> Thank you again for all of your work on this excel group! If I could
> figure out how to search previous posts I could probably answer my
> question, but I haven't mastered that yet.
>
> How would I include the following yahoo page in my excel spreadsheet, not
> as a comment, but as a worksheet I can grab information from? Also, in
> your experience, does the information move around with each stock inquired
> about?
>
> (http://finance.
>
Sun Oct 13, 2013 8:36 pm (PDT) . Posted by:
joelfp2000
Thanks Randy.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
I'm not quite sure what you're asking. Maybe this template will help:
RCHGetTableCell-Template-Yahoo-Balance-Sheet-Normal.xls
I think things can move around, depending on which line items are relevant to the company. In fact, financial companies have almost all different line items.
To search the messages, you just need to go to the group. The search bar at the top of the page can be used to search conversations of the group.
On Sun, Oct 13, 2013 at 7:07 AM, <joel.andrews@... mailto:joel.andrews@...> wrote:
Thank you again for all of your work on this excel group! If I could figure out how to search previous posts I could probably answer my question, but I haven't mastered that yet.
How would I include the following yahoo page in my excel spreadsheet, not as a comment, but as a worksheet I can grab information from? Also, in your experience, does the information move around with each stock inquired about?
(http://finance.yahoo.com/q/bs?s=aapl+Balance+Sheet&annual http://finance.yahoo.com/q/bs?s=aapl+Balance+Sheet&annual)
---In smf_addin@yahoogrou
I'm not quite sure what you're asking. Maybe this template will help:
RCHGetTableCell-
I think things can move around, depending on which line items are relevant to the company. In fact, financial companies have almost all different line items.
To search the messages, you just need to go to the group. The search bar at the top of the page can be used to search conversations of the group.
On Sun, Oct 13, 2013 at 7:07 AM, <joel.andrews@
Thank you again for all of your work on this excel group! If I could figure out how to search previous posts I could probably answer my question, but I haven't mastered that yet.
How would I include the following yahoo page in my excel spreadsheet, not as a comment, but as a worksheet I can grab information from? Also, in your experience, does the information move around with each stock inquired about?
(http://finance.
Sun Oct 13, 2013 7:12 am (PDT) . Posted by:
garyhartling
Try dividend.com, they usually separate out the regular and special dividends. They have premium info which requires a paid subscription but the basic dividend info is free.
--Gary H.
---In smf_addin@yahoogroups.com, <acetylator@...> wrote:
Hello all,
I am wondering whether anybody knows where one can get historical dividends for a selected company which distinguish special and regular dividends?
Currently, I use this source:
http://ichart.finance.yahoo.com/x?s=MO&a=01&b=01&c=1970&g=v&y=0&z=30000
to get dividend history, but special and regular dividends are mixed altogether, so for MO i get special dividend $51.06 for 2008.03.31 and $21.909 for 2007.04.02, which distort the whole statistics (I am trying to calculate number of consecutive years with increasing dividends). So I am looking for some source that would designate special and regular dividends so I can filter out the special ones.
Any suggestion from the honorable community? :-)
Thank you, Ace.
--Gary H.
---In smf_addin@yahoogrou
Hello all,
I am wondering whether anybody knows where one can get historical dividends for a selected company which distinguish special and regular dividends?
Currently, I use this source:
http://ichart.
to get dividend history, but special and regular dividends are mixed altogether, so for MO i get special dividend $51.06 for 2008.03.31 and $21.909 for 2007.04.02, which distort the whole statistics (I am trying to calculate number of consecutive years with increasing dividends). So I am looking for some source that would designate special and regular dividends so I can filter out the special ones.
Any suggestion from the honorable community? :-)
Thank you, Ace.
Sun Oct 13, 2013 5:16 pm (PDT) . Posted by:
option2z
Just an Attaboy for Randy here. I use the RSITargetPrices() function in my daily buy selection process, and actually send out the values calculated using this good tool in my daily TtP-S Alert Service. If you want to see the results of the calculation, all prior daily alerts are posted at http://TtP-S.com/
My toolset is shot through with the great stuff Randy produces; His works have helped produce excellent returns!
Pete A
---In smf_addin@yahoogroups.com, <dustinsmoak@...> wrote:
Curious if someone can tell me the parameters for this function?
My toolset is shot through with the great stuff Randy produces; His works have helped produce excellent returns!
Pete A
---In smf_addin@yahoogrou
Curious if someone can tell me the parameters for this function?
Sun Oct 13, 2013 8:56 pm (PDT) . Posted by:
joelfp2000
Randy,
I have two questions...and as always thanks for your help.
1.) I use the following formula to obtain the total assets of a stock, say "msft" that is located in cell c4.
=RCHGetTableCell("http://finance.yahoo.com/q/bs?s="&C4,1,"Total Assets")
What do I need to change in the formula to obtain an indented piece of information on the balance sheet, say Inventory which is a sub category of Current Assets?
2.) What change to the formula do I need to make to obtain the annual balance sheet instead of quarterly? I know I need to add an &annual but I can't figure out where to include it in the formula.
Thanks so much for your help!
Joel
I have two questions...
1.) I use the following formula to obtain the total assets of a stock, say "msft" that is located in cell c4.
=RCHGetTableCell(
What do I need to change in the formula to obtain an indented piece of information on the balance sheet, say Inventory which is a sub category of Current Assets?
2.) What change to the formula do I need to make to obtain the annual balance sheet instead of quarterly? I know I need to add an &annual but I can't figure out where to include it in the formula.
Thanks so much for your help!
Joel
Tidak ada komentar:
Posting Komentar