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. Support Staff 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

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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