PURPOSE
To provide the details used by CS Lucas to show Portfolio Money Market Trade by Trade ID in different Accounting Centre.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Money Market Trade.
QUERY
1. Navigate to Reporting > Standard > Report 2011: Portfolio Money Market Trade By TradeID.
2. Select Accounting Centre and Portfolio. The dates are optional parameter.
3. Click Action and select the required format.
4. The report shows the Type, Trade ID, Accounting Centre, Counterparty ID, TDate, VDate, MDate, Currency, Principal (Amount), Interest, MAT Proceeds (Total Amount with Interest), Rates, Accrual Method and Narrative.
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. Select Acct Cntr* (From example: TFS-SG)
3. Key in MDate Fr* (From Example: 01/07/2017)
4. Click Refresh.
5. Click on the Trade ID (From example: MMK100001.00) to drill down to the Amend Money Market screen.
6. K = Maturity Proceeds. Principal (I) + Interest (J).
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments