how to update investment account balance

tnpauly's Avatar

tnpauly

04 Nov, 2021 09:06 PM

I have a deferred compensation account through my company. It has 3 mutual funds in it. I just want to manually update the value of this account periodically to track my net worth. How do I update this account as the value goes up or down? I've been looking through this site, but I'm stump.

Thanks
T

  1. 1 Posted by dtd on 04 Nov, 2021 09:15 PM

    dtd's Avatar

    just a user
    Are the mutual funds private, or standard mutual funds?

    If the latter, download the Quote Loader extension - it allows you to update stock and (public) mutual fund prices and put them into MD

  2. 2 Posted by dwg on 04 Nov, 2021 09:52 PM

    dwg's Avatar

    I'm a fellow user.

    I'll try to give you some ideas for funds that you cannot get pricing data for.

    Let me assume you can get the dollar value of the funds when you need them and that is about it.

    There are a couple of approaches you can take that come to mind.

    1. You can make entries to the account to reflect the difference in the recorded value and the current value, in and investment account this would be buy and sell transactions but you need to have an account or category to deal with the funds. If you are using an asset account you use deposit/payment amounts again with categories.

    2. The second approach and FWIW this is my favourite is to calculate a price per share and use this in the normal way, just with manually entering it.

    What I did with the initial investment I assumed a price of 1.00 per share, so the initial purchase is easy to enter. You have your starting position.

    If nothing changes then dividing the value of the investment by the number of shares worked out gives me a new "price" per share that I can enter.

    To keep things on track if more funds are placed in the investment I work out the price per share when the funds are going in and get te amount going in divided by this to give me a number of shares being purchased.

    The number of shares are thus are just calculated numbers but using those along with my calculated price gives me the right total value with some little rounding errors.

    To make it easy I just created a spreadsheet to plug the numbers into (each month in my case) and give me the results I need.

    Which way to go depends on the detail you want and how you want to maintain the information.

    Others may be offer more suggestions, there is not a perfect way to maintain investment that only have limited data in Moneydance.

  3. System closed this discussion on 03 Feb, 2022 10: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