Menu
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?
844
Use the "Historical Stock Price Values" tool on the MarketWatch website to find stock prices for a specific date. Enter the symbol of the stock, or a keyword for the company if you don't know the stock symbol, into the first box in the tool.
To pull historical stock data, in your GOOGLEFINANCE formula, enter a start date and an end date after the ticker and attribute, as shown in the formulas directly below. As you will see in the examples further below, when pulling historical data, Google Sheets will display two columns of data.
You can open https://www.google.com/finance/, search a ticker like GOOGL, and click the 'Historical prices' link on the left panel. You can use URLs like https://www.google.com/finance//historical?q=GOOGL to open pages with historical prices directly.
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) This API has undergone some changes and the updated solution that now works is like this -
=INDEX(GOOGLEFINANCE("GOOG","price",date(2015,12,13)),2,2) For more updates on the Google Finance API to be used in Google Docs please refer here
22
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
