Monitor stock prices or earnings per share with the GOOGLEFINANCE function in Google Sheets. Then, graph seasonal fluctuations with Explore. Examples
|
Use the GOOGLEFINANCE function
- In Sheets, open a spreadsheet.
- In an empty cell, type =GOOGLEFINANCE.
- 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.
- 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?
Get help from Small Business Advisors
Want to receive one-on-one guidance and tailored recommendations on how to make the most out of your Business Profile? Try booking an appointment with Small Business Advisors.
Important:This service cannot troubleshoot issues, including Business Profile verification or suspension, or Google Ads billing.