google-sheetsgoogle-finance

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


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?


Solution

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