TranslateCode
Entity codes have associated code types. The same entity code might be used in two or more different systems, for example StockExchange1 and StockExchange2. TranslateCode() translates an entity code to its equivalent in a different system.
Syntax
TranslateCode (Entity, Code Types, Headers, ShowError)
| Entity |
An entity is any element in the Quintessence database that has data associated with it and is identified by a code, for example, an instrument, portfolio, country or manager. Multiple entity codes are separated by commas.
|
| Code Types | The code type to use when translating the entity code. Multiple code types are separated by commas. |
| Headers | Whether to show headers. Possible values: column, row, both, none. |
| ShowError | If ShowError is set to TRUE, a standard Excel error message will be displayed if the function fails. |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Example 1. Single translation from one code type to another
Example 2. Multiple translations to multiple code types
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example 1. Single translation from one code type to another
| Function |
| =TranslateCode(“GB0000XYZ999”,”StockExchange1 Alpha Code “,”row”,TRUE) |
| Output | |
| GB0000XYZ999 | GTE |
Example 2. Multiple translations to multiple code types
| Function |
| =TranslateCode(“GTE,JWQ”,”SecuritiesIDNumber1, StockExchange1 Alpha Code, StockExchange2 Constituent Code, TradableIntrument1 Code”,”both”,TRUE) |
| Output | ||||
| SecuritiesIDNumber1 | StockExchange1 Alpha Code | StockExchange2 Constituent Code | TradableIntrument1 Code | |
| GTE | GB0000XYZ999 | GTE | C72222 | 100X |
| JWQ | GB0000XYZ111 | JWQ | C73333 | 100Z |