Import Interest Rate Swap Trades (W5)

This version is superseded. Click here to view the latest guide.

PURPOSE

This document shows the detailed procedure for importing interest rate swap trades.

WHY IS THIS IMPORTANT?

This helps during the migration of existing trades into the system during initial implementation where the transactions can be imported in bulk.

PROCEDURE

1. From the Main Menu, select Transaction > Interest Rate Swap.

2. Click New.

blank

3. Click Import. Import Intererst Rate Swap Trades screen displays.

blank

4. Click Template to download CS Lucas template for importing interest rate swap.

blank

5. Save the file and open. An Excel sheet will be opened.

blank

6. There are two tabs in the Load_IRS_Template. Fill in the fields in both “IRS_Trades” and “IRS_Structure” tabs. Those with asterisk (*) are mandatory. For more information on each field, see Create Interest Rate Swap.

“IRS_Trades” tab

blank

“IRS_Structure” tab

blank

7. Save the Excel file on the computer.

8. Go back to the Import Interest Rate SwapTrades screen, tick on Read File checkbox.

9. Click Choose File. Browse for the file saved in the computer.

blank

10. Click Read File. The values inputted in the Excel File will displays.

blank

11. If there is an error, the user will be prompted with the rows to be corrected. To make corrections, go to the Excel file to make the necessary corrections and click Read File again.

12. If there is no error, click Load.

13. When a popup appears, click OK.

blank

14. A message saying that load was successful will be displayed. Trade ID will be assigned to the successfully loaded trades.

blank

FREQUENTLY ASKED QUESTIONS

 

RELATED INFORMATION

Create Interest Rate Swap

CHANGE HISTORY

blank

Categories:

0 Comments

Leave a Reply

blank

Your email address will not be published. Required fields are marked *



    Close Bitnami banner
    Bitnami