Type Constituent
Type category Entity
Description Entity to describe a loan
Timeseries key id, asOfavailable from 2012-01-31
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
timeline asOf date* =< >= Month end date of index holdings
amount decimal Facility Amount in MM
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the Price is calculated.
bbergId string(20) A Bloomberg generated identifier associated with a particular issuer / tranche combination
beginningConversionRateEur decimal Beginning conversion rate from loan currency into Eur
beginningConversionRateGbp decimal Beginning conversion rate from loan currency into Gbp
beginningConversionRateUsd decimal Beginning conversion rate from loan currency into Usd
beginningMarketValue decimal Beginning Market-Value
beginningMarketValueEur decimal Beginning Market-Value in Eur
beginningMarketValueGbp decimal Beginning Market-Value in Gbp
beginningMarketValueUsd decimal Beginning Market-Value in Usd
beginningMarketWeight decimal Beginning Market-Weight
beginningPrice decimal Price as Start Date
combinedRating string(20) Combined rating of SNP and Moodys
company string(200) Name of company
country string(20) Country of loan
covLite string(10) TRUE/FALSE indication of the tranche being cov-lite
currency string(5) Currency of loan
defaultIndicator string(10) TRUE/FALSE indication whether the loan has defaulted
discountMarginToMaturity decimal Discount Margin to Maturity
effectiveDate date Closing date of the loan
endConversionRateEur decimal End conversion rate from loan currency into Eur
endConversionRateGbp decimal End conversion rate from loan currency into Gbp
endConversionRateUsd decimal End conversion rate from loan currency into Usd
endDate date Pricing End Date
endMarketValue decimal End Market-Value
endMarketValueEur decimal End Market-Value in Eur
endMarketValueGbp decimal End Market-Value in Gbp
endMarketValueUsd decimal End Market-Value in Usd
endMarketWeight decimal End Market-Weight
endPrice decimal Price as of EndDate
facility string(20) Tranche name
fiveYearDiscountMargin decimal Discount Margin to 5-yr call
fiveYearYield decimal Yield to 5-yr call
fourYearDiscountMargin decimal Discount Margin to 4-yr call
fourYearYield decimal Yield to 4-yr call
hasLiborFloor string(10) YES/NO indication of the tranche having a Libor floor
indexName string(400) Name of index
industry string(100) Industry classification
industrySegment string(50) Segment within Industry
industryType string(50) Type of Industry
interestReturn decimal Interest return between StartDate and EndDate
interestReturnHedgedEur decimal Interest return Eur Hedged between StartDate and EndDate
interestReturnHedgedGbp decimal Interest return Gbp Hedged between StartDate and EndDate
interestReturnHedgedUsd decimal Interest return US Hedged between StartDate and EndDate
interestReturnUnhedgedEur decimal Interest return Eur unHedged between StartDate and EndDate
interestReturnUnhedgedGbp decimal Interest return Gbp unHedged between StartDate and EndDate
interestReturnUnhedgedUsd decimal Interest return US unHedged between StartDate and EndDate
issuer string(200) Name of borrower or issuer
liborFloor decimal The minimum base rate in percentage paid in the event Libor is below the specified floor level. (i.e., 1.25 is 125 bps)
filter_list lxid string(20) = An IHS Markit generated unique identifier associated with a particular issuer / tranche combination
maturityDate date Final maturity date
moodysRating string(20) Moodys Rating
principalReturn decimal Principal return between StartDate and EndDate
principalReturnHedgedEur decimal Principal return Eur Hedged between StartDate and EndDate
principalReturnHedgedGbp decimal Principal return Gbp Hedged between StartDate and EndDate
principalReturnHedgedUsd decimal Principal return Usd Hedged between StartDate and EndDate
principalReturnUnhedgedEur decimal Principal return Eur unHedged between StartDate and EndDate
principalReturnUnhedgedGbp decimal Principal return Gbp unHedged between StartDate and EndDate
principalReturnUnhedgedUsd decimal Principal return Usd unHedged between StartDate and EndDate
ratingTier string(20) Indication whether the loan rating is in an Upper, Middle, Lower tier or Not Rated
seniority string(20) Lien of the loan
spRating string(20) SNP Rating
spread decimal Spread of the Loan
startDate date Pricing Start Date
threeYearDiscountMargin decimal Discount Margin to 3-yr call
threeYearYield decimal Yield to 3-yr call
totalReturn decimal Total return between StartDate and EndDate
totalReturnHedgedEur decimal Total return Eur Hedged between StartDate and EndDate
totalReturnHedgedGbp decimal Total return Gbp Hedged between StartDate and EndDate
totalReturnHedgedUsd decimal Total return Usd Hedged between StartDate and EndDate
totalReturnUnhedgedEur decimal Total return Eur unHedged between StartDate and EndDate
totalReturnUnhedgedGbp decimal Total return Gbp unHedged between StartDate and EndDate
totalReturnUnhedgedUsd decimal Total return Usd unHedged between StartDate and EndDate
twoYearDiscountMargin decimal Discount Margin to 2-yr call
twoYearYield decimal Yield to 2-yr call
yieldToMaturity decimal Yield to Maturity
79 rows of 79 total
API Open API Specification