5.1.2.1.5 Managed Rates

Managed rates are IRC objects that are based on a logical and/or mathematical formula instead of being based on a yield curve. This is useful if you do not have a straight forward application function that generates a rate based on a formula. Managed Rates are formula-driven IRC (interest rate curve or yield curve) objects. The Managed Rates UI provides the following functionalities:

• Allows to create a managed rates formula with the help of equation builder.
• You can create a managed rates formula by using existing IRC, Currency, Economic Indicator objects and combining it with various mathematical operators.
• Execute managed rates using Scheduler Service

Managed Rate Formulas

Managed Rates are free form, user-defined formula, that is, equation based objects. You can use a variety of mathematical, logical, or reference functions to define a Managed Rate. Regardless of the complexity of the function, it always return only one numerical value every time when it is evaluated.

For example, there are three basic inputs for Market Rates formulas:

Numerical and mathematical values, including embedded functions (for example, "SUM" or "AVERAGE").

Existing Rate Management objects such as interest rate curves, economic indicators, and foreign currencies

Reference in time specification, that is, a relative or absolute reference in time either in the past, present, or future.

Note:

Formulas are statements. These can be mathematical, logical, or reference one or more Application objects, but it returns a single numerical value.

For example:

Formula input: 1+1

Returns: 2

It is not mandatory to include the "=" symbol in the expression as this is already implied.

There is no nominal value of the rate, that is, it cannot be an accrual, day count, compounding, or other rate identities; it is simply a number.

Basic syntax is required if other service objects are reference, then you must specify three distinct components:

1. Object type code or name
2. Object ID
3. Tenor
4. Place in time in the forecast

[Object type code].[Object ID].[Tenor if IRC, 0 if anything else].[Place in time]

For example, suppose you want a formula that refers to an interest rate curve's 1 month tenor on a current basis, then its syntax would look something like this:

Figure 5-7 Example of Managed Rate

Here,

[IRC_202] is the IRC code (Object ID)

[1M] is the Term.

[0] is time. This calculates Past, present or future dates/rates with ease for any term/tenor and forecast method definition. The default value is 0. [0] means the now. [-1] refers to back one period. [$] refers to constrained time period.

Note:

If the time value falls outside of provided numbers, the Application will refer to the closest matching value. If no value can be retrieved or if the value is null, then the Managed Rate formula will not be evaluated.

Managed Rate Processes

When you validate Managed Rates, it is processed under two conditions:

1. Managed Rates for Historical Values

   You can use the entered managed rate to derive one or more historical values as specific points in time at or before the current As-of Date.

   Function is executed at the Rate Management level for Managed Rate functions. Specify one or more historical dates that you want to processed and then execute a batch to derive the associated values. All historical values would be stored in a managed rate historical table.

   If a Managed Rate formula has time references that are constrained, the formula will default to the last available value provided. If no value is provided (e.g. value cannot be retrieved or is null), then no rate will be provided for that historical date.

2. Managed Rates for Forecasted Values

   For forecasted values in an ALM process as established in Forecast Rates. Managed Rates will be forecasted using the forecasted base objects like IRC, Currency and Economic Indicator.

   For more information, see Interest Rate Forecast Methods.

To define Managed Rate, follow these steps:

1. Select Structure Type as Managed Rates.
2. Navigate to Managed Rates tab.

   Note:

   This tab will be active only when Structure Type is selected as Managed Rates.
3. Select the Function type as Interest Rate Curve, Currency, or Economic Indicator to define a formula.
4. Double-click the Function code to move it to Formula section.
5. Update the formula. Use arithmetical operator from Operator to define formula if required.

   Figure 5-8 Formula section

   
   

   

   
   

   Interest Rate Curve

   This function evaluates rate of selected term point of Interest Rate Curve, in the past, present or future

   IRC(Name, Term_Point, Time_Reference) Time_Reference indicates the rate to be forward or backward looking. 0 indicates current period, positive value indicate forward time and negative value indicates prior period. It can also be relative (moving) or absolute (fixed). Use '$' symbol for absolute Term Reference.

   Currency

   This function evaluates exchange rate of selected currency pair in the past, present or future

   CCY(From_Currency, To_Currency, Time_Reference) Time_Reference indicates the rate to be forward or backward looking. 0 indicates current period, positive value indicate forward time and negative value indicates prior period. It can also be relative (moving) or absolute (fixed). Use '$' symbol for absolute Term Reference.

   Economic Indicator

   This function evaluates value of selected Economic Indicator in the past, present or future

   ECOIND(Name,Time_Reference) Time_Reference indicates the rate to be forward or backward looking. 0 indicates current period, positive value indicate forward time and negative value indicates prior period. It can also be relative (moving) or absolute (fixed). Use '$' symbol for absolute Term Reference.

6. Click Validate. A successful formula validation message is displayed.
7. After defining and verifying the Managed Rates, execute the IRC using scheduler service.

Executing Managed Rates using Scheduler

To execute the batch, navigate to Operations and Processes and select Scheduler. Select Schedule Batch and search for Historical Managed Rates and execute.

OR

You can also define new batch to execute the Managed Rates by the following these steps:

1. Navigate to Operations and Processes, select Scheduler, and then select Define Batch.
2. Create a new Batch with a new Task with Component as IRC Managed Rates.
3. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Schedule Batch to execute the batch. Select the batch and click Execute. For more details about Scheduler processes, see the Scheduler Services.
4. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Monitor Batch. There may be multiple executions of the batch. Select the latest execution and click Start Monitor.

   The UI displays the status of the batch.