2 New Messages

Digest #2604

RCH get dividend amounts in a date range by "kien.tran07" kien.tran07

Re: RCH get dividend amounts in a date range by "Randy Harmelink" rharmelink

Messages

1a

RCH get dividend amounts in a date range

Sat May 4, 2013 10:21 am (PDT) . Posted by:

"kien.tran07" kien.tran07

Hi,

I have been searching this messages board but can't seem to find the exact topic I'm looking for. I apologize if this has been discussed before.

I am trying to use RCHGetYahooHistory() function to retrieve dividends paid between two dates.

For instance, I like to get total dividends paid for IVV between 8/18/04 and 1/5/05. The formula =RCHGetYahooHistory("IVV",2004,08,18,2005,01,05,"d",,,,)returns "date".

What am I doing wrong?

Thanks!
Kien

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

1b

Re: RCH get dividend amounts in a date range

Sat May 4, 2013 10:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to array-enter the function over a range...

If you just enter it into a single cell, you just get the first row and
first column of data returned.

On Sat, May 4, 2013 at 9:09 AM, kien.tran07 <kien.tran07@yahoo.com> wrote:

>
> I have been searching this messages board but can't seem to find the exact
> topic I'm looking for. I apologize if this has been discussed before.
>
> I am trying to use RCHGetYahooHistory() function to retrieve dividends
> paid between two dates.
>
> For instance, I like to get total dividends paid for IVV between 8/18/04
> and 1/5/05. The formula
> =RCHGetYahooHistory("IVV",2004,08,18,2005,01,05,"d",,,,)returns "date".
>
> What am I doing wrong?
>