Messages In This Digest (2 Messages)

Messages

1a.: =RCHGetYahooHistory("IBM")

Posted by: "Joel" joel.andrews@lpl.com joelfp2000

Wed Dec 28, 2011 4:52 pm (PST)

Randy,

How do you set the formula up to retrieve the history for a given symbol which includes the date, adjusted closing price and volume only? I don't want to include the open price, close, etc. When I try various combinations using the array formula all I get are errors. Any help would be greatly appreciated!

Joel

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: =RCHGetYahooHistory("IBM")

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Dec 28, 2011 4:55 pm (PST)

Check the documentation. There's a parameter that allows you to specify
which output columns you want (i.e. "DAV").

On Wed, Dec 28, 2011 at 5:52 PM, Joel <joel.andrews@lpl.com> wrote:

>
> How do you set the formula up to retrieve the history for a given symbol
> which includes the date, adjusted closing price and volume only? I don't
> want to include the open price, close, etc. When I try various
> combinations using the array formula all I get are errors. Any help would
> be greatly appreciated!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)