Sabtu, 17 Mei 2014

[smf_addin] Digest Number 3066

7 Messages

Digest #3066

Messages

Fri May 16, 2014 8:17 pm (PDT) . Posted by:

"Jacob Jose" pepecan47

Hi Randy - is there a way to get the data from dividend-history in an array?

Regards,
Jose L. Jacob

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, May 3, 2014 12:29:26 AM
Subject: Re: [smf_addin] Best Way to Get Info from Morningstar Dividend and Splits page

 
There are the static web pages that supply the data to that dynamic web page:

http://performance.morningstar.com/Performance/stock/split-history.action?t=XOM
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=XOM
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM

So, for example:

=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM",1,"<tbody","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM",2,"<tbody","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM",3,"<tbody","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM",4,"<tbody","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM",5,"<tbody","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM",6,"<tbody","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/split-history.action?t=XOM",1,"<tbody","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/split-history.action?t=XOM",2,"<tbody","<tr","<tr")

On Fri, May 2, 2014 at 8:50 PM, <tmallen2@bellsouth.net> wrote:

>I would like to start pulling some info from the Morningstar Dividend and Splits page. I recall you saying these were dynamic pages.
>This is the page for Exxon (XOM).
>http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=xom
>I would like to extract into Excel the Ex-Dividend date, Payable date, and the Dividend Amount.
>I would also like to get the most recent split history date and ratio.
>What would be a good formula to do this for each one? The view source does not seem to help me.
>

Fri May 16, 2014 8:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Possibly. But why would you want to?

On Fri, May 16, 2014 at 8:17 PM, Jacob Jose pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy - is there a way to get the data from dividend-history in an
> array?
>
>

Fri May 16, 2014 8:50 pm (PDT) . Posted by:

"Jacob Jose" pepecan47

I use RCHGetYahooHistory to get the dividends history and from there I do calculations of dividend growth, yields, etc.
 
I found that the info provided by Yahoo is not very reliable, I would like to use M* info instead. And M* provides ex-date, declared date, etc.

Regards,
Jose L. Jacob

________________________________
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 16, 2014 11:40:23 PM
Subject: Re: [smf_addin] Best Way to Get Info from Morningstar Dividend and Splits page

 
Possibly. But why would you want to?

On Fri, May 16, 2014 at 8:17 PM, Jacob Jose pepecan47@yahoo.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>Hi Randy - is there a way to get the data from dividend-history in an array?
>
>

Fri May 16, 2014 8:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can use the RCHGetHTMLTable() function:

=RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM","Record
Date",-1,"",1)

...but you'll have to live with they way it;s formatted in the table.

On Fri, May 16, 2014 at 8:50 PM, Jacob Jose pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I use RCHGetYahooHistory to get the dividends history and from there I do
> calculations of dividend growth, yields, etc.
>
> I found that the info provided by Yahoo is not very reliable, I would like
> to use M* info instead. And M* provides ex-date, declared date, etc.
>
>

Fri May 16, 2014 9:04 pm (PDT) . Posted by:

wildwolfie63

Is there a way for me to contact tom_richards54 trough his old email address in your files? Or could you contact him on my behalf to see if we could correspond in regards to WIT? Thank you for any help you can give me. You can give tom my direct email if that helps.

Fri May 16, 2014 9:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Go ahead and try to contact him with the email address in the message he
left. You know as much as I do from that message. I don't need to be
involved.

On Fri, May 16, 2014 at 9:04 PM, wwotursk@verizon.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there a way for me to contact tom_richards54 trough his old email
> address in your files? Or could you contact him on my behalf to see if we
> could correspond in regards to WIT? Thank you for any help you can give me.
> You can give tom my direct email if that helps.
>

Fri May 16, 2014 10:18 pm (PDT) . Posted by:

wildwolfie63

Is there anywhere I can obtain WIT prospector? I would like the regular version and the lite version. Thank you for any help you can give me. I have tried the links given but they seem extinct .
Diposting oleh EXCEL FEED LEARNING di 02.39

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)