INFRONT.GETSELECTION function
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.
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
VB
|
| portfolio | The portfolios that are defined in the terminal can be selected via the side panel and can be used interactively. Example
VB
|
| 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
VB
|
| arbitrage list | For an instrument a list of all exchange specific quotations is returned. Example BE0974293251:EUR for AB Inbev quotation in EUR
VB
|
| 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
VB
|
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. |