You can search for symbol IDs that are needed in other RTD formulas by using the symbol's ISIN, WKN, ticker or name. Additional search options like exchange name, strike price and expiration date are also available. The search result will be shown with its symbol ID, allowing you to reference the ID in other RTD requests (cell references).

▪       Open a Microsoft Excel spreadsheet.

▪       In the cell where you want the symbol ID to appear, type (or copy) the following formula:

▪       The TeleTrader symbol ID of the Microsoft stock on NASDAQ ( {829802} ) will be shown in the cell. If there is more than one search result, the number of results will be shown and you will need to refine your search.

▪       You can now use this symbol ID in another RTD formula using cell references. This means that you use the name of the Excel cell (e.g. A1) instead of the symbol ID for retrieving quote data, for example:

▪       The request above will fetch the current Last price of the Microsoft stock on NASDAQ.

In a Microsoft Excel spreadsheet, use the following syntax to look up TeleTrader symbol IDs with RTD:

All parameters except Identifier are optional. If you want to skip a parameter, just add the comma, but leave out the value, for example:

Identifier	The name, ticker, ISIN or local ID (for example WKN) of a security. This is used as the search term for looking up the TeleTrader symbol.
Exchange	Name of the exchange on which you want to search.
SymbolType	Type of symbol that you want to search for. The following types are available: Stock Future Index Currency Warrant Bond Mutual Fund Interest Rate Option Put Option Call Option Certificate
Currency	ISO code of the currency (for example EUR).
Strike	Strike price for options as a number.
Expiration	Expiration date (month/year) for options and futures in the format MMYYYY.
Options	Search options to control the search result. Currently two options are available: EXACT                      Only symbols whose ticker, name or ISIN match your search term (Identifier) exactly will be part of the search result. This option is useful when you use short tickers, for example F. SHOW          The first returned symbol that matches your search term exactly will be shown as the result.  This option is useful when you want to show a symbol ID in any case for the search result (instead of the message informing you that more than one symbol has been found).

Look up an ISIN on Xetra:

Look up the Ford ticker on NYSE – here, you should use the option EXACT to get a result immediately:

Sometimes you have to refine your search based on the results that you get. The following example shows using this method  when looking for an options contract (search result is shown in red below – in Microsoft Excel, the search result will be shown in the same cell where you enter the formula).

Look up an option on Eurex, using the option's ISIN and type:

Add the strike price:

Add the expiration date – this finally returns the TeleTrader symbol ID: