Minggu, 10 Mei 2015

[smf_addin] Digest Number 3403

3 Messages

Digest #3403
2a
TTM dividend using RCHGetYahooHistory by "Jose Jacob" pepecan47
2b
Re: TTM dividend using RCHGetYahooHistory by "Randy Harmelink" rharmelink

Messages

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.

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

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.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar