1. User Guide
  2. Interest Rate Curve
  3. Creating an Interest Rate Curve
  4. Interest Rate Curve Tabs
  5. Historical Rates Tab
  6. Excel Import or Export

Excel Import or Export

To aid in data entry, use the Excel Import or Export functionality to add or edit rate data to Historical Rates. This is an optional step.

Excel Export:

To export the data, perform the following steps:

  1. Click Export to export data for the chosen selected effective date range. Within the same block, select Export to Excel, which launches the Excel application and displays the Data Window including headers.

Excel Import:

The excel file exported above can be used as a template to import the Historical Rates.

Note:

Ensure that the date format is yyyy-MM-dd in the excel file. For example, 2022-06-13.
  1. On the Interest Rates toolbar, click the Import icon. Select the file containing the Historical Rates.
  2. Data from the file is displayed on the UI. If appending data that pre-existed for the same effective date, the import will overwrite existing data.
  3. Add or edit data if required.
  4. Click Apply to save.