[smf_addin] Digest Number 3002

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #3002

1a

Re: Help with this ticker symbol by "Randy Harmelink" rharmelink

2a

Re: Bulk Download of Ex-Dividend Dates by Frahman02

3a

Morningstar dynamic pages by "Jacob Jose" pepecan47

3b

Re: Morningstar dynamic pages by "Randy Harmelink" rharmelink

3c

Re: Morningstar dynamic pages by "Jacob Jose" pepecan47

3d

Re: Morningstar dynamic pages by "Randy Harmelink" rharmelink

Messages

1a

Re: Help with this ticker symbol

Tue Mar 11, 2014 2:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't like pulling it from the Yahoo page, because they tend to change
it's presentation often. Sometimes it varies before market open, during
market, and after market close. In any case, this works for me right now:

=smfConvertData(smfGetTagContent("
http://finance.yahoo.com/q?s=CIBCINDASIEP.TO&ql=1","span",-1,"yfs_l10"))

On Mon, Mar 10, 2014 at 6:13 PM, <namit98@yahoo.com> wrote:

>
> I need to pull this into excel
> http://finance.yahoo.com/q?s=CIBCINDASIEP.TO&ql=1
> Specifically I am looking to get the closing price.
>
> The "download data" file is empty.
>
> What would be the best way to accomplish this?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Re: Bulk Download of Ex-Dividend Dates

Tue Mar 11, 2014 4:46 pm (PDT) . Posted by:

Frahman02

Thanks Randy. Another member suggested I try Dividend.com, too. It looks like a great site that might update a little faster. It's good to know I can try putting more than one request at a time into some of those element numbers though.

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3a

Morningstar dynamic pages

Tue Mar 11, 2014 8:33 pm (PDT) . Posted by:

"Jacob Jose" pepecan47

Hi Randy - do you know what is the dynamic page to extract dividend information?
 
http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=GIS®ion=usa&culture=en-US&ownerCountry=USA

I am particulary interested on the heading:

Five Year Dividend History
 
Regards,
Jose L. Jacob

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3b

Re: Morningstar dynamic pages

Tue Mar 11, 2014 8:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Umm. That *is* the dynamic page. So I assume you want the static page? I
found out you can request the number of years of data. Here's the link for
25 years of GIS dividend history:

http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS

Or, if you just want five:

http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=GIS

On Tue, Mar 11, 2014 at 8:33 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> Hi Randy - do you know what is the dynamic page to extract dividend
> information?
>
>
> http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=GIS®ion=usa&culture=en-US&ownerCountry=USA
>
> I am particulary interested on the heading:
>
> Five Year Dividend History
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3c

Re: Morningstar dynamic pages

Tue Mar 11, 2014 9:03 pm (PDT) . Posted by:

"Jacob Jose" pepecan47

Hey Randy, this is amazing. Is there a way to get all this data as an array? I love the year end yield.
 
I used to get the dividend history from Yahoo, but I am fed up, too many errors and omissions. 
 
Regards,
Jose L. Jacob

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, March 11, 2014 11:53:28 PM
Subject: Re: [smf_addin] Morningstar dynamic pages

 
Umm. That *is* the dynamic page. So I assume you want the static page? I found out you can request the number of years of data. Here's the link for 25 years of GIS dividend history:

http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS

Or, if you just want five:

http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=GIS

On Tue, Mar 11, 2014 at 8:33 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
>Hi Randy - do you know what is the dynamic page to extract dividend information?
> 
>http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=GIS®ion=usa&culture=en-US&ownerCountry=USA
>
>I am particulary interested on the heading:
>
>Five Year Dividend History
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3d

Re: Morningstar dynamic pages

Tue Mar 11, 2014 9:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sure, either across a row:

=INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS
","",1,"",1,,6,26),6)

...or down a column:

=TRANSPOSE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS
","",1,"",1,,6,26),6))

On Tue, Mar 11, 2014 at 9:03 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> Hey Randy, this is amazing. Is there a way to get all this data as an
> array? I love the year end yield.
>
> I used to get the dividend history from Yahoo, but I am fed up, too many
> errors and omissions.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

Visit Your Group

• New Members 37

• Privacy • Unsubscribe • Terms of Use