Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Inconsistent addition of buy/sell transactions handling

Questions about updating prices or transactions in Fund Manager

Postby Exspextations » Sun Oct 05, 2014 10:11 am

Mark,

FM is driving me crazy at present - I am probably doing something wrong, but the program is not handling buy / sell transactions consistently:

I have a portfolio with two sub portfolios one for my wife and one for myself. Each month we invest the same amount and buy the same number of units of the same fund in our respective sub portfolios. However, when I add the two identical buy transactions, I find on some occasions that while the corresponding deduction of cash is entered in the associated cash account from the entry in one of the sub-portfolios, the other corresponding cash transaction is missing. If I delete the transaction that does not copy across to the cash account and reenter it, it will finally register but often only after several attempts.

Unfortunately, I don't have a screen dump to illustrate this as I have finally resolved all the missing transactions, but it has taken me the whole afternoon to do this. If I doing something wrong please enlighten as I would prefer not to waste so much time on a fruitless activity.

In addition, despite identical transactions in the two sub-portfolios XXX ISA(ignore IA sub-portfolio), the performance calculated by the program is different (see attached). Furthermore, in June 2014 the investment company transferred all its client from the A class funds to the comparable X Class funds to comply with UK as a consequence the program seems to be reporting simply the performance since the transfer rather than the performance since the investment was started , while I would prefer to see a summer of the overall performance since the beginning not just the currently held funds. Again am I doing something wrong?
Attachments
Portfolio problem.pdf
File shows screen dump of portfolio performance and a listing of all the transactions in each sub-portfolio.
(104.85 KiB) Downloaded 250 times
Exspextations
 
Posts: 43
Joined: Sun Apr 27, 2014 3:14 am

Postby Mark » Sun Oct 05, 2014 3:01 pm

Hi Exspextations,

I'm not sure why there is a problem with the cash entries. You can check the properties of each sub-portfolio, to make sure the correct default cash account is selected in both cases. If you prefer, you could also turn off the default cash account feature, and enter the cash side of the transactions yourself.

Those yields are ROI yields, so the things to check are:

Beginning closing price
Ending closing price
All transactions between start/end dates

Your screen shot showed performance numbers of sub-portfolios, so if there are multiple investments (even hidden ones), you need to include all of these. You can also turn on yield calculation logging under "Options / General Preferences... / Yields", and then look in that log file, and see what is different in the yield equation between the 2 different sub-portfolios. If they are truly identical, they should have all the same terms.

If you want to keep the full history in a single investment for this name change, record it as a split for the ratio of <new shares> for <old shares>. Change the existing investment name. If you record it as a transfer from one investment to another you now have your performance split between 2 investments. That is okay, but if you want to see just those 2 investment's performance combined you would have to make them in their own sub-portfolio and look at the sub-portfolio returns, or make them have the same symbol, and report performance listing by symbol.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11583
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Exspextations » Mon Oct 06, 2014 9:14 am

Thanks for the feed back. All the transactions in the two sub-folders were the same and included in the document I attached - there is the same, single fund in each sub portfolio. The problem with the different yields was due to inconsistencies in the start date / prices between the two - resolved and yield calculation is now the same.

Checked the sub-folder properties, they are all pointing to the same default cash account, so I don't know why the cash transaction is adding in some instances and not in others, but I will keep an eye on the problem.
Exspextations
 
Posts: 43
Joined: Sun Apr 27, 2014 3:14 am

Postby Mark » Mon Oct 06, 2014 9:28 am

Hi Exspextations,

If you keep having problems with the cash, give our office a call sometime, and we can do some test entries together, and make sure everything is working okay.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11583
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 13 guests

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