Totalling of Stock Holdings

etj92's Avatar

etj92

20 Nov, 2019 03:05 PM

Having looked deeply into my MD I cannot find an easy way to get the total holdings of a particular stock which I hold on several platforms.I can get a good report of the individual holdings on each platform and a total of the cost, gains and balance over the platforms. BUT there is no total for the number of stocks held on the platforms. The only way to do this is to get a calculator out and add up the individual holdings.
Surely this is a very easy thing to program in to get the total stock holdings, I hope you can help.

  1. 1 Posted by etj92 on 20 Nov, 2019 03:21 PM

    etj92's Avatar

    Further to this I not that I raised this issue when I first became a MD user in 2016 and had a reply from Tom Freeman from Infinite Kind Support saying that there was a Request Ticket in to get this modification. Unfortunately, nothing has happened since then. Is there any likelihood of getting this modification to the program?

  2. 2 Posted by Stuart Beesley on 06 Dec, 2019 07:18 PM

    Stuart Beesley's Avatar

    Me too!

  3. 3 Posted by Matt on 07 Dec, 2019 10:00 PM

    Matt's Avatar

    Me too

  4. 4 Posted by davidvernonlong on 09 Dec, 2019 01:28 AM

    davidvernonlong's Avatar

    I switched from Quicken, and this was available on Quicken. Anything Quicken can do Money Dance can do better.

  5. 5 Posted by etj92 on 09 Dec, 2019 05:24 AM

    etj92's Avatar

    Yes, but how?

    Sent from Yahoo Mail on Android

      On Mon, 9 Dec 2019 at 1:28, David Long<[email blocked]> wrote: #yiv8685129445 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv8685129445 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}
    |

  6. 6 Posted by davidvernonlong on 09 Dec, 2019 09:28 AM

    davidvernonlong's Avatar

    Hi, On Quicken , when I look at a security I hold it shows all the holdings
    from all accounts.
    Or, when I report on a stock performance report, I can choose not to have
    any subtotal by account, so it just lists all the securities I hold without
    reference to which account holds them.
    regards
    David

  7. 7 Posted by avp2 on 12 Jan, 2020 05:17 PM

    avp2's Avatar

    There is an extension "Investment Reports" that may be able to do it. I have not used it, so not sure, but it does have a "report by ticker (symbol)" rule.

  8. System closed this discussion on 12 Apr, 2020 05:20 PM.

  9. Stuart Beesley re-opened this discussion on 24 Sep, 2020 05:35 PM

  10. 8 Posted by Stuart Beesley on 24 Sep, 2020 05:35 PM

    Stuart Beesley's Avatar
  11. 9 Posted by etj92 on 25 Sep, 2020 09:01 AM

    etj92's Avatar

    Hi Stuart,
    Thanks very much for that. I tried to open it and it seems it’s only available if I have a paid version of Doxillion. Unfortunately, I’m not prepared to pay for the software in order to try the extension. Is there another way of opening the file?
    Geoff

    Sent from Mail for Windows 10

  12. 10 Posted by Stuart Beesley on 25 Sep, 2020 09:21 AM

    Stuart Beesley's Avatar

    Hi. There’s no charge to use it? Were you trying to open outside Moneydance perhaps? From within MoneyDance from the top menu bar choose open moneybot console. Then open script. Choose this script. Then run. If you get two system warnings about a dlib , just press ok or bin (that’s an erroneous error) and then the script will run. Let me know?

    Regards Stuart

    On 25 Sep 2020, at 10:01, etj92 <[email blocked]> wrote:

    

  13. 11 Posted by etj92 on 25 Sep, 2020 11:21 AM

    etj92's Avatar

    Stuart,
    Many thanks for the help. I’m completely ignorant of programming.
    The script worked brilliantly, without the errors you mentioned; I just got the panel with options of Display Export etc.
    Playing around, it appears that all I need to do now that I have used the script once is open the moneybot console then press Run and that takes me to Display Only. Hit that and I’m in.
    Looking at a few stocks, it seems absolutely spot on; in fact it picked up a stock in an account I hadn’t ticked in the main program.
    There is no difference in the current value and base value, I’m not sure what the base value is and where it gets that figure.
    Judging by your rapid response to my email, you’re, like me, in the UK. Either that or burning the midnight oil in the States!
    Great bit of work Stuart, many thanks,
    Geoff

    Sent from Mail for Windows 10

  14. Maddy closed this discussion on 25 Sep, 2020 01:11 PM.

  15. Stuart Beesley re-opened this discussion on 25 Sep, 2020 02:10 PM

  16. 12 Posted by Stuart Beesley on 25 Sep, 2020 02:10 PM

    Stuart Beesley's Avatar

    Hi Geoff,

    Thanks for your kind words. Curr Value is the value in local currency. Base value is the same value at the system base rate currency value. If you’re in the U.K. with U.K. stocks, all in £s then the values will be the same.

    Yes - to rerun, open moneybot, check it says this script’s name and press run.

    It could be made into an extension that appears on the menu, but may not be worth the hassle for now.

    If you do find any probs or think of useful enhancements, let me know?

    Good to see you’re on Windows and that it worked ok. I can only test on a Mac. Did you try the file export too? Would be interested to know what version of moneydance too?

    NOTE: if you choose the cash balances option and let it run across all accounts, then it should help you check/reconcile to the MD investment reports that total the value for your portfolio.

    Yes. I’m in the U.K.

    Regards Stuart

    On 25 Sep 2020, at 12:21, etj92 <[email blocked]> wrote:

    

  17. 13 Posted by etj92 on 26 Sep, 2020 09:58 AM

    etj92's Avatar

    Hi Suart
    I just tried, unsuccessfully, to do an export and here’s the readout I got:

    StockGlance2020.py.......
    Parameters...
    Hiding Hidden Securities...
    Hiding Inactive Accounts...
    Hiding Hidden Accounts...
    Selecting ALL Currencies...
    Selecting ALL Securities...
    Selecting ALL Accounts...
    Excluding Cash Balances
    Will strip non-ASCII characters - e.g. Currency symbols from output file...
    Sorry - User chose to use .moneydance extension - I will not allow it!... So no Extract will be performed...
    No Export will be performed

    I’m using Moneydance Version 2020.1 (1928)

    Hope that’s useful,
    Geoff

    Sent from Mail for Windows 10

  18. 14 Posted by Stuart Beesley on 26 Sep, 2020 10:00 AM

    Stuart Beesley's Avatar

    This error means you tried to export to a filename that ended in “.moneydance” so risks overwriting your master MD file…. What filename did you try to create? You should really use .CSV or .TXT. Try using the default export filename or at least ending in .CSV.

    Let me know?

    Stuart B

  19. 15 Posted by Stuart Beesley on 26 Sep, 2020 10:14 AM

    Stuart Beesley's Avatar

    Actually, I found a small bug in the script. It's possible to select the Moneydance package and open that as a directory and then select a filename. This resulted in the check for '.moneydance. being incorrect and not allowing the extract to occur. Revised script here to fix that....

  20. 16 Posted by etj92 on 26 Sep, 2020 10:20 AM

    etj92's Avatar

    Stuart,
    I did use the default csv. I think my error was that I tried to export it to the moneydance folder. As soon as I nominated another folder it said it WILL export to that folder. I realized that I had to close the Stockglance window before it exported successfully.
    I then double clicked the saved file and it opened Moneydance and produced a window suggesting an account into which I could import the file. I don’t know how I would use this facility, so I didn’t import the file.
    Geoff
    Sent from Mail for Windows 10

  21. 17 Posted by Stuart Beesley on 26 Sep, 2020 10:24 AM

    Stuart Beesley's Avatar

    Hi Geoff,

    Yes, I just guessed that’s what might have happened, and I have just fixed the filename check. I don’t know if you use Excel, but if you do, then you can open the .CSV from within Excel.

    Anyway, thanks again for using…

    Regards

    Stuart B

  22. 18 Posted by Stuart Beesley on 26 Sep, 2020 10:53 AM

    Stuart Beesley's Avatar

    version 3b - Changed display to tell user when file is generated and to prevent access to .moneydance system folder

  23. 19 Posted by etj92 on 26 Sep, 2020 11:04 AM

    etj92's Avatar

    Yep,
    Works a treat with Excel and that’s how I’ll probably use the Export files system.
    Once again, to you, thanks for the script.
    Geoff

    Sent from Mail for Windows 10

  24. 20 Posted by Stuart Beesley on 27 Sep, 2020 06:49 PM

    Stuart Beesley's Avatar

    For consistency, posting version 3c with an extra feature...

  25. 21 Posted by Stuart Beesley on 28 Sep, 2020 10:16 PM

    Stuart Beesley's Avatar

    Version 3d - several fixes/enhancements

  26. 22 Posted by Stuart Beesley on 29 Sep, 2020 06:36 PM

    Stuart Beesley's Avatar

    Final version 4 of Stock Glance 2020 script. Tweaks and enhancements. To run:
    Just load MoneyDance as normal.
    From within MoneyDance: Main menu>> View menu
    Choose Show MoneyBot Console
    Click Open script
    Choose my script file you just downloaded
    Click Run.

    That’s it

    If you're on a Mac and get a xxx.dylib cannot be opened message. Just click cancel. It’s a harmless MD bug that they need to get rid of sometime. It’s nothing to do with the script. So ignore that.

    PS - It can’t do any harm as it’s read only.

    Have fun

  27. 23 Posted by etj92 on 29 Sep, 2020 06:48 PM

    etj92's Avatar

    Thanks for all the hard work Stuart.

    Sent from Mail for Windows 10

  28. 24 Posted by Stuart Beesley on 26 Oct, 2020 09:42 AM

    Stuart Beesley's Avatar

    For completeness version 5 of this script released - attached. The latest can always be found here:
    https://github.com/TheInfiniteKind/moneydance_open/tree/main/python_scripts

    Rollup of v4a to v4h enhancements. Key changes: enhanced filters; enhanced parameters; Parameters now persist between sessions; better rounding; New option to split Securities by Account; Enhanced display, sort, highlighting, formatting, scrolling etc; added cost basis, gain and % fields; enhanced CSV creation, including ability to exclude totals (for Pivot tables). By Stuart Beesley - StuWareSoftSystems - October 2020.

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