Home → Investments →

DESIGNING A REPORT

• Edit

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

   

   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?

   • StockGlance2020.py 129 KB
   • Edit

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

   

   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!

   • Edit

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

   

   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

   • Edit

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

   

   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.

   • Edit

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

   

   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.

   • Edit

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

   

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

   • Edit

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

   

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

   • Screenshot_2020-11-30_at_18.43.42.png 231 KB
   • Screenshot_2020-11-30_at_18.51.05.png 145 KB
   • Edit

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

   

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

   • Edit

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

   

   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.

   • Edit

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

    

    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.

    • Edit

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

    

    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.

    • Edit

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

    

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

    • Edit

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

    

    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.

    • Edit

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

    

    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.

    • Edit

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

    

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

    • Edit

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

    

    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.

    • Edit

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

    

    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

    • Edit

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

    

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

    • StockGlance2020.zip 63.3 KB
    • Edit

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

    

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

    Regards,

    Gordon.

    • Edit

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

    

    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).

    • StockGlance2020.zip 66 KB
    • Edit

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

    

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

    Regards,

    Gordon.

    • Edit

22. System closed this discussion on 17 Mar, 2021 02:20 PM.