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, currency, strike price and expiration date are also available. The search result will be shown with its symbol ID, allowing the user 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:
=RTD("ProfRTD";;"Lookup";"Microsoft,NASDAQ")
▪ The 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:
=RTD("ProfRTD";;"Live";A1&",Last")
▪ 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 symbol IDs with RTD:
=RTD("ProfRTD";;"Lookup";"<Identifier>, [<Exchange>, <SymbolType>, <Currency>, <Strike>, <Expiration>, <Options>])
All parameters except Identifier are optional. If you want to skip a parameter, just add the comma, but leave out the value, for example:
=RTD("profrtd";;"Lookup";"FDAX,Eurex,,,,122011")
Note The character you have to use for separating the different arguments of the RTD function (shown as a semicolon ; above) depends on the regional configuration of your operating system. Under Windows, you can change this configuration in the Control Panel.
|
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 symbol. |
|
Exchange |
Name of the exchange on which you want to search. For a list of exchange names, see Available Exchange Names. |
|
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). |
Tips and Examples for Looking Up
Symbols
Symbol Syntax for Securities,
Forwards and Continuous Contracts