Automatic Events Executed during End of Day

5.1 Automatic Events Executed during End of Day

This topic describes the automatic events such as revaluation (revl), amortization, auto exercise and Rate Reset (RTFX and EXER), knock in and knock out (Event KNIN and KNOT), auto settlement KNST, KIST, PRPT), auto expiry (EXPR), and auto expiry (EXPR).

This section contains the following topics:

Revaluation (REVL)

Revaluation of a contract is performed as per your specification for the product involving the contract. If you have indicated that revaluation must be performed for the product, all entries for a product is netted based on a common currency and buy-sell indicator.

Revaluation is performed for the specified frequency for the following events:

BOD/EOD
Contract Exercise (Final exercise only in case of IRO’s)
Contract termination
Contract Expiry

Table 5-1 Revaluation - Events

Event	Function
BOD/EOD	The BOD operations for revaluation runs only till the previous day, because in cases when the revaluation frequency falls on the current day, the market value of the contract can be different than it was the previous day. During the BOD/EOD process, only the confirmed market fair value of the contract for revaluation is picked up from the Contract Fair Value Maintenance screen. An exception is raised if the system finds that a fair value has not been confirmed or if it is non-existent.
Revaluation during Contract Termination	During contract Termination, revaluation is triggered at Fair Value of the contract, captured at the time of terminating the contract. The termination gain loss is posted according to whether the contract being terminated is a trade/hedge contract and whether the bank has bought or sold (written the contract).
Revaluation during Contract Expiry	During contract Expiry, revaluation is triggered at zero. This means that if the contract expires worthless, the buyer of the option incurs a revaluation loss equivalent to the option premium paid (by the buyer) at the time of the inception of the contract.
Revaluation during Contract Exercise	During contract Exercise, revaluation is triggered at the Settlement Amount when the final exercise is done. The settlement amount is calculated by the system. For a purchased collar if the Floor is in-the-money in the final exercise, revaluation is triggered at zero which would essentially mean that the option buyer paying for in-the-money Floor loses the option premium and the settlement amount during the final exercise along with an income or a loss as can be the case in intermediate settlements. For a Collar with in-the-money Cap, Revaluation is triggered at settlement amount. In case of a currency option being knocked out, revaluation is triggered at zero.

During final exercise,

Revaluation is done at the contract level even though the revaluation level can be marked as Product in the product Preferences screen.
Premature termination, knock out or expiry of the contract, final revaluation gain/loss is recognized as income/expense and posted to the respective GLs.

Note:

Revaluation event is not triggered if the fair value of the option has not changed since the last revaluation was done.

External Revaluation

Here the revaluation is done based on the external values which is provided as the input (revaluated profit or loss) to the system.

Once the External revaluation option is enabled at branch parameter, the EOD batches in the system does not calculate any profit or loss for the contracts. Instead add OBTR will post accounting entries for external revaluation, on receiving profit/loss amount from external system.

Note:

If the option external revaluation is enabled and the MTM value is not received, the system skips the revaluation for the particular contract and the system logs exception into a table.

External MTM upload through Webservice

The External MTM value received is in XML format for a contract.

An Operation CreateExtMTMValue is used to upload OT external value for a contract through the gateway.

The following fields are mentioned in the incoming file:

Table 5-2 Fields in the incoming files

Field	Description
Source Code	Source Code of the upload
Upload Date	Date when XML is uploaded
Upload time	Time of the upload
Effective Date	Revaluation/Value Date used in accounting
Market Date	MTM fair Value date
Branch Code	Branch Code of the bank.
Contract Ref No	Reference Number of the contract for which MTM value upload is being done.
Profit & Loss CCY	Revaluation CCY
Profit & Loss Value Calculated	Profit and Loss (External System)

An error is raised when

The Contract reference number is not valid.
Duplicate record exists for the contract reference number and revaluation date.
Revaluation date is greater than the application date.
Contract is not active.

External MTM upload through GI

The Bulk Upload of external MTM value is supported though GI.

User can define properties, formats and components associated with interface file in the Interface Definition (GIDIFTDF) screen. For uploading the rate fixed contracts from external system into OBTR, select the interface type as Incoming and the interface code as OTDETMTM.

The following fields are mentioned in the incoming file:

Table 5-3 Fields in the incoming file

Field	Description
Source Code	Source Code of the upload
Upload Date	Date when XML is uploaded
Upload time	Time of the upload
Effective Date	Revaluation/Value Date used in accounting
Market Date	MTM fair Value date
Branch Code	Branch Code of the bank.
Contract Ref No	Reference Number of the contract for which MTM value upload is being done.
Profit & Loss CCY	Revaluation CCY
Profit & Loss Value Calculated	Profit & Loss (External System)
No of Records	Total number of records in the file

The Error code validations are same as the web services, refer to the above section.

OT_MTMUPLOAD is defined and scheduled to pick the records from external system though GI for processing.

User can trigger the process of Generic Interface using through Interface Trigger GIDIFPRS screen.

For more information on GI, refer to GI User Guide.

On successful upload of external MTM Value, external revaluation event is triggered and the system posts the accounting entries.

External Revaluation Process

External Revaluation is done based on OT Branch Parameter. If External Revaluation is at Branch Level, the branch revaluation is always executed externally.
If External Revaluation is at Product Level, system checks the External Revaluation Required flag at Product. If the flag is checked, the revaluation happens externally and if the flag is Unchecked revaluation happens internally on EOD batch processing.
If the MTM value is uploaded for only one contract, the data is received using Webservice, and on successful acknowledgment, the external revaluation (EXRV) event is triggered online to perform the revaluation entries online.
In case of the bulk upload, the data is received though GI, and on successful acknowledgment the external revaluation (EXRV) event is triggered online to perform the revaluation entries online.
If External revaluation parameter is enabled, the OT batch does not execute the internal revaluation.
In case OBTR does not receive any MTM value for any particular day, system skips revaluation for the particular contract on the day.

Note:
The system supports the back dated External Revaluation.
When OBTR receives back dated External revaluation after year- end, Profit and Loss adjustment entries are posted manually as Journal entry. User operationally handle the same.
Events Impacted on Revaluation:
TERM - On termination Contract fair value or manual termination is uploaded through gateway , and revaluation gain/loss calculated based on the uploaded value. Revaluation reversal and revaluation Gain/ Loss is posted in TERM event. EXRV Event triggers along with TERM event for income and expense GL movement.
EXPR - Revaluation reversal and revaluation Gain/ Loss are posted in EXPR event. EXPR Event triggers along with EXPR event for income and expense GL movement.
EXER - Revaluation reversal and revaluation Gain/ Loss are posted in EXER event. EXRV Event trigger along with EXER event for income and expense GL movement.
KNOT - Revaluation reversal and revaluation Gain/ Loss are posted in KNOT event. EXRV Event triggers along with KNOT event for income and expense GL movement
Calculation for external revaluation loss/gain is same as internal revaluation @ TERM, EXPR,EXER,KNOT.

Example for External Revaluation:

A CO Call Buy deal is booked on 15th July with external revaluation. On 17th receiving P&L amount as 150 GBP for 16th July.

Event EXRV (External Contract Revaluation) details as below:

Table 5-4 Event details

Accounting Role	Amount Tag	Debit/Credit	Amount	CCY	Transaction date	Value Date
MKT_VAL_PUR_OPT	PUR_REVL_GAIN	Dr	150	GBP	17-Jul-20	16-Jul-20
V_GAIN_PUR_OPT	PUR_REVL_GAIN	Cr	150	GBP	17-Jul-20	16-Jul-20

On 18th receiving P&L amount as -75 GBP for 17th July

Event EXRV (External Contract Revaluation) details are as below, also revaluation reversal entries fires along with current revaluations

Table 5-5 Event details

Accounting Role	Amount Tag	Debit/Credit	Amount	CCY	Transaction date	Value Date
RV_LOSS_PUR_OPT	PUR_REVL_LOSS	Dr	75	GBP	18-Jul-20	17-Jul-20
MKT_VAL_PUR_OPT	PUR_REVL_LOSS	Cr	75	GBP	18-Jul-20	17-Jul-20
RV_GAIN_PUR_OPT	PUR_LAST_REVL_GAIN	Dr	150	GBP	18-Jul-20	18-Jul-20
MKT_VAL_PUR_OPT	PUR_LAST_REVL_GAIN	Cr	150	GBP	18-Jul-20	18-Jul-20

Amortization

Amortization of a contract is performed as per the amortization parameters specified for the product. If you have indicated that amortization must be at the product level all the entries for a product are netted based on a common currency and buy-sell indicator.

The system performs amortization for the following amounts:

Deferred Inception Gains
Deferred Termination Gains (Hedge deals only)
Time Value of Option Premium (Only for Hedge deals)

Table 5-6 Amortization - Amount

Event	Function
Amortization of Deferred Inception Gains (AMRT)	Inception gain is amortized over the period from the contract value date till the contract maturity date (termination date, if the contract is terminated prematurely), even though the premium can be paid anytime between the booking date and the value date of the contract. At the time of final exercise, premature termination or expiry of the contract, amortization gain is recognized as income and posted to the respective GL. Inception loss is not amortized and is recognized as an expense upon saving the options contract itself.
Amortization of Deferred Termination Gains (AMDG)	Amortization of deferred termination gain is performed only if the Amortize Termination Gain option is enabled while terminating the contract. Inception gain is amortized over the period from the contract termination date till the contract maturity date. At the time of expiry of the contract, deferred termination gain is recognized as income and posted to the respective GL. Termination loss (if any) is not amortized and is recognized as an expense upon saving the option contract termination. Amortization of deferred termination gains are done only for hedge deals. For trade deals, termination gains are recognized as income on the termination of the contract.
Amortization of Time Value (REVL)	Amortization of Time Value is meant only for hedge deals. The amortization is done from the Value Date till the contract Maturity Date. If the contract is terminated prematurely (or at the time of final exercise), the remaining time value is recognized as expense and is posted to an expense GL. Though time value is said to be amortized, it is a revaluation of the hedge contract in the real sense. This is why the revaluation parameters (Level, frequency, and so on) you have specified at the product level is used for this. Accounting entries for amortization of time value can also be defined under the revaluation event (REVL).

Event

Function

Amortization of Deferred Inception Gains (AMRT)

Inception gain is amortized over the period from the contract value date till the contract maturity date (termination date, if the contract is terminated prematurely), even though the premium can be paid anytime between the booking date and the value date of the contract.

At the time of final exercise, premature termination or expiry of the contract, amortization gain is recognized as income and posted to the respective GL. Inception loss is not amortized and is recognized as an expense upon saving the options contract itself.

Amortization of Deferred Termination Gains (AMDG)

Amortization of deferred termination gain is performed only if the Amortize Termination Gain option is enabled while terminating the contract. Inception gain is amortized over the period from the contract termination date till the contract maturity date.

At the time of expiry of the contract, deferred termination gain is recognized as income and posted to the respective GL. Termination loss (if any) is not amortized and is recognized as an expense upon saving the option contract termination.

Amortization of deferred termination gains are done only for hedge deals. For trade deals, termination gains are recognized as income on the termination of the contract.

Amortization of Time Value (REVL)

Amortization of Time Value is meant only for hedge deals. The amortization is done from the Value Date till the contract Maturity Date. If the contract is terminated prematurely (or at the time of final exercise), the remaining time value is recognized as expense and is posted to an expense GL.

Though time value is said to be amortized, it is a revaluation of the hedge contract in the real sense. This is why the revaluation parameters (Level, frequency, and so on) you have specified at the product level is used for this. Accounting entries for amortization of time value can also be defined under the revaluation event (REVL).

Auto Exercise and Rate Reset for Interest Rate Options
This topic describes the auto exercise and rate reset (RTFX and EXER) for interest rate options.
Currency Options
This topic describes the auto exercise, settlement, knock in and knock out, auto settlement, and auto expiry process for currency options.

Parent topic: Automatic Daily Processing