[smf_addin] Digest Number 3403

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3403

1a

Re: Analysis sheet if you want by jerry_mills

2a

TTM dividend using RCHGetYahooHistory by "Jose Jacob" pepecan47

2b

Re: TTM dividend using RCHGetYahooHistory by "Randy Harmelink" rharmelink

Messages

1a

Re: Analysis sheet if you want

Sat May 9, 2015 8:09 am (PDT) . Posted by:

jerry_mills

Won't load, says code needs to be updated for 64 bit system.

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

2a

TTM dividend using RCHGetYahooHistory

Sat May 9, 2015 8:21 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

I need some help. I am trying to get the TTM dividend for a stock, the dividend amount for the last 12 months.

For the 50 days MA I use

=AVERAGE(RCHGetYahooHistory(A3,,,,,,,,"A",0,1,,50,1))

Similarly, For the dividends in the last 4 periods I am trying

=SUM(RCHGetYahooHistory(A3,,,,,,,"v",0,1,,4,1))

but I get a result of 0.

Thank you very much.

Regards,
Jose L. Jacob

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

2b

Re: TTM dividend using RCHGetYahooHistory

Sat May 9, 2015 8:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your parameter values are not in the correct places -- try something like:

=SUM(INDEX(RCHGetYahooHistory(A3,,,,,,,"v",,0,,,4,2),,2))

...although that assumes it pays a quarterly dividend. To truly get TTM,
you should specify a starting date and ending date. For example, if the
ending date of the 12-month period is in cell A4:

=SUM(INDEX(RCHGetYahooHistory(A3,YEAR(A4)-1,MONTH(A4),DAY(A4),YEAR(A4),MONTH(A4),DAY(A4),"v",,0,,,20,2),,2))

On Sat, May 9, 2015 at 8:18 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I need some help. I am trying to get the TTM dividend for a stock, the
> dividend amount for the last 12 months.
>
> For the 50 days MA I use
>
> =AVERAGE(RCHGetYahooHistory(A3,,,,,,,,"A",0,1,,50,1))
>
>
> Similarly, For the dividends in the last 4 periods I am trying
>
> =SUM(RCHGetYahooHistory(A3,,,,,,,"v",0,1,,4,1))
>
> but I get a result of 0.
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 18

• Privacy • Unsubscribe • Terms of Use