Maintaining Basis Rates (W5)

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

PURPOSE

This document describes how to add and maintain basis rate in the system.

WHY IS THIS IMPORTANT?

Basis rate maintenance allows the basis rate for floating rate to be maintained in the CS Lucas system. Basis rate maintenance is also used in maintaining the lending and borrowing rate for intercompany transactions. 

PROCEDURE

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

blank

2. From the Interest Rate Maintenance screen, click on Basis Rates. The screen below will be displayed.

blank

3. To add a new basis rate, click Add.

blank

4. Fill in the fields. Choose the Currency (Ccy) from the dropdown.

5. Select Basis. This is user definable. For details on how to set up float basis, see how to create user definable field.

6. Input the VDate or Value Date.

7. Type in the Rate.

blank

8. Click Save.

9. From the Basis Rate Maintenance screen, select the Ccy, Basis, From Date and To Date and click Refresh to filter out the basis rate added.

blank

10. From the same screen, the Rate may be amended as needed by changing the rate, then clicking Save.

11. If adding multiple basis rates, click Import and the Import Basis Rates screen will be displayed.

blank

12. Click Template to download the import template.

blank

13. Browse to the desired file location and click Save.

14. Open the saved Excel file.

blank

15. Fill in the fields. Fields with an asterisk (*) are mandatory.

blank

16. Once fields are filled out, save the import template.

17. Go back to the Import Basis Rates menu, click Read File checkbox.

blank

18. Click Choose File and search for the previously saved import template.

blank

19. Click Read File. All the values entered in the Excel template will be displayed.

blank

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

21. Click Load when no errors detected. When a popup appears, click OK.

blank

22. You will see a successfully loaded message.

blank

23. To view the imported basis rates, select the Ccy, Basis, From Date and To Date as appropriate, and click Refresh to filter out the imported basis rates. Below is the screenshot for the FLOAT basis rates imported.

blank

Below is the screenshot for the Libor 3 mth basis rates imported.

blank

FREQUENTLY ASKED QUESTIONS

FAQ01. I am not able to access Basis Rate Maintenance.

Access rights 12513 Access Basis Rates are required to access the Basis Rate Maintenance screen. Please check with your administrator to obtain the rights.

RELATED INFORMATION

Call/ Sweep Set Up

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