Excel Add-In for Seamless Access to IFRS-Compliant Interest Rate Curves

Streamline your valuation and reporting workflows with accurate, end-of-day interest rate curves delivered directly into Excel. Complete with discount factors, PVBP, and full market conventions.

Feature Overview
for the Derivox Excel Add-in

Instant Access to IFRS-Compliant Curves

Seamlessly pull end-of-day par rate curves, discount factors, and PVBP directly into Excel, ready for valuation, reporting, and analysis.

Full Transparency with Embedded Metadata

Each curve includes day count, compounding, index frequency, and timestamp, ensuring auditability and alignment with internal models.

Refreshable, Configurable Data Inserts

Easily configure currency, curve type, and date. Then update your workbook with one click to keep valuations current and consistent.

Frequently Asked Questions for the Excel Add-in

+

Can I refresh the data automatically?

Manual refresh is available with one click. Auto-refresh can be enabled via Excel macros or workbook-specific logic if needed.

+

What data is included when I insert a curve?

Each insert includes par rates, discount factors, PVBP, and full market conventions (day count, frequency, etc.).

+

Do I need to install anything to use the Excel Add-in?

Yes, the Derivox Excel Add-in can be installed directly from Microsoft AppSource or via Excel's “Get Add-ins” menu. Once installed, it appears in the ribbon and opens a task pane where you can configure and fetch curve data.

+

Can I choose which currency and curve to insert?

Yes, the task pane lets you filter by currency, curve type (e.g., OIS, IBOR, ARR), and valuation date. This gives you full control over which data you bring into your spreadsheet.

+

Can I share workbooks that use the Add-in with colleagues?

Yes, but each user will need their own Derivox API key to fetch live data. Alternatively, you can share static exports or embed values directly after insertion. We recommend each user has their own API key for security, auditability, and optimal support.

+

Is this data suitable for IFRS valuation or hedge accounting?

Yes, all curves retrieved via the Excel Add-in are IFRS-compliant, and include the necessary inputs and conventions used in accounting, hedge effectiveness testing, and regulatory reporting.

Get Accurate Data. IFRS-Ready. Without Complex Licensing or Hidden Fees.

Contact Sales