Type InstrumentCashFlows
Type category Entity
Description Historical cash flows for an instrument.
Timeseries key id, paymentDate
Fields
Name Type Filters Description
key id string(200)* = This is the IHSMarkit generated unique identifier for the cash flow.
timeline paymentDate date* =< >= This is the tranche cash flow payment date.
accumulatedCouponCapShortfall decimal This the accumulated coupon cap interest shortfall for the tranche.
accumulatedInterestShortfall decimal This is the unpaid interest amount for the current period.
accumulatedPrepayInterestShortfall decimal This is the accumulated non-supported interest shortfall for the tranche.
accumulatedUnrealizedWritedown decimal This is the accumulated principal amount which is still lying unrecovered.
accumulatedWritedown decimal This is the accumulated realized loss of outstanding balance, in the appropriate currency, for each tranche.
link batch Batch* = The Batch in which the Cash Flow is calculated.
link batchRun BatchRun* = The BatchRun in which the Cash Flow data is published.
bondInterestPayment decimal This is the interest payment amount paid out to bond holders.
bondPrincipalPayment decimal This is the principal payment amount paid out to bond holders.
contributedWac decimal The weighted average of the collateral coupon supporting the tranche.
coupon decimal This is the tranche rate of interest for next payment date.
couponCapShortfall decimal This is the coupon cap shortfall from the most recent payment date.
currentBalance decimal This is the tranche's outstanding balance as of the latest payment date.
currentNaturalSupport decimal This is the current percentage of credit support for the tranche excluding full insurance wraps.
currentNotionalBalance decimal This is the current notional balance of the tranche.
currentPariPassuBalance decimal This is the current combined principal balance of all tranches pari-passu with the specified tranche.
currentSeniorBalance decimal This is the aggregate outstanding balance of tranches senior to the specified tranche.
currentSubordinate decimal This is the aggregate outstanding balance of tranches subordinate to the specified tranche.
currentSupport decimal This is the current percentage of credit support for the tranche.
currentSupportAmount decimal This is the current amount of credit support for the tranche.
currentSupportBasis decimal This is the current total amount from which credit support is to be drawn from for the specified tranche.
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.
excessInterest decimal This is the amount of monthly excess interest.
factor decimal The percentage of the original collateral balance of the group that remains outstanding.
highCollar decimal Higher bound of the effective PAC band.
impliedBalance decimal This is the weighted average amount of the tranche based on the balance being adjusted by implied write-downs.
link instrument Instrument* This is the instrument the cash flow is for.
isFullyInsured boolean This flag is indicating if the tranche is fully insured.
lastModifiedDate dateTime This is the timestamp of the latest InstrumentCashFlows update.
lowCollar decimal Lower bound of the effective PAC band.
nextPaymentDate date The next scheduled payment date of a tranche.
oneMonthCoupon decimal The current tranche interest rate as reported by trustee.
outOfFrequency string(10) The frequency is not inline with the dates.
previousFactor decimal This is the percentage of the original principal that remains outstanding for previous payment month.
previousFactorDate date This is 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 3 Month Average of Bond Coupons.
tranche string(255) The name of bond class.
writedown decimal This is the write-down amount from the most recent payment date.
41 rows of 41 total
API Open API Specification