Loading a Portfolio value

paul's Avatar

paul

24 Feb, 2021 08:11 PM

I have seen multiple discussions about uploading stock prices but i want to go the other way - less not more detail. Any clever ideas on how to achieve it. ?
I have around 20 different funds and stocks all nicely costed with performance data etc on a third party trading platform.. What is want to be able to do is to simply load the total portfolio value into MD from time to time.

I have tried the approach of creating a single nominal security and buying a single share for the total cost and then updating the price of this share with the portfolio value from time to time, but that falls down if i buy into another fund since I then have 2 shares in my nominal security and the valuation approach falls down.

Any suggestions on how to achieve what i hope i have conveyed?

  1. 1 Posted by Stuart Beesley ... on 24 Feb, 2021 08:57 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    It sounds like you should dump share tracking and use asset accounts. Just create a txn per share holding for the value and update whenever. But this will not give you gains, performance etc.

    Or you write a script to delete all txns and load new ones every month.

    (Not support, just a fellow user)

  2. 2 Posted by dwg on 24 Feb, 2021 09:19 PM

    dwg's Avatar

    I have an approach that may work for you.

    It is a bit more maintenance than you are talking about but a lot less than maintaining a full portfolio.

    I have investments in three master funds (the number is due to legal restrictions here) Each master fund is invested in a variety of wholesale funds 20+ in fact.

    It is impratical to even to try to maintain the full data for all these investments - the data would have to be manually extracted from various reports and then entered into Moneydance, funds change, rebalancing is done, reinvestments etc.

    So I do not and just maintain each master fund at a total level. But I have set it up in way that suits how Moneydance works.

    My initial investment was at a price of $1 per share so the number of shares equals the total purchase price.

    After doing this the only three events I have to account for are:

    1. Placing more money into a master fund
    2. Withdrawing money from a master fund
    3. Changes in the value of the total value of the funds

    Moving money round the wholesale funds is not relevant, neither is reinvestment etc.

    I update things monthly.

    If all that has happened is a change in value then the current value divided by my "number" of shares gives me a new value per share which I enter as a new price

    If I add or withdraw money I get the value of the fund just before the event to update the price then a division of the amount of the investment added or withdrawn by this price gives me the number of shares I need to perform a buy or sell of the fund within Moneydance.

    To make it easier I just created a spreadsheet with the logic embedded so I just have to enter some numbers into it and get the calculated data I need for Moneydance.

    There are some rounding errors, but this is just an approximation and in any case many underlying fund prices could be for a previous day so it is close enough, I have seen some fund prices are even only weekly.

  3. 3 Posted by dwg on 24 Feb, 2021 11:49 PM

    dwg's Avatar

    Both the methods that Stuart and I outlined will work for current value, which to use can come down to how you want to use the data, if it is always just at that point in time or if you want it over time.

    I can only suggest you investigate the options and see which works best for you.

  4. 4 Posted by paul on 25 Feb, 2021 11:27 AM

    paul's Avatar

    Thank you both for your ideas. I had thought of using an Asset decided at first that it was probably too inflexible. The second suggestion sounds like it might have more legs - i will give it a try in a test MD file. thanks again

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

Recent Discussions

10 Apr, 2021 12:14 PM
10 Apr, 2021 11:30 AM
10 Apr, 2021 11:16 AM
10 Apr, 2021 11:09 AM
10 Apr, 2021 10:23 AM