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

google-sheets google-finance
user781486 picture user781486 · Mar 22, 2014 · Viewed 48.6k times · Source

I want to get the price of a stock at a particular date from Google Spreadsheet using Google Finance forumula. This is the formula I used;

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

It does not work. How can this be done?

Answer

makhan picture makhan · Mar 22, 2014

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)

Related questions

How to use GOOGLEFINANCE(("CURRENCY:EURAUD")) function

This function: GOOGLEFINANCE(("CURRENCY:EURAUD")) works well in Google Sheets, I have searched the web up and down for some documentation regarding this function and how it is used, the closest I've got was this http://www.google.com/finance?…

Read More
How to make google spreadsheet refresh itself every 1 minute?

My google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to refresh manually now. How can I make the spreadsheet refresh itself every 1 minute? Thank you for your help.

Read More
Google finance 200 day moving average is getting as #NA in Apps Script

I'm calculating Google finance 200 day moving average formula in google sheet using formula =average(query(sort(GoogleFinance("GOOG","price", TODAY()-320, TODAY()),1,0),"select Col2 limit 200")) Then in google app script I'm getting the above cell value in variable as below …

Read More