I'm trying to figure out the cost basis of some stock that I sold last year and I can't quite get GoogleFinance to do what I want. The stock was purchased through a DRIP so there are about 5 shares that get added every quarter over a long period of time.
I have the settlement dates and number of shares but, before 2003, I don't have the purchase price. So, I'm trying to use the GoogleFinance function to figure out the price but if I write
=GoogleFinance("GOOG", "PRICE", 3/3/2000)
I get a 2x2 array rather than just the historical price. Is there any way to chain GoogleFinance into another function that would return just the value in the lower right cell?