Home/Formulas/Web/GOOGLEFINANCE
Webmedium

GOOGLEFINANCE()

Fetches current or historical securities information.

Syntax
fx
=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date], [interval])
Example
fx
=GOOGLEFINANCE("NASDAQ:AAPL", "price")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and GOOGLEFINANCE isn't one of them yet.