Supported Markets


The Sheets Market Data add-on comes ready to use with many different markets. All you have to do to start using different market data is to use the format:

SYMBOL+EXTENSION

for the symbol argument in the add-on’s functions. You can also use this format when generating historical data sheets. You can find a reference for various stock market’s extensions below.

Note

When using international markets, the resulting data will use the market’s local currency.

Example

Say you wanted to look up the State Bank of India’s current market price. To do that, you would use the Sheets Market Data function STOCK_FUNDAMENTALS.

The STOCK_FUNDAMENTALS function takes two arguments: symbol and data.

To use international market symbols, you must use the format mentioned above. So, in this example the symbol argument would be SBIN.NS. SBIN is the symbol for the State Bank of India on the National Stock Exchange of India market which uses the NS extension in Sheets Market data (see the below reference table for more market extensions).

The data argument for current market price is regularMarketPrice.

Plugging these arguments into the function, you would insert the below into a cell in your spreadsheet.

=STOCK_FUNDAMENTALS("SBIN.NS", "regularMarketPrice")

This will return the current market price for the State Bank of India in the market’s local currency, which in this case is the Indian Rupee (INR).

Note

Sheets Market Data uses the same naming conventions as Yahoo! Finance. So, if you’re having problems trying to find the correct symbol for a particular stock, try searching for it on Yahoo! Finance. If you find it there, use the same symbol found there in the add-on.

For example, if trying to lookup information on E-mini Dow ($5) Futures for March 2019, search for it on Yahoo! Finance.

options-data

Then, once found, use that symbol in our add-on function.

options-data

Market Extensions Reference

Note: N/A means there is no extension and you can just use the stock’s symbol as is.

  • Chicago Board of Trade (CBOT) - .CBT
  • Chicago Mercantile Exchange (CME) - .CME
  • Dow Jones Indexes - N/A
  • Nasdaq Stock Exchange - N/A
  • ICE Futures US - .NYB
  • New York Commodities Exchange (COMEX) - .CMX
  • New York Mercantile Exchange (NYMEX) - .NYM
  • Options Price Reporting Authority (OPRA) - N/A
  • OTC Bulletin Board Market - N/A
  • OTC Markets Group N/A
  • S & P Indices - N/A
  • Buenos Aires Stock Exchange (BYMA) - .BA
  • Vienna Stock Exchange - .VI
  • Australian Stock Exchange (ASX) - .AX
  • Euronext Brussels - .BR
  • Sao Paolo Stock Exchange (BOVESPA) - .SA
  • Toronto Stock Exchange (TSX) - .TO
  • TSX Venture Exchange (TSXV) - .V
  • Santiago Stock Exchange - .SN
  • Shanghai Stock Exchange - .SS
  • Shenzhen Stock Exchange - .SZ
  • Prague Stock Exchange Index - .PR
  • Nasdaq OMX Copenhagen - .CO
  • Egyptian Exchange Index (EGID) - .CA
  • Nasdaq OMX Tallinn - .TL
  • Nasdaq OMX Helsinki - .HE
  • Euronext - .NX
  • Euronext Paris - .PA
  • Berlin Stock Exchange - .BE
  • Bremen Stock Exchange - .BM
  • Dusseldorf Stock Exchange - .DU
  • Frankfurt Stock Exchange - .F
  • Hamburg Stock Exchange - .HM
  • Hanover Stock Exchange - .HA
  • Munich Stock Exchange - .MU
  • Stuttgart Stock Exchange - .SG
  • Deutsche Boerse XETRA - .DE
  • Currency Rates - =X
  • Athens Stock Exchange (ATHEX) - .AT
  • Hong Kong Stock Exchange (HKEX) - .HK
  • Nasdaq OMX Iceland - .IC
  • Bombay Stock Exchange - .BO
  • National Stock Exchange of India - .NS
  • Indonesia Stock Exchange (IDX) - .JK
  • Euronext Dublin - .IR
  • Tel Aviv Stock Exchange - .TA
  • EuroTLX - .TI
  • Italian Stock Exchange - .MI
  • Nikkei Indices - N/A
  • Tokyo Stock Exchange - .T
  • Nasdaq OMX Riga - .RG
  • Nasdaq OMX Vilnius - .VS
  • Malaysian Stock Exchange - .KL
  • Mexico Stock Exchange (BMV) - .MX
  • Euronext Amsterdam - .AS
  • New Zealand Stock Exchange (NZX) - .NZ
  • Oslo Stock Exchange - .OL
  • Euronext Lisbon - .LS
  • Qatar Stock Exchange - .QA
  • Moscow Exchange (MOEX) - .ME
  • Singapore Stock Exchange (SGX) - .SI
  • Johannesburg Stock Exchange - .JO
  • Korea Stock Exchange - .KS
  • KOSDAQ - .KQ
  • Madrid SE C.A.T.S. - .MC
  • Saudi Stock Exchange (Tadawul) - .SAU
  • Nasdaq OMX Stockholm - .ST
  • Swiss Exchange (SIX) - .SW
  • Taiwan OTC Exchange - .TWO
  • Taiwan Stock Exchange (TWSE) - .TW
  • Stock Exchange of Thailand (SET) - .BK
  • Borsa İstanbul - .IS
  • FTSE Indices - N/A
  • London Stock Exchange - .L
  • London Stock Exchange - .IL
  • Caracas Stock Exchange - .CR

Indices

To get data on indices, rather than just a company, you should use the symbol for that index for the symbol argument in a function. Below is a list of some of the most common indexes you may want to use:

  • S&P 500: ^SPX
  • Russell 2000: ^RUT
  • Dow Jones Industrial Average: ^DJI
  • NASDAQ Composite: ^IXIC

Video Overview