Convertible Bond, inflation-linked
Last updated 20 November 2026
Function reference › Bonds › Convertible Bond (Inflation)
5 GIAnalyzer functions for Excel. Optional arguments are shown in [brackets].
GIA_Bonds_ConvertibleInflation_Risk
Returns the risk measures (DV01, Modified Duration, Convexity, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond, given a nominal interest rate and a real interest rate for discounting future cash flows.
GIA_Bonds_ConvertibleInflation_Risk(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, RateN, RateI, Sp, LCPI, VDate, Comp, Days, Steps, RM, [RMForm], [ShiftedRates])Returns: Risk measures (DV01, Modified Duration, Convexity, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond
| Argument | Use | Description |
|---|---|---|
FaceValue | Required | The bond's face value. |
ConversionRatio | Required | The number of shares received on conversion. |
ConversionRatioType | Required | What the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value) |
StartDate | Required | The start date of the bond's first accrual period. |
MDate | Required | The bond's maturity date. |
CRate | Required | The bond's fixed coupon rate. |
CFr | Required | The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly) |
FPPD | Required | The first principal payment date. Blank or the maturity date: the whole principal is paid at maturity. |
FrPP | Required | The frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly) |
BCPI | Required | The CPI level at the inception of the deal. |
S | Required | The spot price of the underlying asset. |
Vol | Required | The volatility of the underlying asset. |
DividendYield | Required | The continuous annual dividend yield. |
RateN | Required | The nominal interest rate, which drives and discounts the equity component. |
RateI | Required | The inflation (real) interest rate used for discounting the bond's cash flows. |
Sp | Required | The credit spread (in basis points) that is added to the inflation interest rate. |
LCPI | Required | The CPI level at the value date. |
VDate | Required | The value date. |
Comp | Required | The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
Steps | Required | The number of steps in the binomial tree: at least one per coupon or principal period. |
RM | Required | The risk measure type (DV01, ModifiedDuration, Convexity, Delta, Gamma, Vega, Theta) |
RMForm | Optional | The form of DV01, Delta, Gamma, Vega and Theta (Amount: for the whole face value; Percent: per 100 of face value). Blank: Amount. |
ShiftedRates | Optional | The interest rates the DV01, ModifiedDuration and Convexity move (Nominal, Inflation, Both). Blank: Both. |
See also: GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_ValueFromCurve, GIA_Bonds_ConvertibleInflation_Zspread
GIA_Bonds_ConvertibleInflation_RiskFromCurve
Returns the risk measures (DV01, Modified Duration, Convexity, KR01, Bucket DV01, Key Rate Duration, Bucket Duration, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond, given a nominal and a real (inflation) interest rate curve for discounting future cash flows.
GIA_Bonds_ConvertibleInflation_RiskFromCurve(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, NCurveDates, NCurveRates, ICurveDates, ICurveRates, Sp, LCPI, VDate, Comp, Days, Interp, Steps, RM, [RMForm], [ShiftedCurves], [StartTerm], [EndTerm])Returns: Risk measures (DV01, Modified Duration, Convexity, KR01, Bucket DV01, Key Rate Duration, Bucket Duration, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond
| Argument | Use | Description |
|---|---|---|
FaceValue | Required | The bond's face value. |
ConversionRatio | Required | The number of shares received on conversion. |
ConversionRatioType | Required | What the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value) |
StartDate | Required | The start date of the bond's first accrual period. |
MDate | Required | The bond's maturity date. |
CRate | Required | The bond's fixed coupon rate. |
CFr | Required | The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly) |
FPPD | Required | The first principal payment date. Blank or the maturity date: the whole principal is paid at maturity. |
FrPP | Required | The frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly) |
BCPI | Required | The CPI level at the inception of the deal. |
S | Required | The spot price of the underlying asset. |
Vol | Required | The volatility of the underlying asset. |
DividendYield | Required | The continuous annual dividend yield. |
NCurveDates | Required | The array of dates in the nominal interest rate curve, which drives and discounts the equity component. |
NCurveRates | Required | The array of rates in the nominal interest rate curve, which drives and discounts the equity component. |
ICurveDates | Required | The array of dates in the inflation (real) interest rate curve used for discounting the bond's cash flows. |
ICurveRates | Required | The array of rates in the inflation (real) interest rate curve used for discounting the bond's cash flows. |
Sp | Required | The credit spread (in basis points) that is added to the inflation curve. |
LCPI | Required | The CPI level at the value date. |
VDate | Required | The value date. |
Comp | Required | The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
Interp | Required | The interpolation method (Linear, LogLinear, CubicSpline, Exponential) |
Steps | Required | The number of steps in the binomial tree: at least one per coupon or principal period. |
RM | Required | The risk measure type (DV01, ModifiedDuration, Convexity, KR01, BucketDV01, KRDuration, BucketDuration, Delta, Gamma, Vega, Theta) |
RMForm | Optional | The form of DV01, KR01, BucketDV01, Delta, Gamma, Vega and Theta (Amount: for the whole face value; Percent: per 100 of face value). Blank: Amount. |
ShiftedCurves | Optional | The interest rate curves the interest rate measures move (Nominal, Inflation, Both). Blank: Both. |
StartTerm | Optional | The starting term for Bucket and Key Rate measures. |
EndTerm | Optional | The ending term for Bucket and Key Rate measures. |
See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_ValueFromCurve, GIA_Bonds_ConvertibleInflation_Zspread
GIA_Bonds_ConvertibleInflation_Value
Returns the value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments, given a nominal interest rate and a real interest rate for discounting future cash flows.
GIA_Bonds_ConvertibleInflation_Value(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, RateN, RateI, Sp, LCPI, VDate, Comp, Days, Steps)Returns: Value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments
| Argument | Use | Description |
|---|---|---|
FaceValue | Required | The bond's face value. |
ConversionRatio | Required | The number of shares received on conversion. |
ConversionRatioType | Required | What the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value) |
StartDate | Required | The start date of the bond's first accrual period. |
MDate | Required | The bond's maturity date. |
CRate | Required | The bond's fixed coupon rate. |
CFr | Required | The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly) |
FPPD | Required | The first principal payment date. Blank or the maturity date: the whole principal is paid at maturity. |
FrPP | Required | The frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly) |
BCPI | Required | The CPI level at the inception of the deal. |
S | Required | The spot price of the underlying asset. |
Vol | Required | The volatility of the underlying asset. |
DividendYield | Required | The continuous annual dividend yield. |
RateN | Required | The nominal interest rate, which drives and discounts the equity component. |
RateI | Required | The inflation (real) interest rate used for discounting the bond's cash flows. |
Sp | Required | The credit spread (in basis points) that is added to the inflation interest rate. |
LCPI | Required | The CPI level at the value date. |
VDate | Required | The value date. |
Comp | Required | The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
Steps | Required | The number of steps in the binomial tree: at least one per coupon or principal period. |
See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_ValueFromCurve, GIA_Bonds_ConvertibleInflation_Zspread
GIA_Bonds_ConvertibleInflation_ValueFromCurve
Returns the value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments, given a nominal and a real (inflation) interest rate curve for discounting future cash flows.
GIA_Bonds_ConvertibleInflation_ValueFromCurve(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, NCurveDates, NCurveRates, ICurveDates, ICurveRates, Sp, LCPI, VDate, Comp, Days, Interp, Steps)Returns: Value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments
| Argument | Use | Description |
|---|---|---|
FaceValue | Required | The bond's face value. |
ConversionRatio | Required | The number of shares received on conversion. |
ConversionRatioType | Required | What the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value) |
StartDate | Required | The start date of the bond's first accrual period. |
MDate | Required | The bond's maturity date. |
CRate | Required | The bond's fixed coupon rate. |
CFr | Required | The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly) |
FPPD | Required | The first principal payment date. Blank or the maturity date: the whole principal is paid at maturity. |
FrPP | Required | The frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly) |
BCPI | Required | The CPI level at the inception of the deal. |
S | Required | The spot price of the underlying asset. |
Vol | Required | The volatility of the underlying asset. |
DividendYield | Required | The continuous annual dividend yield. |
NCurveDates | Required | The array of dates in the nominal interest rate curve, which drives and discounts the equity component. |
NCurveRates | Required | The array of rates in the nominal interest rate curve, which drives and discounts the equity component. |
ICurveDates | Required | The array of dates in the inflation (real) interest rate curve used for discounting the bond's cash flows. |
ICurveRates | Required | The array of rates in the inflation (real) interest rate curve used for discounting the bond's cash flows. |
Sp | Required | The credit spread (in basis points) that is added to the inflation curve. |
LCPI | Required | The CPI level at the value date. |
VDate | Required | The value date. |
Comp | Required | The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
Interp | Required | The interpolation method (Linear, LogLinear, CubicSpline, Exponential) |
Steps | Required | The number of steps in the binomial tree: at least one per coupon or principal period. |
See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_Zspread
GIA_Bonds_ConvertibleInflation_Zspread
Returns the Z-spread of an inflation-linked convertible bond: the credit spread over the inflation (real) interest rate curve at which the bond is worth its given value.
GIA_Bonds_ConvertibleInflation_Zspread(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, Value, NCurveDates, NCurveRates, ICurveDates, ICurveRates, LCPI, VDate, Comp, Days, Interp, Steps)Returns: Z-spread of an inflation-linked convertible bond: the credit spread over the inflation (real) interest rate curve at which the bond is worth its given value
| Argument | Use | Description |
|---|---|---|
FaceValue | Required | The bond's face value. |
ConversionRatio | Required | The number of shares received on conversion. |
ConversionRatioType | Required | What the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value) |
StartDate | Required | The start date of the bond's first accrual period. |
MDate | Required | The bond's maturity date. |
CRate | Required | The bond's fixed coupon rate. |
CFr | Required | The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly) |
FPPD | Required | The first principal payment date. Blank or the maturity date: the whole principal is paid at maturity. |
FrPP | Required | The frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly) |
BCPI | Required | The CPI level at the inception of the deal. |
S | Required | The spot price of the underlying asset. |
Vol | Required | The volatility of the underlying asset. |
DividendYield | Required | The continuous annual dividend yield. |
Value | Required | The bond's value, for the whole face value. |
NCurveDates | Required | The array of dates in the nominal interest rate curve, which drives and discounts the equity component. |
NCurveRates | Required | The array of rates in the nominal interest rate curve, which drives and discounts the equity component. |
ICurveDates | Required | The array of dates in the inflation (real) interest rate curve used for discounting the bond's cash flows. |
ICurveRates | Required | The array of rates in the inflation (real) interest rate curve used for discounting the bond's cash flows. |
LCPI | Required | The CPI level at the value date. |
VDate | Required | The value date. |
Comp | Required | The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
Interp | Required | The interpolation method (Linear, LogLinear, CubicSpline, Exponential) |
Steps | Required | The number of steps in the binomial tree: at least one per coupon or principal period. |
See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_ValueFromCurve
