Taxlots

ApiV1PortfolioByExternalIdTaxlotsGet

GET

/{externalId}/taxlots

Prod:
https://api.seic.com/v1/portfolio/{externalId}/taxlots
Query Parameters
Name Description Data Type Required
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

string

accountId

SEI unique system ID that represents the account

string

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

string

startDate

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

string

endDate

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

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

integer

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

Path Parameters
Name Description Data Type Required
externalId

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
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

accountId

SEI unique system ID that represents the account

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

startDate

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

endDate

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

limit

Number of records per page. Many responses have a maximum of 50 records per page.

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

externalId null true

HTTP Basic

OAuth 2.0

API Key

Working...

Taxlots

ApiV1PortfolioByExternalIdTaxlotsGet

GET

/{externalId}/taxlots

Prod:
https://api.seic.com/v1/portfolio/{externalId}/taxlots
Query Parameters
Name Description Data Type Required
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

string

accountId

SEI unique system ID that represents the account

string

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

string

startDate

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

string

endDate

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

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

integer

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

Path Parameters
Name Description Data Type Required
externalId

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
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

accountId

SEI unique system ID that represents the account

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

startDate

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

endDate

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

limit

Number of records per page. Many responses have a maximum of 50 records per page.

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

externalId null true

HTTP Basic

OAuth 2.0

API Key

Working...

Test: https://test.api.seic.com/v1/portfolio/{externalId}/taxlots
TLS*: https://mtls.api.seic.com/v1/portfolio/{externalId}/taxlots
*The TLS endpoint is only used if Server Based Application was selected during the App Registration process.
STEP 2

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

Taxlots

ApiV1PortfolioByExternalIdTaxlotsGet

GET

/{externalId}/taxlots

Prod:
https://api.seic.com/v1/portfolio/{externalId}/taxlots
Query Parameters
Name Description Data Type Required
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

string

accountId

SEI unique system ID that represents the account

string

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

string

startDate

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

string

endDate

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

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

integer

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

Path Parameters
Name Description Data Type Required
externalId

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
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

accountId

SEI unique system ID that represents the account

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

startDate

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

endDate

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

limit

Number of records per page. Many responses have a maximum of 50 records per page.

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

externalId null true

HTTP Basic

OAuth 2.0

API Key

Working...

SAMPLE REQUEST

curl --location --request GET 'https://api.seic.com/v1/portfolio/1007-1-01360/taxlots?asOfDate=2017-01-01&reportingPeriod=Daily' \
--header 'Authorization: Bearer bWxJMh9fkAg6qk9HmGrSSaBRqyxy' \
--header 'AppKey: fNn8uvl8PmLSZ80PbAQ9TLr7hKW0sCIG'


REQUEST HEADER

Authorization: Bearer bWxJMh9fkAg6qk9HmGrSSaBRqyxy
AppKey: fNn8uvl8PmLSZ80PbAQ9TLr7hKW0sCIG
RESPONSE HEADER

Content-Type: application/json 
Status: 200 OK 
requesttrackingid: dfcaaf16-daf3-9e11-9d24-2da9e5f2afc7


SAMPLE RESPONSE

{
    "data": {
        "product": {
            "externalId": "1000-1-01230",
            "accountId": "1000-1-01230",
            "name": "AD87ECE62 154B6 0CB 2B26 8B5",
            "lotsCount": 2595
        },
        "asOfDate": "2017-01-01T00:00:00",
        "startDate": "2017-01-01T00:00:00",
        "endDate": "2017-01-01T00:00:00",
        "reportingPeriod": "Daily",
        "taxlots": [
            {
                "id": "0",
                "date": null,
                "settleDate": null,
                "longShortIndicator": "L",
                "quantity": 11014385.2366,
                "cashLedgerName": "",
                "reference": {
                    "investmentId": "causcash",
                    "investmentName": "Cash",
                    "investmentDescription": null,
                    "assetClass": "Cash and Equiv.",
                    "countryIsoName": null,
                    "valuationDate": "2017-01-01T00:00:00",
                    "ticker": null,
                    "cusip": null,
                    "sedol": null,
                    "isin": null
                },
                "baseCurrency": {
                    "currencyIsoCode": "USD",
                    "unitCost": 1,
                    "unitPrice": 1,
                    "originalCost": 1,
                    "marketValue": 11014385.2366,
                    "amortizedCost": 11014385.2366,
                    "accruedIncome": null,
                    "unrealizedGainLoss": 0
                },
                "localCurrency": {
                    "currencyIsoCode": "USD",
                    "unitCost": 1,
                    "unitPrice": 1,
                    "originalCost": 1,
                    "marketValue": 11014385.2366,
                    "amortizedCost": 11014385.2366,
                    "accruedIncome": null,
                    "unrealizedGainLoss": 0
                }
            }
        ]
    },
    "paging": {
        "totalCount": 2595,
        "limit": 1,
        "first": "https://api.seic.com/v1/portfolio/1007-1-01360/taxlots?asOfDate=2017-01-01&reportingPeriod=Daily&before=MQ==&after=MQ==",
        "last": "https://api.seic.com/v1/portfolio/1007-1-01360/taxlots?asOfDate=2017-01-01&reportingPeriod=Daily&before=MjU5NQ==&after=MjU5NQ==",
        "previous": null,
        "next": "https://api.seic.com/v1/portfolio/1007-1-01360/taxlots?asOfDate=2017-01-01&reportingPeriod=Daily&before=Mg==&after=Mg==",
        "self": "https://api.seic.com/v1/portfolio/1007-1-01360/taxlots?asOfDate=2017-01-01&reportingPeriod=Daily&limit=1"
    }
}
MODEL
Operations
Name Description Data Type (L)
accountId

SEI unique system ID that represents the account.

string(40)
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
lotsCount

Number of tax lots per account in the API response.

string
asOfDate

As of business date of the reporting data in YYYY-MM-DD.

string
startDate

A schedule is created to automate the run of a report over time. The start date is the initial date for when the schedule started. It accepts the format as: [YYYY/MM/DD].

string
endDate

A schedule is created to automate the run of a report over time. The end date is the last date for when the schedule will run. The latest date within a range in ISO 8601 format YYYY-MM-DD.

string
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

string
id

The unique identifier for an entity such as a calendar, event, document, account, position or tax lot.

string
date

The year, month, and day of the event in UTC format.

string
settleDate

The date the lot was settled.

string
longShortIndicator

Indicates whether the position has a positive or negative weight in the portfolio

string
cashLedgerName

A specific ledger within a Chart of Accounts, currency only.

string
isin

The International Securities Identification Number (ISIN) is an alphanumeric code that identifies a specific securities issue.

string
sedol

The Stock Exchange Daily Official List (SEDOL) is a list of security identifiers used in the United Kingdom and Ireland for clearing purposes.

string
cusip

A 9-digit alphanumeric securities identifier assigned by the Committee on Uniform Security Identification Procedures (CUSIP) for the purposes of facilitating clearing and settlement of trades.

string
ticker

A ticker symbol used to identify a stock.

string
countryIsoName

The name of the ISO Country.

string
investmentId

The SEI system identifier that represents the investment.

number
investmentName

Name of the investment.

string
investmentDescription

The full text description of an investment.

string
currencyIsoCode The currency code of the base and local currency of an account. string
unitCost

The total cost divided by the quantity of an investment and adjusted for pricing multipliers in in base and local currency.

number
unitPrice

The price of a single unit (i.e., at price ) of a security expressed in base and local currency.

number
originalCost

The original cost of an investment expressed in base and local currency.

number
marketValue

The total market value of an investment expressed in the base and local currency of the entity.

number
eopAccuredIncentive

Accrued but not yet paid incentive fee as of the end of the period.

string
unrealizedGainLoss

The total amount of gain or loss that would occur if an investment was sold expressed in the base and local currency of the account. Includes both market gains/losses and FX gains/losses.

string
name A single line (up to 60 characters) description of an Account. string
quantity The current face amount or units held of an investment string
assetClass

Textual description of the broader security categorization to which security record belongs.

string
amortizedIncomeAmount

Income earned on a position due to amortization expressed in the base/local currency

string
accuredIncome

Income accrued but not paid expressed in the base and local currency of the account.

string


Taxlots

ApiV1PortfolioByExternalIdTaxlotsGet

GET

/{externalId}/taxlots

Prod:
https://api.seic.com/v1/portfolio/{externalId}/taxlots
Query Parameters
Name Description Data Type Required
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

string

accountId

SEI unique system ID that represents the account

string

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

string

startDate

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

string

endDate

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

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

integer

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

Path Parameters
Name Description Data Type Required
externalId

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
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

accountId

SEI unique system ID that represents the account

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

startDate

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

endDate

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

limit

Number of records per page. Many responses have a maximum of 50 records per page.

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

externalId null true

HTTP Basic

OAuth 2.0

API Key

Working...

Taxlots

ApiV1PortfolioByExternalIdTaxlotsGet

GET

/{externalId}/taxlots

Prod:
https://api.seic.com/v1/portfolio/{externalId}/taxlots
Query Parameters
Name Description Data Type Required
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

string

accountId

SEI unique system ID that represents the account

string

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

string

startDate

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

string

endDate

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

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

integer

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

Path Parameters
Name Description Data Type Required
externalId

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
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

accountId

SEI unique system ID that represents the account

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

startDate

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

endDate

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

limit

Number of records per page. Many responses have a maximum of 50 records per page.

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

externalId null true

HTTP Basic

OAuth 2.0

API Key

Working...

Test: https://test.api.seic.com/v1/portfolio/{externalId}/taxlots
TLS*: https://mtls.api.seic.com/v1/portfolio/{externalId}/taxlots
*The TLS endpoint is only used if Server Based Application was selected during the App Registration process.
STEP 1



STEP 2

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

Taxlots

ApiV1PortfolioByExternalIdTaxlotsGet

GET

/{externalId}/taxlots

Prod:
https://api.seic.com/v1/portfolio/{externalId}/taxlots
Query Parameters
Name Description Data Type Required
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

string

accountId

SEI unique system ID that represents the account

string

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

string

startDate

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

string

endDate

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

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

integer

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

Path Parameters
Name Description Data Type Required
externalId

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
reportingPeriod

The reporting period with valid values Daily, Weekly, Monthly and Quarterly. This mandatory query parameter is used only in a request to retrieve a limited set of positions data.

accountId

SEI unique system ID that represents the account

asOfDate

As of business date of the reporting data in YYYY-MM-DD.

startDate

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

endDate

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

limit

Number of records per page. Many responses have a maximum of 50 records per page.

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

externalId null true

HTTP Basic

OAuth 2.0

API Key

Working...