DESIGNING A REPORT

gordon.dow's Avatar

gordon.dow

30 Nov, 2020 03:11 PM

Hello - I want to design a report which shows my various holdings, not by broker account but by each individual stock. I have several accounts with different brokers and sometimes the same stock is held across more than one broker.

I want to set up a pro forma so that I can run this each month. I can't see any help as to how do this.

Any help would be much appreciated.

  1. 1 Posted by Stuart Beesley ... on 30 Nov, 2020 03:38 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    That's a more tricky one to do.... Try my script which will display your holdings and also give you the option to export to csv file...... To use from moneydanc> menu, window, moneybot console, open, choose file, then RUN... if on Mac, ignore the two xxxx.dylib messages and hey presto.... Let me know if it works OK for you?

  2. 2 Posted by gordon.dow on 30 Nov, 2020 04:21 PM

    gordon.dow's Avatar

    Thanks Stuart but I'd rather not load software on to my Mac.

    On MS Money it was relatively easy to design a report within the program to do this so I'm surprised that MD apparently can't.

    Thanks anyway!

  3. 3 Posted by Stuart Beesley ... on 30 Nov, 2020 04:44 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    No problem at all… All I will tell you is that this script interacts with MD, is readonly and probably gives you what you want…. Quite a few people are using it...
    Moneydance can do most things, but unfortunately totalling stockholding across accounts isn’t one of them (and having dug into the depths of MD to understand how it stores this data, I understand why….)
    The closest I got using built in MD reports was to use the Portfolio report, selecting the Accounts and stocks, and then export to CSV. You will have to do some editing to get the formats lined up to total the stocks….

    S

  4. 4 Posted by gordon.dow on 30 Nov, 2020 05:32 PM

    gordon.dow's Avatar

    Thanks again Stuart, I don't want the additional hassle of having to export to csv files etc so I guess I'll have to get by without it. A pity.

    I've now done my monthly update of stock prices in both MS Money & MD, and got them to agree (after a few more dummy entries) so that's good. In the Portfolio report there are extraneous columns which I don't need, ie 1 yr %, 3 year % etc etc. How do I get rid of these? I can't see anything under edit.

    Regards.

  5. 5 Posted by Stuart Beesley ... on 30 Nov, 2020 05:44 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Ok. Well just to add that my script gives you a nice display without having to do the export if you select that option. anyway up to you. No I don’t think you can remove columns from the MD report.

  6. 6 Posted by gordon.dow on 30 Nov, 2020 06:19 PM

    gordon.dow's Avatar

    Sorry, you've lost me Stuart. What do you do with this script?

  7. 7 Posted by Stuart Beesley ... on 30 Nov, 2020 06:53 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    If you decide you want to run it, then it pops up with a parameters box as per this first screen shot and you can leave all defaults, or specify filters. You also click Display Only or Display & Export. If you choose the first you get an onscreen window as per second screen shot. If you export you get a csv too. The whole point of the script is to total stocks across accounts, which MD can't/doesn't do..

    To run, download StockGlance2020.py from link above. Then in Moneydance, Menu>Window>Show Moneybot Console. Open select the script you downloaded, then RUN. If on a Mac ignore the two silly xxxx.dylib warnings and hey presto... Anyway, up to you, just trying to assist if possible....

  8. 8 Posted by Stuart Beesley ... on 30 Nov, 2020 06:54 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    (I should add, I am a user, not from support)

  9. 9 Posted by gordon.dow on 01 Dec, 2020 02:24 PM

    gordon.dow's Avatar

    Thanks again Stuart, I'll think about downloading the script. I'm running MD on my Mac so could probably just view the results.

    Next question - in the Investment Performance report, it shows individual shares to four places of decimals! For UK shares this is unnecessary and just looks daft - it it possible to edit so no decimals appear?

    I have to say MD don't appear to have gone overboard on making their reports user friendly or attractive to look at - they need to take a leaf out of MS Money's book.

    Regards,

    Gordon.

  10. 10 Posted by Stuart Beesley ... on 01 Dec, 2020 03:20 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    From memory I don’t think you can. (You do need 4dpc on shares; especially with large quantities, else you get valuation problems). If I’m wrong, others will jump in.

  11. 11 Posted by gordon.dow on 01 Dec, 2020 03:31 PM

    gordon.dow's Avatar

    Thanks again Stuart, I can't see why you'd need decimal points for shares. I realise that in some countries you can buy fractions of a share but that's usually when an individual share has a very high price and I've never seen that in the UK, except maybe on rights issues but then the fractions are usually sold.

    It seems to me that the MD reports are very inflexible but I'll just have to live with that.

  12. 12 Posted by Stuart Beesley ... on 01 Dec, 2020 03:51 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    FYI. For example. I hold funds prices at 9621.21 pence. Any multiplication to get the value gets a small error with less dpc

  13. 13 Posted by gordon.dow on 01 Dec, 2020 04:41 PM

    gordon.dow's Avatar

    Yes but that's the price, what I'm talking about is the number of shares. I don't hold unit trusts but certainly with shares, you only hold complete shares, certainly in my experience.

  14. 14 Posted by derekkent23 on 01 Dec, 2020 05:04 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Gordon

    Just to add I have a number of Funds that have the number of shares down to four decimal places.

  15. 15 Posted by Stuart Beesley ... on 01 Dec, 2020 05:14 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Sorry I didn't see that you said Shares... Never-the-less, if you hold funds then you hold partial quantities.. The same would be true if people are holding crypto too....

  16. 16 Posted by gordon.dow on 02 Dec, 2020 09:10 AM

    gordon.dow's Avatar

    Hi Derek, yes I can see how unit trusts would have decimal places, but not shares. Actually I've just checked my MS Money report & it shows my shares with three zeros after the decimal point!!! Just not so obvious there as it's a much tidier report.

    Thanks to all.

  17. 17 Posted by Stuart Beesley ... on 02 Dec, 2020 09:19 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    I agree, it could just display to the dpc being used. Anyway, let me know if you decide to use my script, what you think... Thanks

  18. 18 Posted by Stuart Beesley ... on 14 Dec, 2020 05:47 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    I don't know if you did ever use my StockGlance2020 script, but it's now available as an Extension. Attached

  19. 19 Posted by gordon.dow on 16 Dec, 2020 08:49 AM

    gordon.dow's Avatar

    Thanks Stuart but it doesn't appear in my updates under "There are some new extensions available".

    Regards,

    Gordon.

  20. 20 Posted by Stuart Beesley ... on 16 Dec, 2020 10:10 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Correct. At the moment you need to click the Add From File button (bottom left ) in the Extensions window. Latest version attached. Just unzip this. You will see a StockGlance2020.mxt file. This is the file you add. (At some point the developer of MD will add it to the master list).

  21. 21 Posted by gordon.dow on 16 Dec, 2020 02:16 PM

    gordon.dow's Avatar

    Thanks Stuart, I'll await its appearance in the master list.

    Regards,

    Gordon.

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