Safecustody Fees calculation
- senil01
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 6 months ago #19446
by senil01
Safecustody Fees calculation was created by senil01
Hi,
I have been trying to understand the calculation part of safecustody fees posted in SAFEKEEP.HOLDING application. The average closing method selected in SCSF.CHARGE.PARAMETER is average. Also i have done all the required setup as described in the below link
www.wikibanking.info/2015/10/charges-and...ssions-on-sec-trade/
The problem is that the safeekeeping fees posted is not in conformance with the percentage setup in FT.COMMISSION.TYPE.
Can someone please explain the basis of the calculation and the method to be used to validate whether correct value is getting posted?
I have been trying to understand the calculation part of safecustody fees posted in SAFEKEEP.HOLDING application. The average closing method selected in SCSF.CHARGE.PARAMETER is average. Also i have done all the required setup as described in the below link
www.wikibanking.info/2015/10/charges-and...ssions-on-sec-trade/
The problem is that the safeekeeping fees posted is not in conformance with the percentage setup in FT.COMMISSION.TYPE.
Can someone please explain the basis of the calculation and the method to be used to validate whether correct value is getting posted?
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 649
8 years 6 months ago #19448
by jpb
Replied by jpb on topic Safecustody Fees calculation
What in detail is wrong ?
The average balance (AVG.CLOSING.BAL) or the calculated fee (CHARGES.LCY) or the period (INT.MONTHS) or . . . ?
Can you post SAFEKEEP.HOLDING and the related FT.COMMISSION.TYPE (as from CHARGE.CODE)?
The average balance (AVG.CLOSING.BAL) or the calculated fee (CHARGES.LCY) or the period (INT.MONTHS) or . . . ?
Can you post SAFEKEEP.HOLDING and the related FT.COMMISSION.TYPE (as from CHARGE.CODE)?
Please Log in or Create an account to join the conversation.
- senil01
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 6 months ago #19515
by senil01
Replied by senil01 on topic Safecustody Fees calculation
Below is the example for the Safe custody fees set
Safe custody values setup:
SCSK.GEN.CONDITION
SCSK.GROUP.CONDITION
SCSF.CHARGE.PARAMETER (Average Closing method selected – Average)
FT.COMMISSION.TYPE – SCSKBOND
Calc Type - Level
For USD upto 500000 – percentage 0.2
SAFECUSTODY.VALUES setup for SG Company
Frequency set for safe custody fee is quarterly
Accrual – Monthly
Transaction level data
SAM record created with portfolio value – SGD 150000000000
Information:
Portfolio created on 1st April
Safecustody Freq – Monthly (in this case should be calculated from 1st to 30th of April)
SAFEKEEP.HOLDING table values (First month accrual posted on 1st May)
Average Closing Balance – USD 10953702351.395 (USD/SGD rate – 1.3694)
Int months – 10
Charges Lcy – USD 21451465.02 (Total Amount)
Local Chg Lcy – USD 12322915.14
Foreign Chg Lcy – USD 9128549.88
Process Stage – Calculated
Process type - periodic
Can someone please explain how the calculation is done for the safecstody fee when AVERAGE.CLOSING is selected as AVERAGE in SCSF.CHARGE.PARAMETER?
Safe custody values setup:
SCSK.GEN.CONDITION
SCSK.GROUP.CONDITION
SCSF.CHARGE.PARAMETER (Average Closing method selected – Average)
FT.COMMISSION.TYPE – SCSKBOND
Calc Type - Level
For USD upto 500000 – percentage 0.2
SAFECUSTODY.VALUES setup for SG Company
Frequency set for safe custody fee is quarterly
Accrual – Monthly
Transaction level data
SAM record created with portfolio value – SGD 150000000000
Information:
Portfolio created on 1st April
Safecustody Freq – Monthly (in this case should be calculated from 1st to 30th of April)
SAFEKEEP.HOLDING table values (First month accrual posted on 1st May)
Average Closing Balance – USD 10953702351.395 (USD/SGD rate – 1.3694)
Int months – 10
Charges Lcy – USD 21451465.02 (Total Amount)
Local Chg Lcy – USD 12322915.14
Foreign Chg Lcy – USD 9128549.88
Process Stage – Calculated
Process type - periodic
Can someone please explain how the calculation is done for the safecstody fee when AVERAGE.CLOSING is selected as AVERAGE in SCSF.CHARGE.PARAMETER?
Please Log in or Create an account to join the conversation.
- senil01
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 5 months ago #19526
by senil01
Replied by senil01 on topic Safecustody Fees calculation
Hi Moderator,
Request your help with the above query.
Request your help with the above query.
Please Log in or Create an account to join the conversation.
- KT100
- Visitor
8 years 2 months ago #20229
by KT100
Replied by KT100 on topic Safecustody Fees calculation
hi there , Did you get the answer.
i am encounter the same issue , as i dont understand how the safe keepng is calculated. Currently, the systems seems to be charging for the entire year instead of Quarterly.
Please help , if you found your answer
i am encounter the same issue , as i dont understand how the safe keepng is calculated. Currently, the systems seems to be charging for the entire year instead of Quarterly.
Please help , if you found your answer
Please Log in or Create an account to join the conversation.
Time to create page: 0.079 seconds