Symbol Search
Symbol Search finds the ticker for any of the 80,000+ stocks, ETFs, mutual funds, indices, commodities, FOREX pairs and cryptocurrencies we cover. Search by ticker or name on the web Symbol Search, in the Google Sheets add-on or in the Excel add-in. Every SheetsFinance function takes the symbol exactly as Symbol Search shows it.
Search by ticker or name
Results appear as you type, so there is no search button to press. Type a ticker such as AAPL, or part of a name such as "vanguard" when you don't know the ticker.
Order: an exact ticker match comes first, then tickers that start with what you typed, then matches on the name. Within those, larger and currently listed assets come before smaller and delisted ones.
Show more: results load 20 at a time. Click Show more for the next 20. The list stops at about 500 results, so narrow the search if you still can't see the symbol.
Before you type: Symbol Search opens on a short list of popular symbols, and shows how many symbols we cover in total.
Filter by type or exchange
Filters narrow a search, and they also work alone when you want to browse one kind of asset or one market.
Type: choose Stocks, ETFs, Funds, Indices, Commodities, Forex or Crypto under the search box. Choose the same type again, or All, to remove the filter.
Exchange: pick up to 10 exchanges from the exchange list. For what each exchange code means, see Available Markets.
Cryptocurrencies, FOREX pairs, indices and commodities belong to no stock exchange, so they show the exchange CRYPTO, FOREX, INDEX or COMMODITY.
Copy a symbol or a formula on the web
The web Symbol Search gives you the symbol and ready-made formulas to paste into your spreadsheet.
Copy the symbol: click the symbol in a result.
Copy a formula: click Formulas on a result to see formulas that suit that asset, such as its latest price, price history, income statement or ETF holdings. Click Copy next to one and paste it into Google Sheets or Excel.
Use Symbol Search in Google Sheets and Excel
The add-ons have the same search next to your spreadsheet. Select a result and its symbol goes into the Function Generator, ready to build a formula.
Google Sheets add-on: open Extensions > SheetsFinance > Symbol Search, or choose Symbol Search from the sidebar menu.
Excel add-in: open the SheetsFinance task pane from the Home ribbon and choose Symbol Search from its menu. The exchange list appears once the add-in is connected to your account.
If a symbol is missing
Check the spelling, try the company or fund name instead of the ticker, and remove any type or exchange filter. If it still doesn't appear on the web Symbol Search, click Tell us under the empty results. It opens our contact form with your search filled in, and we'll look into adding the symbol.
To check whether we cover a kind of asset at all, see Supported instruments.