| 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. |