Fetches current or historical securities information from Google Finance. GOOGLEFINANCE("NASDAQ:GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY") GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY()) GOOGLEFINANCE(A2,A3) GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]) ticker - The ticker symbol for the security to consider. It’s mandatory to use both the exchange symbol and ticker symbol for accurate results and to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG.” If the exchange symbol is not specified, GOOGLEFINANCE will use its best judgement to choose one for you. Reuters Instrument Codes are no longer supported. Use TSE:123 or ASX:XYZ instead of ticker 123.TO or XYZ.AX. Not all futures are supported at this time. ticker - The ticker symbol for the security to consider. It’s mandatory to use both the exchange symbol and ticker symbol for accurate results and to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG.” If the exchange symbol is not specified, GOOGLEFINANCE will use its best judgement to choose one for you. If the exchange symbol is not specified, GOOGLEFINANCE will use its best judgement to choose one for you. Reuters Instrument Codes are no longer supported. Use TSE:123 or ASX:XYZ instead of ticker 123.TO or XYZ.AX. Reuters Instrument Codes are no longer supported. Use TSE:123 or ASX:XYZ instead of ticker 123.TO or XYZ.AX. Not all futures are supported at this time. Not all futures are supported at this time. attribute - [ OPTIONAL - "price" by default ] - The attribute to fetch about ticker from Google Finance and is required if a date is specified. attribute is one of the following for real-time data: "price" - Real-time price quote, delayed by up to 20 minutes. "priceopen" - The price as of market open. "high" - The current day's high price. "low" - The current day's low price. "volume" - The current day's trading volume. "marketcap" - The market capitalization of the stock. "tradetime" - The time of the last trade. "datadelay" - How far delayed the real-time data is. "volumeavg" - The average daily trading volume. "pe" - The price/earnings ratio. "eps" - The earnings per share. "high52" - The 52-week high price. "low52" - The 52-week low price. "change" - The price change since the previous trading day's close. "beta" - The beta value. "changepct" - The percentage change in price since the previous trading day's close. "closeyest" - The previous day's closing price. "shares" - The number of outstanding shares. "currency" - The currency in which the security is priced. Currencies don't have trading windows, so open , low , high , and volume won't return for this argument. attribute is one of the following for historical data: "open" - The opening price for the specified date(s). "close" - The closing price for the specified date(s). "high" - The high price for the specified date(s). "low" - The low price for the specified date(s). "volume" - The volume for the specified date(s). "all" - All of the above. attribute is one of the following for mutual fund data: "closeyest" - The previous day's closing price. "date" - The date at which the net asset value was reported. "returnytd" - The year-to-date return. "netassets" - The net assets. "change" - The change in the most recently reported net asset value and the one immediately prior. "changepct" - The percentage change in the net asset value. "yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number. "returnday" - One-day total return. "return1" - One-week total return. "return4" - Four-week total return. "return13" - Thirteen-week total return. "return52" - Fifty-two-week (annual) total return. "return156" - 156-week (3-year) total return. "return260" - 260-week (5-year) total return. "incomedividend" - The amount of the most recent cash distribution. "incomedividenddate" - The date of the most recent cash distribution. "capitalgain" - The amount of the most recent capital gain distribution. "morningstarrating" - The Morningstar "star" rating. "expenseratio" - The fund's expense ratio. attribute - [ OPTIONAL - "price" by default ] - The attribute to fetch about ticker from Google Finance and is required if a date is specified. attribute is one of the following for real-time data: "price" - Real-time price quote, delayed by up to 20 minutes. "priceopen" - The price as of market open. "high" - The current day's high price. "low" - The current day's low price. "volume" - The current day's trading volume. "marketcap" - The market capitalization of the stock. "tradetime" - The time of the last trade. "datadelay" - How far delayed the real-time data is. "volumeavg" - The average daily trading volume. "pe" - The price/earnings ratio. "eps" - The earnings per share. "high52" - The 52-week high price. "low52" - The 52-week low price. "change" - The price change since the previous trading day's close. "beta" - The beta value. "changepct" - The percentage change in price since the previous trading day's close. "closeyest" - The previous day's closing price. "shares" - The number of outstanding shares. "currency" - The currency in which the security is priced. Currencies don't have trading windows, so open , low , high , and volume won't return for this argument. attribute is one of the following for real-time data: "price" - Real-time price quote, delayed by up to 20 minutes. "price" - Real-time price quote, delayed by up to 20 minutes. "priceopen" - The price as of market open. "priceopen" - The price as of market open. "high" - The current day's high price. "high" - The current day's high price. "low" - The current day's low price. "low" - The current day's low price. "volume" - The current day's trading volume. "volume" - The current day's trading volume. "marketcap" - The market capitalization of the stock. "marketcap" - The market capitalization of the stock. "tradetime" - The time of the last trade. "tradetime" - The time of the last trade. "datadelay" - How far delayed the real-time data is. "datadelay" - How far delayed the real-time data is. "volumeavg" - The average daily trading volume. "volumeavg" - The average daily trading volume. "pe" - The price/earnings ratio. "pe" - The price/earnings ratio. "eps" - The earnings per share. "eps" - The earnings per share. "high52" - The 52-week high price. "high52" - The 52-week high price. "low52" - The 52-week low price. "low52" - The 52-week low price. "change" - The price change since the previous trading day's close. "change" - The price change since the previous trading day's close. "beta" - The beta value. "beta" - The beta value. "changepct" - The percentage change in price since the previous trading day's close. "changepct" - The percentage change in price since the previous trading day's close. "closeyest" - The previous day's closing price. "closeyest" - The previous day's closing price. "shares" - The number of outstanding shares. "shares" - The number of outstanding shares. "currency" - The currency in which the security is priced. Currencies don't have trading windows, so open , low , high , and volume won't return for this argument. "currency" - The currency in which the security is priced. Currencies don't have trading windows, so open , low , high , and volume won't return for this argument. attribute is one of the following for historical data: "open" - The opening price for the specified date(s). "close" - The closing price for the specified date(s). "high" - The high price for the specified date(s). "low" - The low price for the specified date(s). "volume" - The volume for the specified date(s). "all" - All of the above. attribute is one of the following for historical data: "open" - The opening price for the specified date(s). "open" - The opening price for the specified date(s). "close" - The closing price for the specified date(s). "close" - The closing price for the specified date(s). "high" - The high price for the specified date(s). "high" - The high price for the specified date(s). "low" - The low price for the specified date(s). "low" - The low price for the specified date(s). "volume" - The volume for the specified date(s). "volume" - The volume for the specified date(s). "all" - All of the above. "all" - All of the above. attribute is one of the following for mutual fund data: "closeyest" - The previous day's closing price. "date" - The date at which the net asset value was reported. "returnytd" - The year-to-date return. "netassets" - The net assets. "change" - The change in the most recently reported net asset value and the one immediately prior. "changepct" - The percentage change in the net asset value. "yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number. "returnday" - One-day total return. "return1" - One-week total return. "return4" - Four-week total return. "return13" - Thirteen-week total return. "return52" - Fifty-two-week (annual) total return. "return156" - 156-week (3-year) total return. "return260" - 260-week (5-year) total return. "incomedividend" - The amount of the most recent cash distribution. "incomedividenddate" - The date of the most recent cash distribution. "capitalgain" - The amount of the most recent capital gain distribution. "morningstarrating" - The Morningstar "star" rating. "expenseratio" - The fund's expense ratio. attribute is one of the following for mutual fund data: "closeyest" - The previous day's closing price.

"closeyest" - The previous day's closing price. "date" - The date at which the net asset value was reported. "date" - The date at which the net asset value was reported. "returnytd" - The year-to-date return. "returnytd" - The year-to-date return. "netassets" - The net assets. "netassets" - The net assets. "change" - The change in the most recently reported net asset value and the one immediately prior. "change" - The change in the most recently reported net asset value and the one immediately prior. "changepct" - The percentage change in the net asset value. "changepct" - The percentage change in the net asset value. "yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number. "yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number. "returnday" - One-day total return. "returnday" - One-day total return. "return1" - One-week total return. "return1" - One-week total return. "return4" - Four-week total return. "return4" - Four-week total return. "return13" - Thirteen-week total return. "return13" - Thirteen-week total return. "return52" - Fifty-two-week (annual) total return. "return52" - Fifty-two-week (annual) total return. "return156" - 156-week (3-year) total return. "return156" - 156-week (3-year) total return. "return260" - 260-week (5-year) total return. "return260" - 260-week (5-year) total return. "incomedividend" - The amount of the most recent cash distribution. "incomedividend" - The amount of the most recent cash distribution. "incomedividenddate" - The date of the most recent cash distribution. "incomedividenddate" - The date of the most recent cash distribution. "capitalgain" - The amount of the most recent capital gain distribution. "capitalgain" - The amount of the most recent capital gain distribution. "morningstarrating" - The Morningstar "star" rating. "morningstarrating" - The Morningstar "star" rating. "expenseratio" - The fund's expense ratio. "expenseratio" - The fund's expense ratio. start_date - [ OPTIONAL ] - The start date when fetching historical data. If start_date is specified but end_date|num_days is not, only the single day's data is returned. start_date - [ OPTIONAL ] - The start date when fetching historical data. If start_date is specified but end_date|num_days is not, only the single day's data is returned. end_date|num_days - [ OPTIONAL ] - The end date when fetching historical data, or the number of days from start_date for which to return data. end_date|num_days - [ OPTIONAL ] - The end date when fetching historical data, or the number of days from start_date for which to return data. interval - [ OPTIONAL ] - The frequency of returned data; either "DAILY" or "WEEKLY". interval can alternatively be specified as 1 or 7 . Other numeric values are disallowed. interval - [ OPTIONAL ] - The frequency of returned data; either "DAILY" or "WEEKLY". interval can alternatively be specified as 1 or 7 . Other numeric values are disallowed. Usage restrictions: The data is not for financial industry professional use or use by other professionals at non-financial firms (including government entities). Professional use may be subject to additional licensing fees from a third-party data provider. All parameters must be enclosed in quotation marks or be references to cells containing text. Important: A possible exception is when interval is specified as a number and when end_date|num_days is specified as a number of days. All parameters must be enclosed in quotation marks or be references to cells containing text. Important: A possible exception is when interval is specified as a number and when end_date|num_days is specified as a number of days. Real-time results will be returned as a value within a single cell. Historical data, even for a single day, will be returned as an expanded array with column headers. Real-time results will be returned as a value within a single cell. Historical data, even for a single day, will be returned as an expanded array with column headers. Some attributes may not yield results for all symbols. Some attributes may not yield results for all symbols. If any date parameters are specified, the request is considered historical and only the historical attributes are allowed. GOOGLEFINANCE is only available in English and does not support most international exchanges. GOOGLEFINANCE is only available in English and does not support most international exchanges. Historical data cannot be downloaded or accessed via the Sheets API or Apps Script. If you attempt to do so, you'll see a #N/A error in place of the values in the corresponding cells of your spreadsheet. Historical data cannot be downloaded or accessed via the Sheets API or Apps Script. If you attempt to do so, you'll see a #N/A error in place of the values in the corresponding cells of your spreadsheet. Quotes are not sourced from all markets and may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice. Quotes are not sourced from all markets and may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice. Google treats dates passed into GOOGLEFINANCE as as noon UTC time. Exchanges that close before that time may be shifted by a day. Google treats dates passed into GOOGLEFINANCE as as noon UTC time. Exchanges that close before that time may be shifted by a day. Important: Each example is in its own tab. Retrieves market information from Google Finance. Common attributes Historical market data Retrieves historical market information based on the specified dates from Google Finance. Common attributes for mutual funds. Currency exchange trends Creates a chart inside a cell to display the currency exchange trend during the last 30 days, using the retrieving result returns by GoogleFinance . Need more help? Try these next steps: Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.