Type InstrumentCashFlows
Type category Entity
Description Historical cash flows for an instrument.
Timeseries key id, paymentDateavailable from 2025-07-03
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.
accrualEndDate date This is the accrual end date for the payment leg.
accrualStartDate date This is the accrual start date for the payment leg.
accumulatedCouponCapShortfall decimal This the accumulated coupon cap interest shortfall for the tranche.
accumulatedInterestShortfall decimal This is the accumulated unpaid interest amount reported till date.
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.
adjustedPaymentDate date This is the payment date with adjusted business day convention.
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.
calculatedDataFlag string(30) This flag indicates whether calculated data is based on full or partial underlying data.
contributedWac decimal The weighted average of the collateral coupon supporting the tranche.
coupon decimal This is the expected tranche rate of interest for next payment date.
couponCapShortfall decimal This is the coupon cap shortfall from the most recent payment date.
createdDate dateTime Field to indicate the date when first data leg was inserted.
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 It is net collateral interest minus current period interest obligations to the tranches at group level.
factor decimal The percentage of the original principal that remains outstanding.
factorDate date The date when Ginnie Mae/Fannie Mae/Freddie Mac/trustees announce periodic factors.
factorNumericDate date This is the first day of recently reported factor month.
factorPaymentRate decimal This is the payment rate associated with the current payment date.
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 timeline This is the timestamp of the latest InstrumentCashFlows update.
lowCollar decimal Lower bound of the effective PAC band.
nextAccrualEndDate date This is the next accrual end date for the payment leg.
nextAccrualStartDate date This is the next accrual start date for the payment leg.
nextAdjustedPaymentDate date This is the next payment date with adjusted business day convention.
nextCalculatedFactor decimal This is the calculated factor for next payment date based on underlying collateral.
nextPaymentDate date The next scheduled payment date of a tranche.
nextToNextAccrualEndDate date This is the Next to Next accrual end date for the payment leg.
nextToNextAccrualStartDate date This is the Next to Next accrual start date for the payment leg.
nextToNextAdjustedPaymentDate date This is the Next to Next payment date with adjusted business day convention.
nextToNextToNextAccrualEndDate date This is the Next to Next to Next accrual end date for the payment leg.
nextToNextToNextAccrualStartDate date This is the Next to Next to Next accrual start date for the payment leg.
nextToNextToNextAdjustedPaymentDate date This is the Next to Next to Next payment date with adjusted business day convention.
notificationDate date This is the date when the seller notifies the buyer of specific pools & their characteristics for TBA securities.
oneMonthCoupon decimal The current tranche interest rate as reported by trustee.
outOfFrequency string(10) The frequency is not inline with the dates.
prePayPenalty decimal This field defines prepayment penalty received at tranche level.
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.
61 rows of 61 total
API Open API Specification