Set up a Standard Interest Rate Series
Security Note: You need the Allow the user to edit interest rate series security right in the Marketing user group security rights group for this activity.
Activity Steps
- Open the Interest Rate Editor.
- Select the Interest Rate Series tab.
- To create a standard interest rate series:
- Right-click in the Interest Rate Series field group and select New » Interest Rate Series from the menu.
- Update the Interest Rate Series name if required.
- Complete the following fields.
- Source Market—Name of the source market supplying the interest rates.
- Decimals—Number of decimal places used for the interest rates in the series.
- Currency—Optional currency to which to limit the interest rate series.
- Entry Frequency—Frequency at which interest rates updates are available and need to be entered. Select from Day, Week, Month, Quarter, Half Year and Year.
- If the Entry Frequency is Day, enter the Series Calendars to define the business days. Select from the calendars defined in the Calendar Editor.
- Check Mandatory Entries if required. If entries are mandatory and an interest rate has not been entered for a particular date, an error displays when the interest rate is used, except if the date falls on a non-working day defined in one of the selected Series Calendars.
- Enter a Description if required.
- To enter interest rates for the interest rate series:
- Enter the following search criteria in the Interest Rates field group:
- Start Date
- End Date
- Click Search.
- Enter the Interest Rate for each Effective Start date.
Note: Negative rates can be entered. Press Ctrl+V to paste a column of data copied from another application, such as a spreadsheet.
- Enter the following search criteria in the Interest Rates field group:
- Click Save.