Taxlots

Taxlots

GET

/taxlots

Returns all the lots related data points for a particular investment product within a date range and reporting period.

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

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

string

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

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 SEI 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
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

reportDataType

Report type(Daily/Closed)

limit

Response page size.

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...

Taxlots

Taxlots

GET

/taxlots

Returns all the lots related data points for a particular investment product within a date range and reporting period.

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

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

string

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

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 SEI 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
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

reportDataType

Report type(Daily/Closed)

limit

Response page size.

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/taxlots
TLS*: https://mtls.api.seic.com/v1/investments/taxlots
*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.

Taxlots

Taxlots

GET

/taxlots

Returns all the lots related data points for a particular investment product within a date range and reporting period.

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

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

string

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

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 SEI 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
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

reportDataType

Report type(Daily/Closed)

limit

Response page size.

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/taxlots?reportDataType=Closed&asOfDate=2016-12-31&accountIds=9999-3-56789' \
  -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": {
		"asOfDate": "2016-12-31T00:00:00",
		"reportDataType": "Closed Period Investments",
		"accounts": [{
			"id": "9999-3-56789",
			"name": "Edem T. Smith",
			"externalId": "smith",
			"lotsCount": 25
		}],
		"lots": [{
			"id": "9999356",
			"accountId": "9999-3-56789",
			"date": "2014-01-16T00:00:00",
			"settleDate": "2014-01-16T00:00:00",
			"longShortIndicator": "L",
			"quantity": 46,
			"cashLedgerName": null,
			"reference": {
				"cusip": "459200101",
				"sedol": "2005973",
				"ticker": "IBM",
				"valuationDate": null,
				"isin": "US4592001014",
				"investmentName": "INTL BUSINESS MACHINES CORP",
				"investmentDescription": "INTL BUSINESS MACHINES CORP",
				"investmentId": 999,
				"countryIsoName": "Ireland"
			},
			"base": {
				"accruedIncome": 0,
				"amortizedCost": 2181.78,
				"currencyIsoCode": "USD",
				"marketValue": 2944,
				"originalCost": 2181.78,
				"unitCost": 47.43,
				"unitPrice": 64,
				"unrealizedGainLoss": 762.22
			},
			"local": {
				"accruedIncome": 0,
				"amortizedCost": 2181.78,
				"currencyIsoCode": "USD",
				"marketValue": 2944,
				"originalCost": 2181.78,
				"unitCost": 47.43,
				"unitPrice": 64,
				"unrealizedGainLoss": 762.22
			}
		}]
	}
}

MODEL
Operations
Name Description Data Type (L)
asOfDate

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

string
reportDataType

Report data type for investment positions, such as Closed or Daily.

string
id

The SEI system's internal identifier for an Account, position, lot, tranasction, investor, product or any other entity indicated by the oject grouping in the API response. 

string
name

The business description for an entity in the context of the API, sometimes called a proper name. A name can apply to a Calendar, Financial Institution, Investor, Account, Advisor and various other entities.

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
lotsCount

Number of tax lots per account in the API response.

string
accountId

SEI unique system ID that represents the account.

string(40)
settleDate

The date the lot was settled.

string
LongShortIndicator

Indicates if it’s a long or short position.

string
quantity

The current face amount, or quantity of shares held, for an investment or noted on a transaction.

number
cashLedgerName

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

string
priceSource

A data source supplying an issue price. The data source may be an external vendor or an internal source.

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
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
ticker

A ticker symbol used to identify a stock.

string
valuationDate

The date on which the market value of the investment is established.

string
isin

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

string
investmentName

Name of the investment.

string
investmentDescription

The full text description of an investment.

string
investmentId

The SEI system identifier that represents the investment.

number
countryIsoName

The name of the ISO Country.

string
accruedIncome

Accrued income receivable gross net taxes and fees expressed in the local currency of the investment.

number
amortizedCost

The amortized cost of an investment expressed in the base and local currency of the account.

number
currencyCode

The currency code of the base and local currency of the account.

string
marketValue

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

number
originalCost

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

number
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
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
date

Date of purchase into the lot.

string


Taxlots

Taxlots

GET

/taxlots

Returns all the lots related data points for a particular investment product within a date range and reporting period.

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

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

string

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

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 SEI 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
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple seperated by comma.

asOfDate

AsOfDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

reportDataType

Report type(Daily/Closed)

limit

Response page size.

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...