Type InstrumentCashFlows
Type category Entity
Description Historical cash flows for an instrument.
Timeseries key id, paymentDateavailable from 1980-01-15
Fields
Name Type Filters Description
key id string(200)* = Internally generated unique identifier for instrument cash flow.
timeline paymentDate date* =< >= The tranche cash flow payment date.
accrualEndDate date The accrual end date for the payment leg.
accrualStartDate date The accrual start date for the payment leg.
accumulatedCouponCapShortfall decimal The accumulated coupon cap interest shortfall for the tranche. [Magnitude: $]
accumulatedInterestShortfall decimal The accumulated unpaid interest amount reported till date. [Magnitude: $]
accumulatedPrepayInterestShortfall decimal The accumulated non-supported interest shortfall for the tranche. [Magnitude: $]
accumulatedUnrealizedWritedown decimal The accumulated principal amount which is still lying unrecovered. [Magnitude: $]
accumulatedWritedown decimal The accumulated realized loss of outstanding balance, in the appropriate currency, for each tranche. [Magnitude: $]
adjustedPaymentDate date The payment date with adjusted business day convention.
link batch Batch* = The Batch in which the Cash Flow data is published.
link batchRun BatchRun* = The BatchRun in which the Cash Flow data is published.
bondInterestPayment decimal The interest payment amount paid out to bond holders. [Magnitude: $]
bondPrincipalPayment decimal The principal payment amount paid out to bond holders. [Magnitude: $]
calculatedDataFlag string(30) Indicates whether calculated data is based on full or partial underlying data.
contributedWac decimal The weighted average of the collateral coupon supporting the tranche. [Magnitude: %]
coupon decimal The expected tranche rate of interest for next payment date. [Magnitude: %]
couponCapShortfall decimal The coupon cap shortfall from the most recent payment date. [Magnitude: $]
createdDate dateTime The date and time when first data leg was inserted.
currentBalance decimal The tranche's outstanding balance as of the latest payment date. [Magnitude: $]
currentNaturalSupport decimal The current percentage of credit support for the tranche excluding full insurance wraps. [Magnitude: %]
currentNotionalBalance decimal The current notional balance of the tranche. [Magnitude: $]
currentPariPassuBalance decimal The current combined principal balance of all tranches pari-passu with the specified tranche. [Magnitude: $]
currentSeniorBalance decimal The aggregate outstanding balance of tranches senior to the specified tranche. [Magnitude: $]
currentSubordinate decimal The aggregate outstanding balance of tranches subordinate to the specified tranche. [Magnitude: $]
currentSupport decimal The current percentage of credit support for the tranche. [Magnitude: %]
currentSupportAmount decimal The current amount of credit support for the tranche. [Magnitude: $]
currentSupportBasis decimal The current total amount from which credit support is to be drawn from for the specified tranche. [Magnitude: $]
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.
excessInterest decimal It is net collateral interest minus current period interest obligations to the tranches at group level. [Magnitude: $]
factor decimal The percentage of the original principal that remains outstanding. [Magnitude: %]
factorDate date The date when Ginnie Mae or Fannie Mae or Freddie Mac trustees announce periodic factors.
factorNumericDate date The first day of recently reported factor month.
factorPaymentRate decimal The payment rate associated with the current payment date. [Magnitude: x]
highCollar decimal Higher bound of the effective Probably Approximately Correct (PAC) band. [Magnitude: actual]
impliedBalance decimal The weighted average amount of the tranche based on the balance being adjusted by implied write-downs. [Magnitude: $]
link instrument Instrument* = The instrument the cash flow is for.
isFullyInsured boolean Indicates if the tranche is fully insured.
lastModifiedDate dateTime The date and time of the latest InstrumentCashFlows update.
lowCollar decimal Lower bound of the effective Probably Approximately Correct (PAC) band. [Magnitude: actual]
nextAccrualEndDate date The next accrual end date for the payment leg.
nextAccrualStartDate date The next accrual start date for the payment leg.
nextAdjustedPaymentDate date The next payment date with adjusted business day convention.
nextCalculatedFactor decimal The calculated factor for next payment date based on underlying collateral. [Magnitude: %]
nextCalculatedFactorSource string(50) Name of the source providing the nextCalculatedFactor value. The expected values are: Intex, RCD, DTCC and Euroclear.
nextPaymentDate date The next scheduled payment date of a tranche.
nextToNextAccrualEndDate date The next to next accrual end date for the payment leg.
nextToNextAccrualStartDate date The next to next accrual start date for the payment leg.
nextToNextAdjustedPaymentDate date The next to next payment date with adjusted business day convention.
nextToNextToNextAccrualEndDate date The next to next to next accrual end date for the payment leg.
nextToNextToNextAccrualStartDate date The next to next to next accrual start date for the payment leg.
nextToNextToNextAdjustedPaymentDate date The next to next to next payment date with adjusted business day convention.
notificationDate date The date when the seller notifies the buyer of specific pools & their characteristics for To-Be-Announced (TBA) securities.
oneMonthCoupon decimal The current tranche interest rate as reported by trustee. [Magnitude: %]
outOfFrequency string(10) The frequency is not inline with the dates.
prePayPenalty decimal The prepayment penalty received at tranche level. [Magnitude: $]
previousFactor decimal The percentage of the original principal that remains outstanding for previous payment month. [Magnitude: %]
previousFactorDate date The previous factor date.
settlementDate date The date on which trade is settled. This field is showing settle date T+0, where T = underlying tranche payment date of respective month.
threeMonthCoupon decimal The three-month average of bond coupons. [Magnitude: %]
tranche string(255) The name of bond class.
writedown decimal The write-down amount from the most recent payment date. [Magnitude: $]
62 rows of 62 total
API Open API Specification