1. Asset Liability Management User Guide
  2. OFSAA Rate Management
  3. Currency Rates
  4. Excel Compatibility

5.4.8 Excel Compatibility

This functionality is used for adding or editing historical exchange rates from an Excel sheet. You can right-click on any cell in the table and perform the following actions:

  • Delete or Insert multiple rows.
  • Apply a Formula on a particular column.
  • Export the data to excel using the Save As option.
  • You can copy data from excel and paste the same using standard copy, paste shortcuts Ctrl+C and Ctrl+V.

Figure 5-12 Historical Rates Tab


The historical rate tab allows you to delete or insert multiple rows, apply a formula on a particular column, export the data to an Excel sheet, copy data from Excel and paste it in the different columns.