Type Instrument
Type category Entity
Description The tranche details for the specific deal.
Timeseries key id, lastModifiedDateavailable from 1996-06-10
Fields
Name Type Filters Description
key id string(200)* = The unique identifier for the tranche.
timeline lastModifiedDate dateTime* =< >= The timestamp of the latest instrument update.
accrualConvention string(50) Indicates if instrument accrual days are hardcoded or not.
accrualStartDate date Accrual start date for the next pay date of the tranche.
accrualStartDay long The calendar day of payment month.
amortFlag boolean Indicates if a security has a feature of pre decided amortization schedule.
assetClass string(500) The classification of an instrument.
link batch Batch* = The batch in which the instrument data are published.
link batchRun BatchRun* = The batchRun in which the instrument data are published.
bbgTicker string(50) Bloomberg ticker is a string of characters or numbers to identify a company or entity uniquely by Bloomberg.
bbgUniqueId string(50) Bloomberg's unique identifier for the instrument.
billingCode string(200) The billing code of the security. It is used to determine the correct billing for the use of the security.
bloombergMarketSectorDescription string(100) Market sector description from Bloomberg.
bloombergSecurityType string(50) Bloomberg-generated type of security.
bloombergSecurityType2 string(50) Bloomberg-generated alternative security type.
businessDayConvention string(255) The business or calendar days convention applicable to interest & principal payment.
capitalizedDeferredInterest boolean Indicates if a security unpaid interest is added to the principal balance instead of being paid in cash. [Magnitude: $]
componentBalances string(1000) The outstanding balance for each of the components in the deal.
components string(255) These are the names of components which are part of the deal e.g. A1A, A1B, IA etc.
couponDatedDate date The first accrual start date
couponSubType string(200) The coupon sub type of the instrument, used in conjunction with coupon type for example Floating: Floating then Fixed etc.
couponType string(100) The coupon type of the instrument for example FIX, FLT, VAR etc.
createdDate dateTime The date and time when first data leg was inserted.
creditSupportGroup string(255) The formula used to calculate current credit support associated with a tranche e.g.( Residual + Overcollateralization) / Collateral).
filter_list currency string(3) = The dominant currency of the collateral in the deal. Follows ISO 4217 code.
currentAccrualEndDate date The current accrual end date.
currentAccrualStartDate date The current accrual start date.
currentCreditEnhancement string(1000) The formula used to calculate current credit support associated with a tranche e.g.( Residual + Overcollateralization) / Collateral).
filter_list cusip string(9) = A Committee on Uniform Securities Identification Procedures (CUSIP) value is a nine-character alphanumeric code that identifies a financial security for the purposes of facilitating clearing and settlement of trades.
daycount string(255) The calculation method used to count the number of days spanning an accrual period, as well as the method used to count the number of days in a year.
link deal Deal* = The unique identifier of deal.
determinationDay long The determination day for Commercial Mortgage-Backed Securities (CMBS) instruments.
determinationDelay long The determination delay for Commercial Mortgage-Backed Securities (CMBS) instruments.
distributionDay long The distribution day for Commercial Mortgage-Backed Securities (CMBS) instruments.
factorableFlag boolean Indicates if a security has a feature of paying down or capitalizing on factor basis.
figi string(50) A global identifier issued by Bloomberg for the instrument.
firstPaymentDate date The first interest payment date of the tranche.
floaterCap decimal If floating tranche, this field is the interest rate cap for the borrower's interest rate. [Magnitude: %]
floaterCapDetails string(200) If floating tranche, this field is the interest rate cap for the borrower's interest rate with multiple trigger values.
floaterFloor decimal If floating tranche, this field is the interest rate floor for the borrower's interest rate. [Magnitude: %]
floaterFloorDetails string(200) If floating tranche, this field is the interest rate floor for the borrower's interest rate with multiple trigger values.
floaterFormula string(500) The formula used to calculate the rate of interest payment.
floaterIndex string(255) The specific index on which a floating coupon is calculated for a tranche.
floaterSpread decimal The spread or margin used in the calculation of the interest rate. [Magnitude: b.p]
floaterSpreadDetails string(200) The spread or margin field used in the calculation of the interest rate with multiple trigger values.
groundGroup string(300) The collateral ground groups which make up a collateral group.
hasNotionalBalance boolean Indicates notional status on the basis of backed tranche.
indexMultiplier decimal The Adjustable-Rate Mortgage (ARM) index rate coefficient. Defaulted to 0 if not explicitly set. [Magnitude: x]
indexMultiplierDetails string(200) The Adjustable-Rate Mortgage (ARM) index rate coefficient field with multiple trigger values.
isExchangeable boolean Indicates whether the instrument is exchangeable or not.
isImpliedWriteDown boolean Indicates that the tranche has an implied write-down.
isOriginallyFullyInsured boolean Indicates that the tranche was fully insured at issuance.
isTargetEnhance boolean Indicates that the tranche has an option of target enhancement.
filter_list isin string(12) = An International Securities Identification Number (ISIN) value is a 12-character alphanumeric code that identifies a financial security for the purposes of facilitating clearing and settlement of trades.
issueDate date The date on which tranche was issued.
legalFinalMaturityDate date Legal final maturity date which is the latest possible under any circumstances payment date of the tranche; reported only when explicitly provided in the prospectus separately from stated maturity.
margin decimal The spread used in the calculation of the interest. [Magnitude: b.p]
marginDetails string(200) The spread used in the calculation of the interest with multiple trigger values.
maturityDate date The maximum date between legal maturity date and stated maturity date. If both are not available then expected collateral termination date.
maturityType string(50) Type of the maturity date. The expected values are LegalFinal, StatedFinal and CollateralTermination
maturityYears string(20) The maturity years of potential pools for To-Be-Announced (TBA) securities like 10,15,30 years etc.
monolineInsurerName string(255) Name of insurance company that provides guarantees to issuers, often in the form of credit wraps that enhance the credit of the issuer.
mortgageType string(100) The mortgage type of To-Be-Announced (TBA) securities like UMBS (Uniform Mortgage-Backed Securities), GNMA I (Ginnie Mae I), etc.
notionalStatus string(20) The notional status of the security like mix, pure.
optionalRedemptionCondition string(500) The date or deal size fraction after which a deal can be called as per an optional termination covenant with multiple trigger values.
optionalRedemptionDate date The date after which a deal can be called as per an optional termination covenant
optionalRedemptionFraction decimal The deal size fraction below which a deal can be called as per an optional termination covenant. [Magnitude: x]
optionalTerminationFlag boolean A flag indicating if the deal has an optional redemption covenant.
originalCreditEnhancement decimal The percentage of credit support for the tranche at issuance. [Magnitude: %]
originalNotionalBalance decimal The notional balance of the tranche at issuance. [Magnitude: $]
originalPariPassuBalance decimal The combined principal balance at issuance of all tranches pari-passu with the specified tranche. [Magnitude: $]
originalSeniorBalance decimal The combined principal balance at issuance of all tranches senior to the specified tranche. [Magnitude: $]
originalSubordinate decimal The combined principal balance at issuance of all tranches subordinate to the specified tranche. [Magnitude: $]
originalSupport decimal The percentage of credit support for the tranche at issuance. [Magnitude: %]
originalSupportAmount decimal The amount of credit support for the tranche at issuance. [Magnitude: $]
originalSupportBasis decimal The total amount from which the credit support is to be drawn for a tranche. [Magnitude: $]
originalTrancheBalance decimal The original tranche balance at issuance. [Magnitude: $]
paymentDelay long These are the points to an array which contains the interest delay days for each tranche. [Magnitude: days]
principalPaymentFrequency string(200) The principal payment frequency for the specific tranche.
product string(255) The product type of To-Be-Announced (TBA) securities like single family mortgage, balloon etc.
prospectusGroup string(300) A structural group that backs a specific bond.
ratingCategory string(10) Defines the rating category of the instrument The expected values are: IG (Investment Grade), HY (High Yield), Split and Unrated.
ratings InstrumentRating[1000] An unique id for instrument rating.
repaymentDate date The currently anticipated repayment date.
securityAbbreviation string(255) A short description of the security.
securityDescription string(255) A detailed description of the security.
securityStatus string(200) The status of the security at deal level.
seniority string(30) The ranking structure of the instrument for payment.
series string(50) Additional text about the security to represent series of the deal for example 2022-1, 2022-A, IV etc. from Bloomberg.
settlementMonth string(20) The month when seller delivers pools for To-Be-Announced (TBA) securities to seller like January, March etc.
source string(30) The source from which the instrument record was last updated.
statedFinalMaturityDate date The stated maturity date which is the latest expected payment date of the tranche as stated by the issuer, usually calculated based on 0CPR (zero Constant Prepayment Rate) or 0CDR (zero Constant Default Rate) scenario.
supportGroupNumber decimal The percentage of credit support for the tranche at issuance. [Magnitude: %]
tranche string(255) The name of bond class.
filter_list trancheFrequency string(200) = The interest payment frequency for the specific tranche.
trancheStatus string(100) The status of the security at tranche or instrument level.
trancheType string(255) The description of the tranche.
tranchesSupported string(500) The name of senior bond classes which are supported by subordinate bonds.
updatedGroundGroup string(2500) The collateral ground groups which make up a collateral group.
99 rows of 99 total
API Open API Specification