PnL

pnl

GET

/pnl

Returns all the pnl related data points for a particular investment product within a date range and reporting period. The data points can be viewed for base or local values .

Prod:
https://api.seic.com/v1/investments/pnl
Query Parameters
Name Description Data Type Required
accountId

SEI Internal identifier for Account. Needs to be an individual value .

string

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

string

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountId

SEI Internal identifier for Account. Needs to be an individual value .

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...

PnL

pnl

GET

/pnl

Returns all the pnl related data points for a particular investment product within a date range and reporting period. The data points can be viewed for base or local values .

Prod:
https://api.seic.com/v1/investments/pnl
Query Parameters
Name Description Data Type Required
accountId

SEI Internal identifier for Account. Needs to be an individual value .

string

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

string

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountId

SEI Internal identifier for Account. Needs to be an individual value .

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...

Test: https://test.api.seic.com/v1/investments/pnl
TLS*: https://mtls.api.seic.com/v1/investments/pnl
*The TLS endpoint is only used if Server Based Application was selected during the App Registration process.

Pass the oAuth Token and the App key to invoke this endpoint for a particular application.

PnL

pnl

GET

/pnl

Returns all the pnl related data points for a particular investment product within a date range and reporting period. The data points can be viewed for base or local values .

Prod:
https://api.seic.com/v1/investments/pnl
Query Parameters
Name Description Data Type Required
accountId

SEI Internal identifier for Account. Needs to be an individual value .

string

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

string

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountId

SEI Internal identifier for Account. Needs to be an individual value .

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...

SAMPLE REQUEST

curl -X GET \
 https://api.seic.com/v1/investments/pnl?accountId=9999-1-20007&startDate=2017-01-01&endDate=2017-05-12&reportingPeriod=Closed \
-H 'appkey: gsedgaerhDSHGRSH' \ 
-H 'authorization: Bearer ADsgdnnkjnfdIKJN' \

 



REQUEST HEADER

Authorization: Bearer ADsgdnnkjnfdIKJN
AppKey: gsedgaerhDSHGRSH
RESPONSE HEADER

Content-Type: application/json 
Status: 200 OK 
requesttrackingid: 67e1ff68-164f-03ad-0f2d-5cbbfda56ec9


SAMPLE RESPONSE

{
	"data": [{
		"startDate": "2017-01-01T00:00:00",
		"endDate": "2017-05-12T00:00:00",
		"knowledgeDate": "2017-05-08T00:00:00",
		"account": {
			"id": "9999-1-20007",
			"externalId": null
		},
		"pnl": [{
			"investmentId": 127885,
			"base": {
				"currencyIsoCode": "USD",
				"adminFees": 0,
				"amortizedAccretion": 30850.94,
				"dividendExpense": null,
				"dividendIncome": 0,
				"fundExpense": 0,
				"interestExpense": 0,
				"interestIncome": 19597.23,
				"managementFees": null,
				"investmentIncome": 50448.17,
				"otherExpenses": 0,
				"otherIncome": 0,
				"pikIncome": 0,
				"swapExpense": null,
				"swapIncome": null,
				"totalExpense": 0,
				"totalGl": 86516.78,
				"totalInvestmentIncome": 50448.17,
				"totalPl": 86516.78,
				"totalRealized": 68053.15,
				"totalRUGL": 36068.61,
				"totalUnrealizedGl": -31984.54
			},
			"local": {
				"currencyIsoCode": "USD",
				"adminFees": 0,
				"amortizedAccretion": 30850.94,
				"dividendExpense": null,
				"dividendIncome": 0,
				"fundExpense": 0,
				"interestExpense": 0,
				"interestIncome": 19597.23,
				"managementFees": null,
				"investmentIncome": 50448.17,
				"otherExpenses": 0,
				"otherIncome": 0,
				"pikIncome": null,
				"swapExpense": null,
				"swapIncome": null,
				"totalExpense": 0,
				"totalGl": 86516.78,
				"totalInvestmentIncome": 50448.17,
				"totalRealized": 68053.15,
				"totalRUGL": 36068.61,
				"totalUnrealizedGl": -31984.54
			}
		}]
	}]
}
MODEL
Operations
Name Description Data Type (L)
base

Base currency of the account in which financial results are reported.

string
local

Local currency of the investment.

string
startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

boolean
endDate

The latest date within a range in ISO 8601 format YYYY-MM-DD.

string
knowledgeDate string
externalId

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.

string
investmentId

The SEI system identifier that represents the investment.

number
currencyIsoCode

The currency code in which the transaction is paid in.

string
adminFees

Any fund administration fee paid by the portfolio for the accounting period expressed in the base currency of the portfolio or the local curency.

string
amortizedAccretion

Amortized Accretion is the (base or local) currency value of appreciation/depreciation for the reporting period on a fixed income postion attributed to amortization

string
dividendExpense

Any expense incurred due to dividend payment against a security held short expressed in the base or local currency

string
dividendIncome

Any income incurred due to dividend payment against a security held long expressed in the base currency of the portfolio or the local currency

string
fundExpense string
interestExpense string
interestIncome

Income earned due to interest from the security held by the portfolio expressed in the base currency of the portfolio or the local currency

string
managementFees

Any management fee paid by the portfolio for the accounting period expressed in the base currency of the portfolio or the local currency

string
investmentIncome Investment Income for the period string
otherExpenses Other Expenses Inception for the period string
otherIncome

Miscellaneous income earned against the security that does not fall under any other category expressed in the base currency of the portfolio or the local currency

string
pikIncome string
swapExpense

Any expense incurred due to a swap position expressed in the base currency of the portfolio or the local currency.

string
swapIncome

Any income incurred due to a swap position expressed in the base currency of the portfolio or the local currency.

string
totalExpense

Total of all expense items for a position for the accounting period expressed in the base currency of the portfolio or the local currency.

string
totalGl string
totalInvestmentIncome

Total of all income items for a position for the accounting period expressed in the base currency of the portfolio or local currency.

string
totalPl string
totalUnrealizedGl

Unrealized Gain Loss Base is the (base or local currency) value of the Unrealized Mark to Market Gain/Losss for the position

string
id

SEI Accounting system generated identifier for each transaction in a batch

string


PnL

pnl

GET

/pnl

Returns all the pnl related data points for a particular investment product within a date range and reporting period. The data points can be viewed for base or local values .

Prod:
https://api.seic.com/v1/investments/pnl
Query Parameters
Name Description Data Type Required
accountId

SEI Internal identifier for Account. Needs to be an individual value .

string

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

string

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountId

SEI Internal identifier for Account. Needs to be an individual value .

startDate

startDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

endDate

endDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date. This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

reportingPeriod

The reporting period parameter accepts valid values Closed or Daily.

asOfDate

asOfDate in YYYY-MM-DD format. This can accept a date or English strings like " This is a conditional mandatory query parameter. Either [startDate&endDate] or [asOfDate] can be passed to this API.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...