Support #6862
[SCP ID :##3497##] : eCustody Production Report (RPT006 & RPT007) - Market Values (Bonds)
Status: | Closed - End of life cycle | Start date: | November 25, 2016 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi Najmi,
Kindly attend below request.
Recently eCustody's client highlighted on the market value issue on the eCustody Production Report (RPT006 & RPT007) for Bond's stock which shown zero values for the market value. Details will send to penril support via email.
Thank you.
History
#1 Updated by Najmi Pasarudin almost 8 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#2 Updated by Najmi Pasarudin almost 8 years ago
- % Done changed from 0 to 10
Replied to client:
Hi Siew Peng,
Currently report RPT006, RPT007 and RPT009 is using this calculation:
Market Value = (Registered Holdings+PGV Holdings+STN Holdings) X Share PriceDoes this means these reports will use Market Value = Registered Holdings x Par Value for all data?
If yes, patch for this calculation need to be applied.In addition, does currency GBP/British Pound also use the same calculation?
Thank you.
#3 Updated by Najmi Pasarudin almost 8 years ago
- % Done changed from 10 to 90
#4 Updated by Najmi Pasarudin almost 8 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- Assignee changed from Najmi Pasarudin to Nurul Akmal
- % Done changed from 90 to 100
Issue:
In report RPT006, RPT007 and RPT009, has wrong calculation for market value. Report should differentiate between bond and equity market value calculation.
Cause:
Equity calculation is correct but correct bond calculation was never mentioned in 2014 CR and thus never implemented.
Solution:
Customer has to finalized the correct calculation.
Test scenario:Hi Najmi
Please find the consolidated formula:
How to identify Equity or Bonds as below:
1. In company stock file, there is a column called principle. If the value is Null then it is Equity. If the value is I or C, then it is Bonds. >>This is proper solution. Based on this to apply the formula accordingly for Equity and Bonds.Local Equity (remain as current) = (Registered Holdings+PGV Holdings+STN Holdings) x Market Price
Foreign Equity(remain as current) = (Registered Holdings+PGV Holdings+STN Holdings) x Market Price
Foreign Stock (GBP) regardless Equity / Bonds (remain as current) = (Registered Holdings+PGV Holdings+STN Holdings) x Market Price / 100
UPDATES REQUIRED:
Local Bonds = Registered Holdings+PGV Holdings+STN Holdings) x Par ValueForeign Bonds = Registered Holdings+PGV Holdings+STN Holdings) x Market Price / Par Value
Thanks
HAZWANI HASSAN
Exec, System Management, Securities Services, Transaction Banking, Global Banking
8th floor, Menara Maybank, 100 Jalan Tun Perak, 50050 Kuala Lumpur.
- Download report RPT006, RPT007 and RPT009.
- Check stock code whether it is either equity or bond.
- Check market value whether it is local equity, foreign equity, local bond, foreign bond or GBP currency.
#5 Updated by Zahir Abd Latif almost 8 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- Assignee changed from Nurul Akmal to Tan Lee Yong
Update by User, Dec 6, 2016 12:27 PM:-
Hi Najmi, We’ve implemented the fixes yesterday and production report look ok now. User will continues monitoring on the reports. Thank you for your support and assist.
#6 Updated by Zahir Abd Latif almost 8 years ago
- Assignee changed from Tan Lee Yong to Zahir Abd Latif