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