Function reference /Web & finance data

Web & finance data

Pull data the sheet does not hold — stock prices, currencies — straight from Google.

• GOOGLEFINANCE

  Pulls stock prices and other market data from Google Finance into the sheet — the current price, or a table of past prices.