Investment performance reports

Alan Peddle's Avatar

Alan Peddle

15 Jan, 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 24 Jan, 2020 02:04 PM

    Andrew's Avatar

    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

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

    Alan Peddle's Avatar

    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

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac