How to get the price of a stock at a particular date from Google Finance?

Question

I want to get the price of a particular stock at a particular date in Google Sheets using the Google Finance forumula.

I tried this formula:

=GOOGLEFINANCE("GOOG","price",12/13/2013)

But it didn't work.

How can this be done?

Answer 1

Just surround the date by quotation marks:

=GOOGLEFINANCE("GOOG","price","12/13/2013")

Also, if you want only the number, wrap it in INDEX formula

=INDEX(GOOGLEFINANCE("GOOG","price","12/13/2013"),2,2)