Add financial data to a spreadsheet

""

Tips

Monitor stock prices or earnings per share with the GOOGLEFINANCE function in Google Sheets.

Then, graph seasonal fluctuations with Explore.

Examples

  • See revenue trends and changes.
  • Compare prices and earnings with major competitors.
  • Predict future stock trends and directions.

Use the GOOGLEFINANCE function""

  1. In Sheets, open a spreadsheet.
  2. In an empty cell, type =GOOGLEFINANCE.
  3. In parenthesis, add any of the following, separated by a comma:
    • A ticker symbol in quotation marks.
    • (Optional) The attribute you want to show, such as price, in quotation marks.
    • (Optional) A start and an end date preceded by DATE and followed with the numerical date in parenthesis.
    • (Optional) Daily or weekly frequency in quotation marks.
  4. Press Enter.

For example:

To list the Google stock price, taken at the same time daily for 2019, you type: =GOOGLEFINANCE("GOOG", "price", DATE(2019,1,1), DATE(2019,12,31), "DAILY")

Was this helpful?
How can we improve it?