2 Messages

Digest #3574

get dividend per share for ETF and Closed end funds by jrwbob

Re: get dividend per share for ETF and Closed end funds by "Randy Harmelink" rharmelink

Messages

1a

get dividend per share for ETF and Closed end funds

Fri Dec 4, 2015 6:49 am (PST) . Posted by:

jrwbob

Hi Randy
the =RCHGetElementNumber("MMM";,4924) add in works for most cases except with traded closed end funds
is there another parameter to get this data for dividend per share?

thank you
Jerry

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

1b

Re: get dividend per share for ETF and Closed end funds

Fri Dec 4, 2015 1:12 pm (PST) . Posted by:

Element #4924 comes from the Yahoo Key Statistics web page, so it won't
exist for equities where Yahoo doesn't produce that web page. And they
don't for ETFs.

I don't think there is an element # for dividend amount for ETFs. I'm not
sure a forward dividend amount even makes sense for an ETF since it would
be paid on the holdings of the ETF, and not something that is "fixed" in
any sense of the word.

On Fri, Dec 4, 2015 at 7:49 AM, jrwbob@... wrote:

>
> the =RCHGetElementNumber("MMM";,4924) add in works for most cases except
> with traded closed end funds
>
> is there another parameter to get this data for dividend per share?
>
>
>