Array->Scalar Functions in Google Spreadsheets

Question

I'm using this:

=googlefinance("ukx","close","01/01/2012")

But it's frustratingly returning a 2x2 array with the value I need at location 2,2. I'm trying to just get that value returned (a scalar), but I can't figure out what function I need to grab that. Any tips?

Answer 1

The INDEX function (see reference) seems to do the trick:

=INDEX(googlefinance("ukx","close", "01/01/2012"); 2; 2)

returns 5696.7 (see example).