Type Instrument
Type category Entity
Description This section provides all tranche details for the specific deal.
Timeseries key id, lastModifiedDateavailable from 2025-03-11
Fields
Name Type Filters Description
key id string(200)* = This is the unique identifier for the tranche.
timeline lastModifiedDate dateTime* =< >= This is the timestamp of the latest instrument update.
accrualConvention string(50) This field indicates if Instrument accrual days are Hardcoded or not.
accrualStartDate date This is accrual start date for the next pay date of the tranche.
accrualStartDay long This is the calendar day of payment month.
amortFlag boolean This field indicates if a security has a feature of pre decided amortization schedule.
assetClass string(500) This field is to identify the classification of an instrument based on IHSM Standard.
link batch Batch* = The Batch in which the Instrument is calculated.
link batchRun BatchRun* = The BatchRun in which the Instrument data are published.
bbgTicker string(50) This is an identifier issued by Bloomberg for the instrument.
bbgUniqueId string(50) This is Bloomberg's unique identifier for the instrument.
billingCode string(200) This field indicates 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) This is the Business/Calendar day’s convention applicable to interest & principal payment.
componentBalances string(1000) This is 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 This field defines first accrual start date
couponSubType string(200) This field further defines the coupon type of the instrument, used in conjunction with coupon type for example Floating: Floating then Fixed etc.
couponType string(100) This field defines the coupon type of the instrument for example FIX, FLT, VAR etc.
createdDate dateTime Field to indicate the date when first data leg was inserted.
creditSupportGroup string(255) This is the formula used to calculate current credit support associated with a Tranche e.g.( RESIDUAL + OC) / COLLAT.
filter_list currency string(3) = This is the dominant currency of the collateral in the deal.
currentAccrualEndDate date This is the current accrual end date.
currentAccrualStartDate date This is the current accrual start date.
currentCreditEnhancement string(500) This is the formula used to calculate current credit support associated with a Tranche e.g.( RESIDUAL + OC) / COLLAT.
filter_list cusip string(9) = A CUSIP 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* = This is the unique id of the deal.
determinationDay long This is the determination day for CMBS Instruments.
determinationDelay long This is the determination delay for CMBS Instruments.
distributionDay long This is the distribution day for CMBS Instruments.
factorableFlag boolean This field indicates if a security has a feature of paying down or capitalizing on factor basis.
figi string(50) This is a global identifier issued by Bloomberg for the instrument.
firstPaymentDate date This is 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.
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.
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) This is the formula used to calculate the rate of interest payment.
floaterIndex string(255) This is the specific Index on which a floating coupon is calculated for a tranche.
floaterSpread decimal This is the spread or Margin used in the calculation of the interest rate.
floaterSpreadDetails string(200) This is the spread or margin field used in the calculation of the interest rate with multiple trigger values.
groundGroup string(300) This is the collateral ground groups which make up a collateral group.
hasNotionalBalance boolean This flag is indicating notional status on the basis of backed tranche.
indexMultiplier decimal This is the ARM index rate coefficient. Defaulted to 0 if not explicitly set.
indexMultiplierDetails string(200) This is the ARM index rate coefficient field with multiple trigger values.
isExchangeable boolean This flag indicates whether the instrument is exchangeable or not.
isImpliedWriteDown boolean This flag is indicating if the tranche has an implied write down.
isOriginallyFullyInsured boolean This flag is indicating if the tranche was fully insured at issuance.
isTargetEnhance boolean This flag is indicating if the tranche has an option of target enhancement.
filter_list isin string(12) = A ISIN is a 12-character alphanumeric code that identifies a financial security for the purposes of facilitating clearing and settlement of trades.
issueDate date This is 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.
marginDetails string(200) The spread used in the calculation of the interest with multiple trigger values.
maturityDate date This field indicates 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 like LegalFinal, StatedFinal etc.
maturityYears string(20) This field indicates the maturity years of potential pools for 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) This field indicates the mortgage type of TBA securities like UMBS, GNMA I etc.
notionalStatus string(20) This field describes 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.
optionalTerminationFlag boolean A flag indicating if the deal has an optional redemption covenant.
originalCreditEnhancement decimal This is the percentage of credit support for the tranche at issuance.
originalNotionalBalance decimal This is the notional balance of the tranche at issuance.
originalPariPassuBalance decimal This is the combined principal balance at issuance of all tranches pari-passu with the specified tranche.
originalSeniorBalance decimal This is the combined principal balance at issuance of all tranches senior to the specified tranche.
originalSubordinate decimal This is the combined principal balance at issuance of all tranches subordinate to the specified tranche.
originalSupport decimal This is the percentage of credit support for the tranche at issuance.
originalSupportAmount decimal This is the amount of credit support for the tranche at issuance.
originalSupportBasis decimal Credit support basis amount indicates the total amount from which the credit support is to be drawn for a tranche.
originalTrancheBalance decimal This is the original tranche balance at issuance.
paymentDelay long These are the points to an array which contains the interest delay days for each tranche.
principalPaymentFrequency string(200) This is the principal payment frequency for the specific tranche.
product string(255) This field indicates the product type of TBA securities like Single Family Mortgage, Balloon etc.
prospectusGroup string(300) This is a structural group that backs a specific bond.
ratingCategory string(10) This field defines the rating category for example IG, HY, Split and Unrated.
ratings InstrumentRating[1000] This is an unique id for instrument rating.
repaymentDate date This is the currently anticipated repayment date.
securityAbbreviation string(255) This is a short description of the security.
securityDescription string(255) This is a detailed description of the security.
securityStatus string(200) This is the status of the security at deal level.
seniority string(30) This field defines 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) This is the month when seller delivers pools for TBA securities to seller like January, March etc.
source string(30) This is the source from which the Instrument record was last updated.
statedFinalMaturityDate date This is the stated maturity date which is the latest expected payment date of the tranche as stated by the issuer, usually calculated based on 0CPR/0CDR scenario.
supportGroupNumber decimal The percentage of credit support for the tranche at issuance.
tranche string(255) This is the name of bond class.
filter_list trancheFrequency string(200) = This is the interest payment frequency for the specific tranche.
trancheStatus string(100) This is the status of the security at tranche/instrument level.
trancheType string(255) This is the description of the tranche.
tranchesSupported string(500) This is the name of senior bond classes which are supported by subordinate bonds.
97 rows of 97 total
API Open API Specification