The INFCODECONVERT() function

Starting from version v3.41.0 of all those functions will inherit some Real Time Data functions behavior. Thereby, the RTD throttle interval will impact every functions. For more information, please check the handling process of RTD throttling.

INFCODECONVERT() can be used to convert an instrument code, an ISIN or a Bloomberg code into a company code. It can be passed to INFGET() company_code argument.

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])

Parameter	Description
`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	Description
=INFCODECONVERT("LSE:VOD")	Converts an instrument code "LSE:VOD" in company code. Output: 21298EX
=INFCODECONVERT("GB00BH4HKS39";"ISIN";"COMPANY")	Converts an ISIN in company code. Output: 21298EX
=INFCODECONVERT("LSE:VOD";"INSTRUMENT";"COMPANY")	Converts an instrument code "LSE:VOD" in company code. Output: 21298EX
=INFCODECONVERT("VOD LN";"BLOOMBERG";"COMPANY")	Converts a Bloomberg code "VOD LN" in company code. Output: 21298EX