Security Details Report

gsanse's Avatar

gsanse

03 Dec, 2025 02:30 PM

What is the difference between the Current Price and Price columns in the Security Details Report?

  1. 1 Posted by Stuart Beesley ... on 03 Dec, 2025 02:38 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Current price is current price.

    The other is the price as of the report’s as of date. Depends if your as of date has been changed to not today

  2. Support Staff 2 Posted by Maddy on 03 Dec, 2025 02:49 PM

    Maddy's Avatar

    Hi,
    Thank you for contacting Moneydance support.

    The Price column reflects the security’s value on the report’s date, while Current Price reflects the latest available value in your history. This distinction helps you analyze both historical and up-to-date portfolio performance.

    I hope this information is helpful. Please let us know if you have further questions or need more assistance.

    --
    Maddy, Infinite Kind Support

  3. 3 Posted by gsanse on 09 Dec, 2025 03:29 PM

    gsanse's Avatar

    Maddy, thank you for the clarification. However, I am still struggling to
    understand the report. I am running it with the report date exactly equal
    to today's date. In this case, both prices should be equal, correct? And
    even so the report is showing a difference between price and current price.
    More than that, I cannot understand where the current price is coming from,
    as it has no connection to the security price history. Please see below a
    screenshot to illustrate what I mean.

    Regards,

    Glaucio

    [image: image.png]

    Em qua., 3 de dez. de 2025 às 11:50, Maddy <[email blocked]>
    escreveu:

  4. 4 Posted by Stuart Beesley ... on 09 Dec, 2025 05:48 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    price is balance / shares and you can see that mathematically it's exactly right/the result of that formula. This is therefore as of 31/10/2025

    current price is the current price, as of now, as per the tools/securities/edit/current price field - i.e. as of 9/12/2025. Please send a screenshot of this screen?

  5. 5 Posted by Stuart Beesley ... on 09 Dec, 2025 05:54 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    My bet is that you have a "current price" set that is not equal to the dated price that you think?

  6. 6 Posted by Stuart Beesley ... on 12 Dec, 2025 10:05 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    ?

  7. 7 Posted by gsanse on 19 Dec, 2025 06:01 PM

    gsanse's Avatar

    But I cannot understand how this balance value is calculated. The price, according to the Security History screen should be 20.23791 and not 22.4921. Please see the attached screenshots.

  8. 8 Posted by Stuart Beesley ... on 06 Feb, 2026 03:46 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok. I see what you are saying. You are arguing that the balance should be qty * current price, and I am trying to say that the report takes the system’s calculated balance value and divides by the qty to show you the effective price. This report does NOT create the balance value.

    So your next question is how does that balance get calculated? How/where?

    MD totals share qty in each account and then converts qty * price = balance.

    My guess is that you have 2 or more investment accounts that hold this security? Yes. The maths will be sum both the qty and balance from each account.

    Mathematically when you take a price * qty you get a balance rounded to 2 decimal places, per account. This will lose fractional amounts from balance. If you then add those up and divide by qty, you will get a slightly different aggregate price.

    Please tick the option to show account level detail and send us this for this security.

  9. 9 Posted by gsanse on 06 Feb, 2026 03:57 PM

    gsanse's Avatar

    Thanks for the reply Stuart.

    I only have that security in one account. I did what you said, here is the
    screenshot:
    [image: image.png]
    I also went to the account balance report to verify the balance for the
    account and the security. And it does not make sense to me, if you multiply
    qty by number of shares, the numbers don't match:

    [image: image.png]

    Regards,

    Glaucio

  10. System closed this discussion on 08 May, 2026 04:00 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