R Package API Use: BcurveStrip Function for Bloomberg Excel Add-in

R Package API Use: BcurveStrip Function Bloomberg Excel Add-in

The Bloomberg Excel Add-in is a powerful tool that allows users to access financial data and analytics directly within Microsoft Excel. One of the key functions of the Bloomberg Excel Add-in is the BCURVESTRIP function, which can be used to create a curve object using a series of spot rates with different tenors.

Creating a Curve Object with BCURVESTRIP

The BCURVESTRIP function takes the following syntax:

Where:

• spot_rates: A range of spot rates with different tenors
• curve_id: A unique identifier for the curve
• tenors: A range of tenors corresponding to the spot rates
• day_count_convention: The day count convention to use for the curve
• interpolation: The interpolation method to use for the curve
• extrapolation: The extrapolation method to use for the curve

Here is an example of how to use the BCURVESTRIP function:

In this example, the spot rates are stored in cells A1 through A5, and the corresponding tenors are stored in cells B1 through B5. The curve is identified as "MyCurve", and the day count convention is set to "ACT/ACT" (actual/actual). The interpolation method is set to "Linear", and the extrapolation method is set to "Constant".

Computing Forward Rates

Once a curve object has been created using the BCURVESTRIP function, it can be used to compute forward rates. The forward rate between two tenors can be computed using the FWARD function.

The FWARD function takes the following syntax:

Where:

• curve_id: The unique identifier of the curve
• tenor1: The tenor of the first forward rate
• tenor2: The tenor of the second forward rate
• day_count_convention: The day count convention to use for the forward rate

Here is an example of how to use the FWARD function:

In this example, the forward rate between a 1-year tenor and a 2-year tenor is computed using the "MyCurve" curve object and the "ACT/ACT" day count convention.

The BCURVESTRIP function in the Bloomberg Excel Add-in is a powerful tool for creating curve objects using spot rates with different tenors. Once a curve object has been created, it can be used to compute forward rates using the FWARD function. By using these functions, users can easily access and analyze financial data within Microsoft Excel.

References

• Bloomberg API Library

• Excel Add-in Function Reference Index

• Using the Bloomberg R Package API to Import and Analyze Data