Import Interest Rates (W5)

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

PURPOSE

This document describes how to import interest rates into CS Lucas system.

WHY IS THIS IMPORTANT?

Import interest rate makes the maintenance of interest rates handier and saves user’s time as multiple interest rates can be imported into the system at one time.

PROCEDURE

1. From the main menu, select Prices > Interest Rate.

blank

2. Click Import. The Import Interest Rate screen will be displayed.

blank

3. Click Template to download the import template. The drive folders will display. Save the import template on the local drive of your computer.

blank

4. Choose the file location to save the import template and click Save.

5. Open the import template.

blank

6. Fill in the mandatory(*) fields as below.

Column Name Description
Date* Enter date.
Ctpy Grp* Enter short name of the counterparty group.
CtpyID* Enter short name of the counterparty. Counterparty short name must exists in the system and is a member of the counterparty group.
Ccy* Enter the currency short name.
Type* Enter as Lend/Place or Borrow/Loan.
Time Bucket* Enter the time bucket short name.
Bucket Tenor* Enter the bucket tenor. This is the description for the bucket tenor set up in the time bucket.
Rate* Enter interest rate.

 

7. Fill in the interest rates for different tenors and counterparties.

blank

8. When completed, save the import file.

9. Back to the Import Interest Rate screen, click the checkbox beside Read File.

blank

10. Click Choose File. Search for the import file saved previously.

blank

11. Click Read File.

12. If there is an error, the system will prompt the user with the errors. In that case, edit the template in your drive, save, and upload to the system again.

13. When no errors are detected, the items entered in the template will be displayed in the Import screen.

blank

14. Click Load, a popup will appear, click OK.

blank

15. The system will prompt that the interest rates are successfully loaded.

blank

16. Click Back Button to return to Interest Rate Maintenance screen.

17. To view the imported interest rates, choose Ctpy Group, Ccy, Date, and Type, and click Refresh. The interest rates that successfully imported will be displayed.

blank

FREQUENTLY ASKED QUESTIONS

FAQ01. I do not have rights to import interest rate.

Import interest rate requires access rights 12521. Please check with your administrator to grant you the required rights.

RELATED INFORMATION

Maintaining Interest Rates

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