PURPOSE
To provide the details used by CS Lucas to show Money Market Movement sort by Counterparty ID and Currency.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Money Market Trade.
QUERY
1. Navigate to Reporting > Standard > Report 2022: Money Market Transaction Analysis.
2. Fill in the mandatory parameters – Acct Cntr, From Date and To Date, Borrow/Lend, Report Currency and Rate Type. The rest are optional parameters.
3. Click Action and select the required format.
4. The report shows the Accounting Centre, Counterparty ID, Trade ID, VDate, MDate, Days, Rate, Interest, Currency, Principal (Amount), New and Matured.
For explanation of Excel Raw export, please see link.
For explanation of buttons, please see link.
DATA SOURCE
To view the following transaction,
Follow the steps as shown below:
1. Navigate to Transaction > Money Market.
2. Key in the Mdate From: 01/06/2017.
3. Select Ctpy: DBS-SG.
4. Select Transaction: Lend/Place.
5. Click Refresh.
6. Click on the Edit button of the trade (From example: MMK100001.00) to drill down to the Amend Money Market screen.
7. F = Number of days between VDate (D) and MDate (E). MDate (E) – VDate (D).
8. L = Exchange Rate (Valuation/ Accounting/ Alternate based on selected Rate Type). Navigate to Prices > Exchange Rate.
9. M = New Principal in the reporting currency. Principal (J) * Ex Rate (L).
10. N = Outstanding Principal in the reporting currency as at reporting to date. Principal (K) * Ex Rate (L).
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments