Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

Thanks!

share|improve this question
add comment

3 Answers

up vote 1 down vote accepted

No, it is not possible. You can however just reference the lower right cell in another cell.

so if you got back from google: A1: "Date" B1: "Close" A2: "3/3/2000" B2: "55.22" A3: "Date" B3: "Close" A4: "3/4/2000" B4: "58.44"

Set cell C1 =B2 and cell C2 =B4 and the results will be: C1: 55.22 C2: 58.44

you could also put the query in one google doc and then reference it from another google doc if you really wanted to separete the data.

share|improve this answer
    
Thanks for the response. I think I'll have to do something like have sheet 2 contain all of the data and do a vlookup to get the price into sheet 1. It'll be a lot of wasted data because the purchases were made every quarter but the timing isn't consistent enough to use interval to only get the data I need. –  spinlock Apr 23 '11 at 18:50
1  
The answer from @tic is simpler than this one. –  Laizer Mar 5 '13 at 16:38
add comment

Use =INDEX(GoogleFinance("GOOG", "PRICE", "3/3/2000");2;2). Maybe you will need to close date between parenthesis.

share|improve this answer
    
This answer put me on the right track. The only issue was GOOG was not trading in 2000. So I just needed to amend the date. e.g "3/3/2010" Thanks @tic! –  user14654 Nov 7 '11 at 4:41
2  
this definitely works better then the chosen answer –  Damien Sep 21 '12 at 13:24
add comment

I found a hack that works here as well.
Use =min(GoogleFinance("Goog", "PRICE", "3/3/2000")).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.