Analytics+ grouping options
Analytics+ supports different grouping options for the data. You can use the list below to find the code matching your desired grouping. See Parameters for analytics GraphQL API call for information how to use Analytics+ in GraphQL.
Code | Description |
|---|---|
PORTFOLIO | Grouped by parent portfolio. If the list of portfolios contained sub portfolios, those are grouped under the parent portfolio |
PORTFOLIO_ALL | Each portfolio separately |
PORTFOLIO_TYPE | Grouped by portfolio type |
PORTFOLIO_COUNTRY | Grouped by portfolio country |
PORTFOLIO_JURIDICAL | Grouped by portfolio juridical |
PORTFOLIO_CONTACT | Grouped by portfolio primary contact |
POSITION | Grouped by position. Each account is represented as an individual position regardless of currency. |
SECURITY | Grouped by position's security. Account balances are grouped as currency positions according to the account currency. Unlike with a portfolio and its position, there is no two-way relationship between a portfolio and a security, which should be kept in mind when using multi-level groupings. E.g. [PORTFOLIO, POSITION], [POSITION, PORTFOLIO] and [PORTFOLIO, SECURITY] are valid groupings while [SECURITY, PORTFOLIO] is not. |
LINKEDSECURITY | Grouped by position's security. If security has a linked security, position is grouped under the linked security. |
TYPE | Grouped by security type |
SUBTYPE | Grouped by security sub type |
BASETYPE | Grouped by security base type |
CLASS1 | Grouped by security class 1 |
CLASS2 | Grouped by security class 2 |
CLASS3 | Grouped by security class 3 |
CLASS4 | Grouped by security class 4 |
CLASS5 | Grouped by security class 5 |
COUNTRY | Grouped by security country |
CURRENCY | Grouped by security currency |
MARKETPLACE | Grouped by security market place |
SETTLEMENTPLACE | Grouped by security settlement place |
TAG | NOT SUPPORTED YET |
ISSUER | Grouped by security issuer |
GROUP | Grouped by group of a given allocation group. Allocation share is taken into account. |
SECTOR | Grouped by sector of a given allocation group. Allocation share is taken into account. |
ASSET_LIABILITY | All positions are of type ASSET, all cash accounts are also ASSET, non-cash accounts are LIABILITY |
ASSET_CATEGORY | All positions are of type ASSET, all accounts are grouped by account group, if it is missing, the type is OTHER |
DRILLDOWN_GROUP_SECURITY | Attaches underlying positions if a security has a linked portfolio, and groups them by security |
DRILLDOWN_GROUP_POSITION | Attaches underlying positions if a security has a linked portfolio, and groups them by position |