Source System: Investier
Retrieve positional, transactional and performance data for your open ended funds at a Fund level housed in our SEI Data Warehouse. The data set returned includes the beginning and ending balances, contributions and withdrawals over the period, fees and profit and loss fields.
Fund Positions and Performance (1.0.0)
Download OpenAPI specification:Download
For more information on how to start using our APIs, please refer to the Getting Started guide.
Retrieve detailed information about fund positions, performance, and fees for specified funds and subfunds. The data includes balances, contributions, withdrawals, fees, profit and loss, and rates of return.
SEI's API products have various environments available depending on your stage of integration. The server URL should correspond with the environment of your application. Please refer to the Getting Started guide for a list of all environments and URLs.
Note For all Client applications, the Two-way TLS URL must be used. This is essential in order for the client server making API calls to establish a successful Two-Way SSL communication with SEI.
Single funds position for a specific As Of Date
Retrieves a single fund's position for a specific "As Of" date. The response includes the beginning and ending balances, contributions and withdrawals over the period, fees, and profit and loss. Both gross and net values are available. Where the fund has subfunds, data is represented at the subfund level.
Data Available:-
Beginning and ending balances
Contributions and withdrawals over the period
Fees
Profit and loss (both gross and net values)
Authorizations:
path Parameters
externalId required | string Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. |
query Parameters
asOfDate | string <date> As of business date of the reporting data in YYYY-MM-DD. |
startDate | string <date> The earliest date within a range in ISO 8601 format YYYY-MM-DD. |
endDate | string <date> The latest date within a range in ISO 8601 format YYYY-MM-DD. |
reportingPeriod | string Enum: "Closed" "Estimated" Identifies if the data is for 'closed' or 'estimated' reporting period based on how the fund may be administered by SEI. |
limit | integer Number of records per page. Many responses have a maximum of 50 records per page. |
header Parameters
category required | string Value: "OEF" This parameter identifies the category of the Funds the data is being requested for. Valid value for this is 'OEF' which is short for Open Ended Funds. |
Responses
Response samples
- 200
{- "data": [
- {
- "positions": {
- "fund": {
- "externalId": "FOFTEST",
- "currencyIsoCode": "USD ",
- "currencyIsoName": "US Dollar",
- "fiscalYearCode": "1231 ",
- "fiscalYearMonth": 12,
- "fiscalYearDay": 0,
- "links": [
- {
- "rel": "productMetadata",
}
]
}, - "reportingPeriod": "Closed",
- "ptdPnL": 1000000.1,
- "asOfDate": "2020-10-31T00:00:00",
- "beginningPeriod": {
- "navPerShare": 0,
- "netMarketValue": 200000000.55,
- "subscriptions": 1000000,
- "redemptions": -20000
}, - "endingPeriod": {
- "subscriptions": 0,
- "redemptions": 0,
- "navPerShare": 0,
- "netMarketValue": 210000000.55
}
}
}, - {
- "positions": {
- "fund": {
- "externalId": "FOFTEST",
- "subFund": {
- "externalId": "FOFTEST_SUB ",
- "currencyIsoCode": "USD ",
- "currencyIsoName": "US Dollar",
- "fiscalYearCode": "1231 ",
- "fiscalYearMonth": 12,
- "fiscalYearDay": 0,
- "links": [
- {
- "rel": "productMetadata",
}
]
}, - "links": [
- {
- "rel": "productMetadata",
}
]
}, - "reportingPeriod": "Closed",
- "ptdPnL": 600000.34,
- "asOfDate": "2020-10-31T00:00:00",
- "beginningPeriod": {
- "navPerShare": 200.12345678,
- "netMarketValue": 100000000.55,
- "subscriptions": 50000,
- "redemptions": -5170
}, - "endingPeriod": {
- "subscriptions": 0,
- "redemptions": 0,
- "navPerShare": 215.91234567,
- "netMarketValue": 123000000.26
}
}
}
], - "paging": {
- "totalCount": 100,
- "limit": 2,
}
}
Single funds net rate of return (ROR) for a specific As Of Date
Retrieves a single fund's net rate of return (ROR) for a specific "As Of" date. Detailed data points used to derive the ROR are included. Where the fund has subfunds, data is represented at the subfund level.
Data Available:-
Net rate of return
Gross rate of return (inclusive of fees)
Index values used to derive the rate of return
Authorizations:
path Parameters
externalId required | string Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. |
query Parameters
asOfDate | string <date> As of business date of the reporting data in YYYY-MM-DD. |
startDate | string <date> The earliest date within a range in ISO 8601 format YYYY-MM-DD. |
endDate | string <date> The latest date within a range in ISO 8601 format YYYY-MM-DD. |
reportingPeriod | string Enum: "Closed" "Estimated" Identifies if the data is for 'closed' or 'estimated' reporting period based on how the fund may be administered by SEI. |
limit | integer Number of records per page. Many responses have a maximum of 50 records per page. |
header Parameters
category required | string Value: "OEF" This parameter identifies the category of the Funds the data is being requested for. Valid value for this is 'OEF' which is short for Open Ended Funds. |
Responses
Response samples
- 200
{- "data": [
- {
- "performance": {
- "fund": {
- "externalId": "FOFTEST",
- "subFund": {
- "externalId": "FOFTEST_SUB2",
- "links": [
- {
- "rel": "productMetadata",
}
]
}, - "links": [
- {
- "rel": "productMetadata",
}
]
}, - "reportingPeriod": "Closed",
- "valuationDate": "2020-10-31T23:59:59",
- "indexValue": 100.4481764124558,
- "netRor": 0.577863333319979,
- "netOverGrossRor": 0.577863333319979,
- "netOverGrossIndex": 100.4481764124558,
- "grossOfPfeeRor": 0.583545490203116,
- "grossOfPfeeIndex": 100.4481764124558,
- "grossOfMfeeAndPfeeRor": 0.676874764086724,
- "grossOfMfeeAndPfeeIndex": 104.4342277197325,
- "grossFeesRor": 0.644399395222725,
- "grossFeeIndex": 105.4342277197325,
- "grossAdminFeeRor": 0.623399395222725,
- "grossAdminFeeIndex": 105.9562277197325,
- "dietzRor": 0.583545490203116,
- "dietzIndex": 100.4481764124558
}
}, - {
- "performance": {
- "fund": {
- "externalId": "FOFTEST",
- "subFund": {
- "externalId": "FOFTEST_SUB3",
- "links": [
- {
- "rel": "productMetadata",
}
]
}, - "links": [
- {
- "rel": "productMetadata",
}
]
}, - "reportingPeriod": "Closed",
- "valuationDate": "2020-10-31T23:59:59",
- "indexValue": 104.4481764124558,
- "netRor": 0.683545490203116,
- "netOverGrossRor": 0.677863333319979,
- "netOverGrossIndex": 104.4481764124558,
- "grossOfPfeeRor": 0.683545490203116,
- "grossOfPfeeIndex": 104.4481764124558,
- "grossOfMfeeAndPfeeRor": 0.776874764086724,
- "grossOfMfeeAndPfeeIndex": 108.4342277197325,
- "grossFeesRor": 0.744399395222725,
- "grossFeeIndex": 110.5989239065201,
- "grossAdminFeeRor": 0.723399395222725,
- "grossAdminFeeIndex": 111.9562277197325,
- "dietzRor": 0.683545490203116,
- "dietzIndex": 104.4481764124558
}
}
], - "paging": {
- "totalCount": 299,
- "limit": 2,
}
}
Single fund's fees for a specific As Of Date
Retrieves a single fund's fees for a specific "As Of" date.
Data Available:-
Management fees
Performance fees
Indirect fees
New issue income
Authorizations:
path Parameters
externalId required | string Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. |
query Parameters
asOfDate | string <date> As of business date of the reporting data in YYYY-MM-DD. |
endDate | string <date> The latest date within a range in ISO 8601 format YYYY-MM-DD. |
reportingPeriod | string Enum: "Closed" "Estimated" Identifies if the data is for 'closed' or 'estimated' reporting period based on how the fund may be administered by SEI. |
limit | integer Number of records per page. Many responses have a maximum of 50 records per page. |
header Parameters
category required | string Value: "OEF" This parameter identifies the category of the Funds the data is being requested for. Valid value for this is 'OEF' which is short for Open Ended Funds. |
investorExternalId | string Unique business identifier for the investor. |
Responses
Response samples
- 200
{- "data": [
- {
- "fees": {
- "investor": {
- "externalId": "450948680",
- "name": "Investment Company I",
- "links": [
- {
- "rel": "investorStandard",
}
]
}, - "fund": {
- "subFund": {
- "externalId": "FOFTEST_SUB"
}, - "externalId": "FOFTEST",
- "name": "FOF Ltd.",
- "links": [
- {
- "rel": "productMetadata",
}
]
}, - "asOfDate": "2018-06-30T00:00:00",
- "reportingPeriod": "Closed",
- "beginingPeriod": {
- "accruedManagementFee": 0,
- "allocatedManagementFee": 0,
- "accruedIndirectManagementFee": 2000.53,
- "allocatedPerformanceFee": 0,
- "accruedPerformanceFee": 0,
- "accruedIndirectPerformanceFee": 0
}, - "endingPeriod": {
- "accruedManagementFee": 0,
- "allocatedManagementFee": 0,
- "accruedIndirectManagementFee": 0,
- "allocatedPerformanceFee": 0,
- "accruedPerformanceFee": 0,
- "accruedIndirectPerformanceFee": 0
}, - "mtd": {
- "expensedManagementFee": 0,
- "paidManagementFee": 0,
- "expensedIndirectManagementFee": 1050.22,
- "paidIndirectManagementFee": 3400.59,
- "expensedJournalManagementFee": 0,
- "expensedPerformanceFee": 0,
- "paidPerformanceFee": 0,
- "expensedJournalPerformanceFee": 0,
- "expensedIndirectPerformanceFee": 0,
- "paidIndirectPerformanceFee": 0,
- "newIssueIncome": 0
}
}
}, - {
- "fees": {
- "investor": {
- "externalId": "450948680",
- "name": "Investment Company I",
- "links": [
- {
- "rel": "investorStandard",
}
]
}, - "fund": {
- "subFund": {
- "externalId": "FOFTEST_SUB"
}, - "externalId": "FOFTEST",
- "name": "FOF Ltd.",
- "links": [
- {
- "rel": "productMetadata",
}
]
}, - "asOfDate": "2018-07-31T00:00:00",
- "reportingPeriod": "Closed",
- "beginingPeriod": {
- "accruedManagementFee": 0,
- "allocatedManagementFee": 0,
- "accruedIndirectManagementFee": 0,
- "allocatedPerformanceFee": 0,
- "accruedPerformanceFee": 0,
- "accruedIndirectPerformanceFee": 0
}, - "endingPeriod": {
- "accruedManagementFee": 0,
- "allocatedManagementFee": 0,
- "accruedIndirectManagementFee": 850.48,
- "allocatedPerformanceFee": 0,
- "accruedPerformanceFee": 0,
- "accruedIndirectPerformanceFee": 0
}, - "mtd": {
- "expensedManagementFee": 0,
- "paidManagementFee": 0,
- "expensedIndirectManagementFee": 850.48,
- "paidIndirectManagementFee": 0,
- "expensedJournalManagementFee": 0,
- "expensedPerformanceFee": 0,
- "paidPerformanceFee": 0,
- "expensedJournalPerformanceFee": 0,
- "expensedIndirectPerformanceFee": 0,
- "paidIndirectPerformanceFee": 0,
- "newIssueIncome": 0
}
}
}
], - "paging": {
- "totalCount": 900,
- "limit": 2,
}
}