Returning a single cell from an array formula

Question

I would like to get a single value, the closing price, from this formula:

=GoogleFinance("NASDAQ:AAPL", "close", "12/13/2012",  1, 1)

Instead this formula populates 2 header rows (Date, Close) then two values (the date, and closing value $529.69). Is there a way to get just the closing value returned and placed in the formula's cell?

Answer 1

You can use the INDEX function:

=INDEX(GoogleFinance("NASDAQ:AAPL";"close";"12/13/2012";1;1);2;2)