Type Analytics
Type category Entity
Description Entity that represents the calculated analytics across the securitised products securities.
Timeseries key id, asOfavailable from 2022-12-19
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
timeline asOf date =< >= Current date
filter_list assetClass string(20) = Asset class of specific isin/cusip for which data is being pushed.
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the Price is calculated.
cdrValues decimal[36] A vector of conditional default rate assumption used in the evaluated price of the instrument. CDR represents the percentage of outstanding principal balances in the pool that are in default.
companyId long(-2147483648,2147483647) Unique S&P Capital IQ company identifier
currentSpreadToSofrToCall decimal Spread calculated relative to SOFR index for Fixed Bonds to the call scenario using current curve
currentSpreadToSofrToMaturity decimal Spread calculated relative to SOFR index for Fixed Bonds to the maturity date using current curve
currentSpreadToSofrsToWorst decimal Worst spread relative to SOFR index between maturity and call scenario using current curve
currentSpreadToSwapsToCall decimal Spread calculated relative to benchmark for Fixed Bonds to the call scenario using current curve
currentSpreadToSwapsToMaturity decimal Spread calculated relative to benchmark for Fixed Bonds to the maturity date using current curve
currentSpreadToSwapsToWorst decimal Worst spread relative to benchmark between maturity and call scenario using current curve
currentSpreadToTreasuryToCall decimal Spread calculated relative to Treasury for Fixed Bonds to the call scenario using current curve
currentSpreadToTreasuryToMaturity decimal Spread calculated relative to Treasury for Fixed Bonds to the maturity date using current curve
currentSpreadToTreasuryToWorst decimal Worst spread relative to Treasury between maturity and call scenario using current curve
currentWalToCall decimal Weighted average life of a security to the call date using current curve
currentWalToMaturity decimal Weighted average life of a security to the maturity date using current curve
currentWalToWorst decimal Worst WAL between maturity and call scenario using current curve
currentYieldToCall decimal Yield calculated with ASAP scenario
currentYieldToMaturity decimal Yield calculated with the assumption that the bond is held until maturity date
currentYieldToWorst decimal Worst yield between maturity and call scenario
filter_list cusip string(9) = CUSIP of the instrument.
dealName string(200) Bloomberg ticker of the deal
dmToCall decimal Discount margin is calculated for Floating Rate Notes (FRNs). It is the spread against the benchmark rate (eg, Euribor rate) of another floating interest rate calculated with ASAP scenario
dmToMaturity decimal Discount margin is calculated for Floating Rate Notes (FRNs). It is the spread against the benchmark rate (eg, Euribor rate) of another floating interest rate calculated until the maturity date
dmToWorst decimal Worst DM between maturity and call scenario
effectiveConvexityToCall decimal Effective convexity calculated to the call date
effectiveConvexityToMaturity decimal Effective convexity calculated to the maturity date
effectiveConvexityToWorst decimal Worst effective convexity duration between maturity and call scenario
effectiveDurationToCall decimal Effective duration of a bond duration is essentially the option adjusted duration, i.e. it is the weighted average of the times until those fixed cash flows are received, assuming option adjusted spread remains unchanged. This will be calculated only for the bonds with embedded option and calculated to the call date
effectiveDurationToMaturity decimal Effective duration of a bond duration is essentially the option adjusted duration, i.e. it is the weighted average of the times until those fixed cash flows are received, assuming option adjusted spread remains unchanged. This will be calculated to the maturity date
effectiveDurationToWorst decimal Worst effective duration between maturity and call scenario
fwdSpreadToSofrToCall decimal Spread calculated relative to SOFR index for Fixed Bonds to the call scenario using forward curve
fwdSpreadToSofrToMaturity decimal Spread calculated relative to SOFR index for Fixed Bonds to the maturity date using forward curve
fwdSpreadToSofrsToWorst decimal Worst spread relative to SOFR index between maturity and call scenario using forward curve
fwdSpreadToSwapsToCall decimal Spread calculated relative to benchmark for Fixed Bonds to the call scenario using forward curve
fwdSpreadToSwapsToMaturity decimal Spread calculated relative to benchmark for Fixed Bonds to the maturity date using forward curve
fwdSpreadToSwapsToWorst decimal Worst spread relative to benchmark between maturity and call scenario using forward curve
fwdSpreadToTreasuryToCall decimal Spread calculated relative to Treasury for Fixed Bonds to the call scenario using forward curve
fwdSpreadToTreasuryToMaturity decimal Spread calculated relative to Treasury for Fixed Bonds to the maturity date using forward curve
fwdSpreadToTreasuryToWorst decimal Worst spread relative to Treasury between maturity and call scenario using forward curve
fwdWalToCall decimal Weighted average life of a security to the call date using forward curve
fwdWalToMaturity decimal Weighted average life of a security to the maturity date using forward curve
fwdWalToWorst decimal Worst WAL between maturity and call scenario using forward curve
fwdYieldToCall decimal Yield calculated with ASAP scenario using forward curve
fwdYieldToMaturity decimal Yield calculated with the assumption that the bond is held until maturity date using forward curve
fwdYieldToWorst decimal Worst yield between maturity and call scenario using forward curve
filter_list isin string(12) = The International Securities Identification Number (ISIN) is a code that uniquely identifies a specific security.
modifiedConvexityToCall decimal The rate of change of modified duration (Dmod) with respect to yield at the given starting yield, it measuring the curvature of the price function of an option-free instrument or a portfolio as yields change more than 100 bps, which modified duration cannot accurately measure.
modifiedConvexityToMaturity decimal The rate of change of modified duration (Dmod) with respect to yield at the given starting yield, it measuring the curvature of the price function of an option-free instrument or a portfolio as yields change more than 100 bps, which modified duration cannot accurately measure, calculated until the maturity date
modifiedConvexityToWorst decimal Worst modified convexity duration between maturity and call scenario
modifiedDurationToCall decimal Modified duration of a bond is the first derivative of the bond price with respect to yield. Measures the change of yield for a change in price (in years or percentage) calculated until the call date/ASAP scenario
modifiedDurationToMaturity decimal Modified duration of a bond is the first derivative of the bond price with respect to yield. Measures the change of yield for a change in price (in years or percentage) calculated until the maturity date
modifiedDurationToWorst decimal Worst modified duration between maturity and call scenario
oas decimal The bond OAS is the spread over the benchmark zero coupon curve realized if the bond is held until maturity, by taking into account the interest rate volatility assumption for the embedded option. Calculated only for bonds with embedded option
prepaymentSpeed decimal[36] A vector of values of speed used in the evaluated price of the instrument. It is the estimated rate at which borrowers pays off the obligations that underlies an instrument.
prepaymentType string(25) The type of prepayment speed used in the evaluated price of the instrument, such as CPR or PSA.
pricingConfiguration string(20) Pricing Configuration of specific isin/cusip for which data is being pushed
securityId long(-2147483648,2147483647) Unique S&P Capital IQ security identifier
severityValues decimal[36] A vector of Loss Severity assumption used in evaluated price of the instrument. It is the percentage of the principal applied to the defaulted loan balance.
sprdId string(50) Unique identifier for an instrument from SP Reference Data
tradingItemId long(-2147483648,2147483647) Unique S&P Capital IQ trading item identifier
tranche string(50) Tranche name of the instrument using static yield curve.
64 rows of 64 total
API Open API Specification