GOOGLEFINANCE Function In Google Sheets

The GOOGLEFINANCE function is part of Google Sheets. Google Sheets is available in both consumer Gmail and organization-wide Google Workspace. The function allows users to create trend charts and comparisons for any assets that have a valid Google Finance ticker symbol.

Here are several examples of how the GOOGLEFINANCE function can be used in Google Sheets to compare the performance of stocks and indexes against one another.

GOOGLEFINANCE Function Examples

Facebook Stock Price vs Apple Stock Price in Sheets

Apple and Facebook are two well-known Silicon Valley technology companies. By creating a chart from two GOOGLEFINANCE functions, the relative performance can be easily seen. Here is a link to the Google Sheet. You can save it as a new Google Sheet, or save it as a Microsoft Excel file.

DJIA Trend vs. Max Close and Bear Line

It’s easy to chart a stock market index using the GOOGLEFINANCE function. More columns can be added to the spreadsheet to track performance against a target.

This chart shows the 2018/19 trend of the DJIA compared to the high water mark for the year. The chart includes a “bear line”, which is 20% below the 2018 maximum. The MAXA function was used for the top line. Here is a link to the Google Sheet.

MORE: 5 other business data sources to feed into Google Sheets

GOOGLEFINANCE Stock Attributes

With the use of simple formulas, the values of various stock attributes can be displayed in a Google Sheet. For the example below, we chose CRM, the ticker for Here is a link to the Google Sheet. You can save it as a new Google Sheet, or download it in a variety of formats, including .XLSX.


Fund attributes can be displayed in a Google Sheet in a similar manner. This information is for the Fidelity® Contrafund® Fund.

Google Workspace is like a "business version" of consumer Gmail

Learn About a Free Trial →

Join over 6 million businesses that are getting
everyone on the same page

This site includes affiliate links to and associate links to As an Amazon Associate, I earn from qualifying purchases.

Gmail™, Google Workspace™, Google Sheets™ , Google Docs™ , Google Slides™ , Google Meet™ , Google Drive™, and Google Sites™ are trademarks of Google LLC