The INFCODECONVERT() Function
INFCODECONVERT() can be used to convert an Instrument Code into a Company Code. It can be passed to INFGET() company_code argument.
Note: none of the arguments is case sensitive. You can get help on the function in Excel by hitting SHIFT + F3
Syntax
|
INFCODECONVERT(Code,[Source_type], [Dest_type]) |
|
|
Code |
input code to be converted |
|
Source_type |
type of input code as a keyword. Default is Instrument (for Infront Instrument Code) |
|
Dest_type |
type of output code as a keyword. Default is Company (for Infront Company Code) |
| Keyword | Description |
| Instrument | Infront Instrument Code |
| Company | Infront Company Code |
| Isin | ISIN |
| Ticker | Ticker |
| Company name |
Infront Company Name |
| Bloomberg |
Bloomberg Code |
Examples
|
Code |
=INFCODECONVERT("LSE:VOD") |
|
Description |
Converts an Instrument Code "LSE:VOD" in Company Code. Output: 21298EX |
|
Code |
=INFCODECONVERT("GB00BH4HKS39";"ISIN";"COMPANY") |
|
Description |
Converts an ISIN in Company Code. Output: 21298EX |
|
Code |
=INFCODECONVERT("LSE:VOD";"INSTRUMENT";"COMPANY") |
|
Description |
Converts an Instrument Code "LSE:VOD" in Company Code. Output: 21298EX |
