Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

issue with TWR and ROI with neg distributions on share

Questions on using, creating, or understanding data in Fund Manager reports.

Postby twj332 » Tue Feb 04, 2020 9:26 pm

I have thai securities and they charge VAT on commission, clearing fees and trade fees
These I have recorded as neg distribution for each transaction taking/deducting the funds from the thai cash account
Problem is the neg values crash both ROI and TWR reports

Please advise better way to input these costs or work around on reports.
thanks
Ashampoo_Snap_February-05-20_11h16m25s_012_.jpg
TWR log & data screen
Ashampoo_Snap_February-05-20_11h16m25s_012_.jpg (204.85 KiB) Viewed 1800 times
twj332
 
Posts: 43
Joined: Sun Sep 13, 2009 11:49 am

Postby twj332 » Tue Feb 04, 2020 9:27 pm

Ashampoo_Snap_February-05-20_11h14m51s_011_.jpg
transaction screen
Ashampoo_Snap_February-05-20_11h14m51s_011_.jpg (38.63 KiB) Viewed 1799 times
attached is transaction screen
twj332
 
Posts: 43
Joined: Sun Sep 13, 2009 11:49 am

Postby Mark » Wed Feb 05, 2020 8:54 am

Hi twj332,

The reason is that after adjusting for all the cash flows, the value becomes negative. TWR and ROI cannot be calculated on negative valued items. There are a couple options you have:

1) Include these fees that you have as negative valued distributions into the "Commission Fee" field. This is simple, but the downside is you can't report on the breakdown the way you can if you record them as negative distributions. See option 2...

2) Record these negative valued fees for a day after you purchase the original shares.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby twj332 » Wed Feb 05, 2020 6:15 pm

Thanks
Adjusted the (nef) distribution amt. to one day after and the owned on date to the date of purchase and the calculations worked.
Thanks Mark
twj332
 
Posts: 43
Joined: Sun Sep 13, 2009 11:49 am


Return to Reports

Who is online

Users browsing this forum: No registered users and 2 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.