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 five 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?