Portfolio - Portfolio Retrieval
Portfolio List
Lists the portfolios of a fund class, paginated, from the most recent date to the oldest.
| Profile | Host | Required permission |
|---|---|---|
| Manager | manager-api | Read |
| Consultant | consultant-api | View Compositions |
Base URL for each host: Environments (Hosts).
Request
Query Params
| Parameter | Description |
|---|---|
not_status | Filters the results, excluding compositions in the given status. |
status | Filters the results, returning only compositions in the given status. |
reference_date | Reference date for querying the compositions. Must be in the YYYY-MM-DD format. |
type | Portfolio type: pre_quota, final_quota or opening_quota. |
start_date | Start date of the search range. Required if end_date is given. Format: YYYY-MM-DD. |
end_date | End date of the search range. Required if start_date is given. Format: YYYY-MM-DD. |
page | Page to retrieve, starting at 0. Default: 0. |
limit | Items per page. Default: 20; maximum: 100. |
status and not_status accept more than one value (?status=pending_confirmation&status=confirmed). The possible statuses of a portfolio are created, pending_processing, pending_validation, pending_variation_reason, pending_quota_performance, pending_confirmation, confirmed, reproved, reproved_by_agent and reprocessed. The portfolio awaiting your approval is in pending_confirmation.
There are two ways to filter by date:
- A specific date, sending the
reference_datequery param. - A period, sending the
start_dateandend_datequery params (both together).
{
"data": [
{
"composition_key": "f2208257-1489-4937-8862-031bca34016f",
"status": "confirmed",
"composition_type": "pre_quota",
"composition_date": "2024-11-13",
"fund_class": {
"name": "A SAMPLE CLASS",
"fund_class_key": "5dac941c-c779-4049-a4ee-7cee583b6860",
"document_number": "11.222.333/0001-81"
}
},
{
"composition_key": "f2208257-1489-4937-8862-031bca34016f",
"status": "confirmed",
"composition_type": "final_quota",
"composition_date": "2024-11-13",
"fund_class": {
"name": "A SAMPLE CLASS",
"fund_class_key": "5dac941c-c779-4049-a4ee-7cee583b6860",
"document_number": "11.222.333/0001-81"
}
}
],
"limit": 20,
"page": 0,
"is_last_page": true
}
Paginated Object
| Field | Type | Description |
|---|---|---|
data | array | List of Composition objects |
limit | int | Limit of objects retrieved per page |
page | int | Number of the retrieved page |
is_last_page | boolean | Indicates whether the retrieved page is the last one |
Composition
| Field | Type | Description |
|---|---|---|
composition_key | string | Unique portfolio identification key |
status | string | The status of that portfolio |
composition_type | string | The type of that portfolio, pre_quota/final_quota |
composition_date | string | Reference date of the portfolio |
fund_class | object | Fund Class object |
Fund Class
| Field | Type | Description | Characters |
|---|---|---|---|
name | string | Fund class name | up to 255 |
fund_class_key | string | Unique fund class identification key | 36 |
document_number | string | Fund class CNPJ | - |
Portfolio Information
Returns the complete portfolio: issuance series, assets, receivables, payables, accounts and the status history.
| Profile | Host | Required permission |
|---|---|---|
| Manager | manager-api | Read |
| Consultant | consultant-api | View Compositions |
Base URL for each host: Environments (Hosts).
Request
{
"composition_key": "f2208257-1489-4937-8862-031bca34016f",
"status": "confirmed",
"composition_type": "pre_quota",
"composition_date": "2024-12-02",
"fund_class": {
"name": "A SAMPLE CLASS",
"fund_class_key": "5dac941c-c779-4049-a4ee-7cee583b6860",
"document_number": "11.222.333/0001-81"
},
"issuance_series": [
{
"issuance_serie_key": "840e01e9-0df8-4719-83c4-f10b839d8384",
"name": "SUBORDINADA - 1",
"gross_net_worth": 1891397.29,
"net_net_worth": 1891397.29,
"gross_quota_value": 1.76821576,
"net_quota_value": 1.76821576,
"number_of_quotas": 1069664.309518427,
"applied_value": 0.0,
"applied_quotas": 0.0,
"redeemed_value": 0.0,
"redeemed_quotas": 0.0,
"amortized_value": 0.0,
"tax_anticipated_value": 0.0,
"tax_anticipated_quotas": 0.0,
"profitabilities": [
{
"reference_date": "2024-11-29",
"quota_value": 1.76065188,
"di_benchmark_quota_value": 1.7613906,
"quota_percentage": 100.43,
"di_benchmark_percentage": 100.43,
"type": "monthly"
},
{
"reference_date": "2024-11-25",
"quota_value": 1.7568068,
"di_benchmark_quota_value": 1.76049545,
"quota_percentage": 99.79,
"di_benchmark_percentage": 100.0,
"type": "monthly"
},
{
"reference_date": "2024-11-01",
"quota_value": 1.74121452,
"di_benchmark_quota_value": 1.75502225,
"quota_percentage": 99.21,
"di_benchmark_percentage": 100.0,
"type": "monthly"
},
{
"reference_date": "2024-10-03",
"quota_value": 1.72167143,
"di_benchmark_quota_value": 1.75002091,
"quota_percentage": 98.38,
"di_benchmark_percentage": 100.0,
"type": "monthly"
},
{
"reference_date": "2024-09-03",
"quota_value": 1.70128747,
"di_benchmark_quota_value": 1.74445962,
"quota_percentage": 97.52,
"di_benchmark_percentage": 100.0,
"type": "monthly"
},
{
"reference_date": "2024-06-05",
"quota_value": 1.63380383,
"di_benchmark_quota_value": 1.7178922,
"quota_percentage": 95.1,
"di_benchmark_percentage": 100.0,
"type": "monthly"
},
{
"reference_date": "2023-12-08",
"quota_value": 1.52421994,
"di_benchmark_quota_value": 1.68553599,
"quota_percentage": 90.43,
"di_benchmark_percentage": 100.0,
"type": "daily"
}
]
}
],
"assets": [
{
"asset_key": "34f42521-f27f-424a-958f-8b53f15cc80d",
"asset_type": "fixed_income_fund_quota",
"purchase_date": "2024-11-27",
"total_purchase_value": 1009320,
"bad_debt_percentage": 0,
"bad_debt_value": 0,
"overdue_accounting_value": 0,
"current_accounting_value": 1234335,
"current_fair_accounting_value": 1234335
}
],
"consolidated_assets": [
{
"asset_type": "ccb",
"asset_category": "credit",
"total_units": 175623,
"bad_debt_value": 0,
"overdue_accounting_value": 75642,
"current_accounting_value": 187762590,
"current_fair_accounting_value": 187762590,
"post_maturity_interest_value": 0,
"delay_interest_value": 0,
"delay_fine_value": 0
}
],
"receivables": [
{
"origin_key": "a60f9226-edac-488e-9a58-6205a334e6ba",
"origin_type": "expense",
"description": "Taxa CVM - 2024",
"total_value": 711515,
"recognized_value": 654125,
"start_date": "2024-01-09",
"end_date": "2024-12-31",
"payment_date": "2024-05-10"
}
],
"payables": [
{
"origin_key": "19b83b17-d36c-4edd-97fe-99af6a0a4a63",
"origin_type": "expense",
"description": "Taxa de Gestão - 2024/12",
"total_value": 14586,
"recognized_value": 14586,
"start_date": "2024-12-02",
"end_date": "2024-12-31",
"payment_date": "2025-01-08"
}
],
"cash_accounts": [
{
"account_key": "a41e4fa8-6950-485e-9a5b-70f21cc6774a",
"balance": 100000,
"unconcilied_cash_in": 0,
"unconcilied_cash_out": 0,
"account_branch": "0001",
"account_digit": "1",
"account_number": "372832",
"accounting_identification": 1,
"financial_institution": {
"code": "329",
"ispb": "32402502",
"name": "QI Sociedade de Crédito Direto"
}
}
]
}
Complete Composition
| Field | Type | Description |
|---|---|---|
composition_key | string | Unique portfolio identification key |
status | string | The status of that portfolio |
composition_type | string | The type of that portfolio, pre_quota/final_quota |
composition_date | string | Reference date of the portfolio |
fund_class | object | Fund Class object |
issuance_series | array | List of Issuance Series objects |
assets | array | List of Assets objects |
consolidated_assets | array | List of Consolidated Assets objects |
receivables | array | List of Receivables objects |
payables | array | List of Payables objects |
cash_accounts | array | List of Cash Accounts objects |
status_events | array | Status history of the portfolio. See Status Events |
Issuance Serie
| Field | Type | Description |
|---|---|---|
issuance_serie_key | string | Unique issuance series identification key |
name | string | The name of that series |
gross_net_worth | float | Gross net worth of that series |
net_net_worth | float | Net worth of that series |
gross_quota_value | float | Gross quota value |
net_quota_value | float | Net quota value |
number_of_quotas | float | Total number of quotas |
applied_value | float | Total value applied in the period (optional) |
applied_quotas | float | Number of quotas applied in the period (optional) |
redeemed_value | float | Total value redeemed in the period (optional) |
redeemed_quotas | float | Number of quotas redeemed in the period (optional) |
amortized_value | float | Total value amortized in the period (optional) |
tax_anticipated_value | float | Anticipated tax value (optional) |
tax_anticipated_quotas | float | Number of quotas of the anticipated tax (optional) |
isin_code | string | ISIN code of the series (optional) |
profitabilities | array | List of Profitability objects |
Profitability
| Field | Type | Description |
|---|---|---|
reference_date | string | Reference date on which performance is analyzed |
quota_value | float | Series quota value on the reference date |
di_benchmark_quota_value | float | Quota value today if the reference quota ran at 100% of DI |
quota_percentage | float | Accumulated profitability of the quota in the period (%) |
di_benchmark_percentage | float | Accumulated profitability of the DI benchmark in the period (%) |
type | string | Type of the profitability period |
Assets
| Field | Type | Description |
|---|---|---|
asset_key | string | Unique asset identification key |
asset_type | string | Asset type |
purchase_date | string | Asset acquisition date |
total_purchase_value | string | Total asset acquisition value |
bad_debt_percentage | string | Applied PDD percentage |
bad_debt_value | integer | Total PDD value considered - Integer in cents |
overdue_accounting_value | integer | Asset overdue value - Integer in cents |
current_accounting_value | integer | Asset total value - Integer in cents |
current_fair_accounting_value | integer | Asset total value - Integer in cents |
Consolidated Assets
| Field | Type | Description |
|---|---|---|
asset_type | string | Asset type |
asset_category | string | Asset category |
total_units | integer | Total number of consolidated assets of this type |
bad_debt_value | integer | Total PDD value considered - Integer in cents |
overdue_accounting_value | integer | Asset overdue value - Integer in cents |
current_accounting_value | integer | Asset total value - Integer in cents |
current_fair_accounting_value | integer | Asset total fair value - Integer in cents |
post_maturity_interest_value | integer | Post-maturity interest - Integer in cents |
delay_interest_value | integer | Late-payment interest - Integer in cents |
delay_fine_value | integer | Late-payment fine - Integer in cents |
Receivables
| Field | Type | Description |
|---|---|---|
origin_key | string | Unique identification key of the resource that originates this receivable |
origin_type | string | Type of the resource that originates this receivable |
description | string | Item description |
total_value | float | Total receivable value |
recognized_value | float | Value already accrued |
start_date | string | Accrual start date |
end_date | string | Accrual end date |
payment_date | string | Settlement date |
Payables
| Field | Type | Description |
|---|---|---|
origin_key | string | Unique identification key of the resource that originates this payable |
origin_type | string | Type of the resource that originates this payable |
description | string | Item description |
total_value | float | Total payable value |
recognized_value | float | Value already accrued |
start_date | string | Accrual start date |
end_date | string | Accrual end date |
payment_date | string | Settlement date |
Cash Accounts
| Field | Type | Description |
|---|---|---|
account_key | string | Unique account identification key |
balance | integer | Account balance - Integer in cents |
unconcilied_cash_in | integer | Value of inflows to reconcile in this account - Integer in cents |
unconcilied_cash_out | integer | Value of outflows to reconcile in this account - Integer in cents |
account_branch | string | Account branch |
account_digit | string | Account digit |
account_number | string | Account number |
accounting_identification | integer | Accounting identifier of that account |
financial_institution | object | Financial Institution object |
account_data | object | Object with the account data (contains the same fields above) |
Financial Institution
| Field | Type | Description |
|---|---|---|
code | string | Financial institution COMPE code |
ispb | string | Financial institution ISPB |
name | string | Financial institution name |
Status Events
| Field | Type | Description |
|---|---|---|
status | string | Status assumed by the portfolio |
event_datetime | string | Date and time of the status change |
metadata | object | Data about the change, when available. On a rejection by the manager, contains the reproved_reason sent |
Errors
| Status | Code | When it happens |
|---|---|---|
| 400 | CMP000016 | Listing with only one of start_date and end_date. |
| 400 | CMP000017 | Listing with end_date earlier than start_date. |
| 400 | QIT000004 | The fund_class_key belongs to a class of another manager. |
| 400 | QIT000010 | Invalid query parameter: limit above 100, negative page or reference_date not in YYYY-MM-DD. |
| 404 | CMP000001 | There is no class with this fund_class_key. |
| 404 | CMP000012 | Query of a composition_key that does not exist in the given class. |
Authentication, permission and host errors: see API Errors.