Type 'NASDAQ:FB' in the formula along with 'price' as the attribute. The ticker symbol for Facebook is 'FB' for NASDAQ, it will read 'NASDAQ:FB'. For example, you want to import the stock price or value of Facebook Inc. You can either Google it (for example, “ facebook ticker”) or use a tool such as Yahoo Finance. To assess your stock easily and observe its changes, GOOGLEFINANCE function takes your stock data directly from Google Finance to your Google Sheets.įirst, you will need to get the ticker symbols of the companies you are interested in to get your current stock value or price. People buy stocks for several purposes: trading, getting dividend income, etc.

Stocks represent a part of the company’s ownership and are traded on a stock exchange such as NASDAQ or through brokers. GOOGLEFINANCE function tutorial How to track stocks using GOOGLEFINANCE function Now let’s check out the power of GOOGLEFINANCE through other real-life examples.

'DAILY' is the interval (we can omit it in the formula).

In this formula example, we use GOOGLEFINANCE to import data about the stock price of Google back in 2014. Take a look at this basic example of how GOOGLEFINANCE function works: =GOOGLEFINANCE('GOOG','price','','', 'DAILY')

GOOGLEFINANCE function allows you to get daily data (use 'Daily' or '1') or weekly data (use 'Weekly' or '7').

'interval' is the parameter to specify the granularity of the imported data.

Alternatively, the end-date parameter can be specified as the number of days from the start-date.

Skip these parameters to return real-time data. The date should be represented in the format MM/DD/YYYY, for example '' or using one of the date-related functions, for example =DATE(yyyy,mm,dd).

'start-date' and 'end-date' represent a date span for collecting historical data.

Discover all GOOGLEFINANCE function attributes. By default, GOOGLEFINANCE function returns the 'price' attribute. For example, the 'currency' attribute denotes the currency in which the security ( 'ticker-symbol') is priced.

'attribute' is the parameter to specify the type of data about 'ticker-symbol' to import from Google Finance.

on the New York Stock Exchange 'USDEUR' is the ticker symbol for the exchange rate of the currency pair US dollar to Euro.Īll other parameters for the GOOGLEFINANCE function are optional: For example, 'NYSE:V' is the ticker symbol for Visa Inc.

'ticker-symbol' is an abbreviated name for traded securities such as stocks, shares, currency, etc.

GOOGLEFINANCE function attributes How to use GOOGLEFINANCE function in Sheets GOOGLEFINANCE syntaxĪccording to the Google official documentation, here is the GOOGLEFINANCE formula syntax: =GOOGLEFINANCE('ticker-symbol', 'attribute', 'start-date', 'end-date', 'interval')

Facebook beta yahoo finance.com