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?