How to Track Stocks in Google Sheets

If you want to track the stocks and securities you care about, you can get both real-time and historical data in Google Sheets. Using a smart chip or built-in functionality, you'll always be up-to-date on what's happening with your favorite entities from Google Finance.

How to use Finance Smart Chip

Via Finance Smart Chip Entry In Google Sheets in early 2023, you can quickly get details on stocks, mutual funds, and currencies. The data you see comes from Google Finance.

1. Enter Indicator symbol In a cell in the leaf.
   
2. With the cell selected, do one of the following to insert the smart slide:
   - Specify Insert -> Smart Chips From the menu, choose Finance in the popup menu.
   – Right click on the cell, and go to Smart chips , and select Finance in the popup menu.
   
3. When Google selects the cursor and data, you'll see the smart chip in the cell.
4. Hover over the smart slide to view the financial data. The details you see depend on the entity type. For example, below you can see Amazon data that includes name, listing index, price, and market cap.
5. To learn more, click the icon. View details (Caught arrow) at the bottom right.
6. You will be directed to the company's page on Google Finance.

Remove Finance Smart Chip

If you want to remove a Finance Smart Chip you added to a cell, do one of two things:

• To remove the slide while keeping the cursor icon in the cell, right-click the cell, and go to Smart chips , and select “Remove the smart chip” in the popup menu.
  
• To remove both the slide and the symbol from a cell, select the cell and press the Delete key.

How to use the GOOGLEFINANCE function

If you want to get specific or historical data, use the GOOGLEFINANCE function in Google Sheets. When you use this formula, you'll also get data directly from Google Finance.

The formula syntax is GOOGLEFINANCE(symbol, attribute, startdate, enddate, interval), where only the first argument for the ticker symbol is required. Each argument must be enclosed in quotes.

Before we look at the examples, let's look at the arguments:

• Code: Google requires you to use both the exchange and ticker symbols to get the most accurate results. For example, you can enter “NASDAQ: AMZN.” If you use the ticker symbol “AMZN” Simply, Google will select an exchange for you. You can also use a cell reference for this parameter.
• Feature: This is the specific piece of data you want to get. The default is "the price" If left blank, there are currently over 40 attributes you can select, depending on whether you want real-time, historical, or shared mutual fund data. While we've featured some common attributes in our examples, you can view the full list at Google Docs Editors' Guide Page.
• Start_Date: For historical data, you can enter a start date. If you include the argument but exclude the next argument for “end_date” Then you will receive data for that specific day.
• Expiry date: For historical data, you can enter an end date or the number of days from the start date.
• Time interval: Also for historical data, you can enter: "daily" Or "weekly" To repeat the data. Alternatively, you can use the corresponding number 1 or 7, respectively.

Now that you know the formula structure of the function along with the arguments you can use, here are some examples of the GOOGLEFINANCE function.

Examples of Google Finance functions

Using the following formula, we get the current day's price of Amazon (AMZN). Remember that price is the default attribute if the argument is empty.

=GOOGLEFINANCE("NASDAQ:AMZN")

Using the following formula, we get the current 52-week high price of Amazon.

=GOOGLEFINANCE("NASDAQ:AMZN","HIGH52")

Now let's look at some historical data for Amazon. Using the following formula, we get the low price for January 1, 2020.

=GOOGLEFINANCE("NASDAQ:AMZN","LOW","1/1/2020")

In another example, we get the opening price with the same start date and end date of January 10, 2020.

=GOOGLEFINANCE("NASDAQ:AMZN","OPEN","1/1/2020","1/10/2020")

In this example, we get the closing price with the same start date, end date of June 1, 2020, and weekly interval.

=GOOGLEFINANCE("NASDAQ:AMZN","CLOSE","1/1/2020","6/1/2020","WEEKLY")

Note: The details you receive may be delayed by up to 20 minutes. For additional information, see Google Finance Disclaimer.

Frequently Asked Questions:

Q1: Is Google Finance shut down?
The answer: The Google Finance mobile app was removed from Google Play in 2015, and the Google Finance API is no longer available to users. However, the Google Finance website was redesigned and relaunched in 2020 with additional features, and the GOOGLEFINANCE functionality continues to provide financial data in Google Sheets.

Q2: What other types of financial functions does Google Sheets support?
The answer: You can do everything from calculating compound interest to a security's annual return as well as tracking stocks in Google Sheets.

For a complete list of financial functions, go to Google Sheets Jobs ListYou can leave the keyword field blank and select "financial" in the dropdown menu "Narrow enough" To view the entire list.

Q3: Does Microsoft Excel have a stock feature?
The answer: Subscribers can Microsoft 365 Use the Stocks data type.

Enter the cursor symbol in a cell, and go to the tab Data , and select "Stocks" In the Data Types section, select the correct entity in the sidebar that appears, then use the Insert Data button that appears next to the cell to insert the inventory data you want.

For historical data, you can also look at: STOCKHISTORY function in Excel.