INFALLLISTINGS() and INFINSTRUMENTSEARCH() functions

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.

linked with the Infront Professional Terminal can retrieve a list of instruments using 2 functions:

INFALLLISTINGS()
INFINSTRUMENTSEARCH()

INFINSTRUMENTSEARCH() retrieves the list of all instruments linked with the name / instrument code set in the parameter of the function.

INFALLLISTINGS() is based on the functionality "All listings" in Infront Professional Terminal. It retrieves the list of the instrument set in the parameter in all market places.

Warning

Some users may need to enable manually the Manager.IDP needed for these functions, by changing value to "NO" on the following registry key:

Computer\HKEY_CURRENT_USER\SOFTWARE\VB and VBA Program Settings\EfFull\Setting\EfDisableRTDPanel.

INFALLLISTINGS()

Syntax

CODE

= INFALLLISTINGS ("Instrument_code" or "ISIN","{Advanced parameters}")

Parameters

Parameter	Value	Definition
`Instrument_code` ISIN	LSE:VOD GB00BH4HKS39	Instrument code or ISIN are supported. To retrieve one, you can use the INFCODECONVERT() function.
Advanced Parameter	Value	Definition
`Instrument Type`	All Stock Bond Option...	The type of instrument you want to retrieve: All Stock Bond Option Future Commodity Index Forex Unknown Fund CFD Certificate Indicator Defaut : All
`OutputLayout`	All Code Name	Option to display columns or not depending on the value: All = code, name, ISIN, ticker, country… All the columns / information available. Name = code & company name. Code = only company codes. Default: All

INFINSTRUMENTSEARCH()

Syntax

CODE

= INFINSTRUMENTSEARCH ("Instrument_code" or "Name of the company","{Advanced parameters}")

Parameters

Parameter

Value

Definition

Instrument_code

Name of the company

LSE:VOD

Vodafone

Name or instrument code are supported.

To retrieve instruments codes, you can use the INFCODECONVERT() function. For more information, see INFCODECONVERT().

The Advanced Parameters are the same as the INFALLLISTINGS() function.

Demonstration

VB

= INFALLLISTINGS ("LSE:VOD","{'instrumentType':'Stock', 'OutputLayout':'All'}")

VB

= INFINSTRUMENTSEARCH("Vodafone","{'instrumentType':'Bond', 'OutputLayout':'All'}")