The INFRONT.GETSELECTION function allows to retrieve dynamic selections from your terminal (watchlist, portfolio) or other dynamic lists eg index constituents, arbitrage list, index membership. This is a one time update when the function is updated by Excel, selection changes done for example in the terminal require a simple refresh on Excel side.
In the cell where the function is called a name will appear for the selection. The selection itself is spilled in the cells directly below and this can possibly override any content in these cells.
Function syntax
INFRONT.GETSELECTION ( <selection type>, <identifier>)
Parameters
Selection type
Different selection types are possible.
|
Identifier |
Description & example |
|---|---|
|
watchlist |
The watchlists that are defined in the terminal can be selected via the side panel and can be used interactively. Example
Visual Basic
|
|
portfolio |
The portfolios that are defined in the terminal can be selected via the side panel and can be used interactively. Example
Visual Basic
|
|
index constituents |
For an index the list of index constituents can be dynamically retrieved. If the index is updated this list will follow automatically. Example Visual Basic
|
|
arbitrage list |
For an instrument a list of all exchange specific quotations is returned. Example BE0974293251:EUR for AB Inbev quotation in EUR Visual Basic
|
|
index membership |
For an instrument a list indices is returned to which this instrument belongs. Example BE0974293251:XBRU:EUR for AB Inbev quotation on Euronext Brussels in EUR Visual Basic
|
Identifier
The type of the identifier is depending on the selection type.
|
Selection type |
Supported identifiers |
|---|---|
|
watchlist |
numerical watchlist id |
|
portfolio |
numerical portfolio id |
|
index constituents, arbitrage list, index membership |
See Instrument selection for the INFRONT.GETFIELD function. Same identifiers are supported. |