Type CmbsDaily
Type category Struct
Description Struct containing CMBS reference data.
Fields
Name Type Filters Description
accrualPeriod date The date from which the interest starts accruing.
accruedInterest decimal Interest on a security that has accumulated since the previous coupon payment.
analyticsId string(500) Analytics id
askPrice decimal Ask price is the price at which a market maker is willing to sell the security.
assetSwapMargin decimal Spread of a security over the swap curve.
averageLife decimal Time the principal of a debt is expected to be outstanding.
balanceUsedForAi decimal Balance used for the calculation of accrued interest.
bidAskSpread decimal Difference between bid and ask price.
bidPrice decimal Bid price is the price at which a market maker is willing to buy the security.
bondType string(200) Type of CMBS security, i.e. fixed rate, WAC/Pass Thru.
cashPaymentDate date Payment date for cash.
cashPaymentPercentage decimal Coupon payments plus redemptions since the last index rebalancing.
cashflowDate date Cashflow Date.
countryOfRisk string(200) Country where the issuer has the most business risk.
coupon decimal Coupon rate is the interest rate that the issuer agrees to pay each year. The annual amount of the interest payment made is called the coupon. The coupon rate multiplied by the principal of the bond provides the cash amount of the coupon.
couponFrequency long Number of times per year the coupon is paid.
couponPaymentPercentage decimal Interest paid since the last rebalancing, usually the last calendar day of a month. If there was no payment the value is 0.
cumBondLossPct decimal Total principal loss for life of tranche as percent of original balance.
cumulativeLosses decimal Cumulative losses on tranche to date.
curCreditThickness decimal Bond Thickness based on current credit enhancement as of tape date.
currency string(3) Currency or denomination of security.
currentBalance decimal Current aggregate collateral balance.
currentRedemptionPaymentPercentage decimal Redemption payment made in the current month. Expressed in percentage.
currentSubordinationPct decimal Instrument subordinated percentage share.
cusip string(9) Alphanumeric CUSIP numbers that are used to identify securities.
dayCountMethod string(200) The date count convention based on which the accrued interest is calculated, it determines the number of days between two coupon payments. Typical conventions are 30/360, Act/Act, Act/360, etc.
dealCurrentBalance decimal Deal Current bond balance.
dealDelinq30DayAmt decimal Balance of loans that are 30 to 59 days delinquent as of tape date.
dealDelinq60DayAmt decimal Balance of loans that are 60 to 89 days delinquent as of tape date.
dealDelinq90DayAmt decimal Balance of loans that are 90+ days delinquent as of tape date.
dealFactor decimal Percentage of deal remaining outstanding as of tape date.
dealForeclosureAmt decimal Amount of the loans, which are in foreclosure state.
dealName string(200) Deal Name.
dealNonPerfMatBalloonAmt decimal Amount of the loans which are in balloon mortgages.
dealOriginalBalance decimal Aggregate original balance of the deal.
dealReoAmt decimal Real estate owned amount.
dealType string(200) Deal Type.
defaseCreditEnhance decimal The current credit support for bonds after adjustment for loans that are fully defeased. Trepp calculates Defeasance Adjusted Credit Enhancement by running cashflows and prepaying the fully defeased loans immediately to realize the effect of the certain principal payments. This methodology is a more precise measure than calculating a defeasance adjusted credit enhancement by subtracting the amount of defeased loans from the denominator of the credit enhancement calculation as the cashflow waterfall is reflected in Trepp's Defeasance Adjusted Credit Enhancement. The Defeasance Adjusted Credit Enhancement value is calculated only for non-CDO deals that have any underlying fully defeased loans.
delinquency decimal A loan payment that is at least 30 days past due.
dirtyPrice decimal Clean price plus accrued interest.
discountMargin decimal Discount margin against a benchmark rate.
finalMaturity date Refers to the time when the debt must be repaid or rolled over. The official expected maturity specified by the issuer in the prospectus, not the legal final maturity. This is the date on which the principal amount is due.
firstSettlementDate date The date when the security is initially settled.
instrInXDivPeriod boolean Flag indicating if the instrument is in exDiv period.
interestShortFall decimal Current accumulated interest shortfall amount.
isFloater boolean Indicates whether the security is floating rate note in which coupon changes over time depending on an underlying rate.
isIo boolean Denotes if the CMBS instrument is an "interest only" security.
isPac boolean Indicates if the CMBS security is of a planned amortization class tranche.
isin string(12) The International Securities Identification Number (ISIN) is a code that uniquely identifies a specific securities issue.
issuer string(200) Name of the company, government or organization that issued the security.
issuerCountry string(200) Country where the issuer resides.
lastCouponDate date When was last coupon paid.
leadUnderwriter string(200) Lead underwriter (normalized across deals).
masterServicer string(200) Master servicer (normalized across deals).
modifiedDuration decimal The first derivative of the instrument's price with respect to yield. Measures the sensitivity of prices to changes in yield using local market conventions.
monthsSinceClosingDate decimal Months since Original settlement date of deal (YYYYMMDD).
nextCouponDate date Next coupon date of bond.
originalBalance decimal Original bond balance.
originalSubordinationPct decimal Original subordination percentage for bond (i.e., 25) - for “leg” deals, subordination level of legs will appear as 0.
penaltyPercentage decimal Prepayment Premium or YM/Fixed Penalty distributed in current period.
periodBondLoss decimal Loss amount in current period.
priceSource string(200) Price source of the bond.
priceType string(200) Indicates the price type used for the calculation, i.e. bid, ask or mid.
projectedCurrentFactor decimal Expected redemption factor.
redemptionFactor decimal Percentage of remaining notional on calculation date .
referenceDataId string(500) Reference data id
series string(200) Trepp internal series name.
specialServicer string(200) Special servicer (normalized across deals).
spread decimal TBA.
tapeDate date Tape Date.
trancheName string(200) Tranche name.
trustee string(200) Trustee name (normalized across deals).
underwriters string(200) Underwriters of the issue (normalized across deals).
unrealizedAccruedInterest decimal Unrealized interest accrued since last payment.
vintage long Year of issuance.
xDivAccrualStartDate date Accrual Start Date as of last month end.
xDivAccruedInterest decimal Accrued interest as of last month end.
xDivAnalyticsDate date Analytics date as of last month end.
xDivBalanceUsedForAi decimal Balance as of last month end.
xDivCashflowDate date Next cashflow date as of last month end.
xDivNextPayDate date Next pay date as of last month end.
yearsSinceClosingDate decimal Years since Original settlement date of deal (YYYYMMDD).
yield decimal Yield calculated via street convention.
83 rows of 83 total