Home → Investments →

Investment performance reports

• Edit

Alan Peddle

Jan 15, 2020 @ 12:50 PM

When printing the investment performance report the gains /losses on investments dont seem to take account of stock splits, ie where the number of units has say increased by a factor of 2 with a corresponding reduction in share price. The result is that the gain seems to be calculated on the actual stock prices when originally bought, not taking account of the stock split reduction in price.

1. 1 Posted by Andrew on Jan 24, 2020 @ 02:04 PM

   

   Hi Alan,

   Sorry to hear about the problem you have encountered.

   Which version and build of Moneydance are you using?
   To check, open Moneydance and select Help --> About Moneydance (or Moneydance --> About Moneydance on a Mac) where the version and build number will be displayed.

   Can you let me know which operating system you're running on your computer/s?

   If it's easier, you can send me a screenshot of what you're seeing. You can read instructions for taking a screenshot here - https://www.take-a-screenshot.org/

   Thank you.

   --
   Andrew, Infinite Kind Support

   • Edit

2. 2 Posted by Alan Peddle on Jan 26, 2020 @ 03:34 PM

   

   Thanks fro reply Andrew

   I was using a later 2017 version and am now using 2019.3. The problem with the report happened in both versions.

   The OS is High Sierra 10.13.6

   I'd rather not send the screenshot of the full report itself but attach an extract (it doesn’t show the headings, but these are going left to right):

   Opening cost
   Buys
   Sales
   Income
   Closing Cost
   Gains
   Return Amount
   Return %
   Annual% ROI

   It is basically the Investment Performance report calculation that is the problem. The investment in question here is IP High Income. Looking simply at sales v costs, the loss should be -247, not -14264. I think the gain calculation is picking up the pre stock-split price when it calculates the cost of investment on which gain is being calculated,

   The issue is either I have input the stock split incorrectly or there is an error in the logic for calculation of stock gain or loss.

   Best

   Alan

   • Screen_Shot_2020-01-26_at_15.25.29.png 47.2 KB
   • Edit

3. System closed this discussion on Apr 26, 2020 @ 03:40 PM.