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.

Showing page 2 out of 2. View the first page

  1. 31 Posted by Stuart Beesley ... on 12 Dec, 2020 06:01 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    . That is already done in an upgrade I have ready. I can send a preview? Are you on the latest 2021.2012 version as I can send an extension.

  2. 32 Posted by etj92 on 12 Dec, 2020 06:20 PM

    etj92's Avatar

    Thanks Stuart, Rather than go down the extension route I’ll wait for the upgrade as I can cope with that!
    Geoff

    Sent from Mail for Windows 10

  3. 33 Posted by Stuart Beesley ... on 12 Dec, 2020 06:23 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Either way is fine. FYI - if you load as an extension then it’s always available from the moneydance (extension) menu without having to load the moneybot console each time...

  4. 34 Posted by Stuart Beesley ... on 12 Dec, 2020 07:37 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Hi Geoff, attached a preview version build: 999 (fully working) of the latest StockGlance2020 script. You can choose the script or extension version (they are the same).... But you need to be on 2021.2012 for the Extension version to work... Let me know that it's working OK for you? Thanks S

  5. 35 Posted by davidvernonlong on 12 Dec, 2020 09:39 PM

    davidvernonlong's Avatar

    Hi,

     

    Could you remind me of the mechanics of how I load this into Moneydance. I am using an old version, but for some reason securities in certain currencies are not included in the totalling report (like HKD) but maybe its just me.

     

    Thanks

     

    David

  6. 36 Posted by Stuart Beesley ... on 12 Dec, 2020 09:58 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Do you mean you are using an old version of moneydance or the script? What Moneydance version do you have?

  7. 37 Posted by davidvernonlong on 12 Dec, 2020 10:29 PM

    davidvernonlong's Avatar

    Hi
    An old version of the script.
    David

  8. 38 Posted by Stuart Beesley ... on 12 Dec, 2020 10:42 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Ok. Assuming you do mean my stockglance2020 script (and not the very original stockglance extension or stockglance75 scripts)...

    Menu>Window>Show Moneybot console
    OPEN > select the new StockGlance2020.py file
    Click RUN (not run snippet)
    If on a Mac, ignore the two silly xxx.dylib messages (click bin or ignore)
    Hey presto.

    As for missing stocks, run with the hide hidden XYZs set to NO (so nothing is excluded).
    Let me know if it works or whether you still have missing stocks?

  9. 39 Posted by etj92 on 13 Dec, 2020 10:29 AM

    etj92's Avatar

    OK, I’ll try the extension. I think I’m on your latest version, can’t find where that info is but I know I’ve always used your latest version.
    Many thanks for your help, Geoff

    Sent from Mail for Windows 10

  10. 40 Posted by Stuart Beesley ... on 13 Dec, 2020 10:33 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    FYI. When you run the script it tells you the version in the title bar heading in brackets.
    PS - to use the extension you will have to unzip the zip file and install / load the enclosed .mxt file.

  11. 41 Posted by etj92 on 13 Dec, 2020 11:18 AM

    etj92's Avatar

    Morning Stuart,
    Afraid I came up short here. I made sure I had the latest version of Moneydance and when I check this using “About Moneydance” I get the result Version 2021 (2006).
    I then tried to install the mxt file as I presume this is the one for the extension but it didn’t work (probably because I’ve got 2021 (2006)). I seem to remember you use Mac; could it be that Mac has different version numbers?
    Anyway, using the Moneybot route gave me the desired table which retains my column widths.
    Once again, thanks for your help on this,
    Geoff

    Sent from Mail for Windows 10

  12. 42 Posted by etj92 on 13 Dec, 2020 11:30 AM

    etj92's Avatar

    Further to my last, it appears that the Extension has installed and appears on the Extension tab as StockGlance 2020. However, it will not run!
    Geoff

    Sent from Mail for Windows 10

  13. 43 Posted by Stuart Beesley ... on 13 Dec, 2020 11:31 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Hi, as I mentioned above, you have to be on the latest preview 2021.2012 for the extension to run.... Are you on this version??? If not, you will just have to use the script..... Let me know? S

  14. 44 Posted by Stuart Beesley ... on 13 Dec, 2020 12:07 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    You get 2021.2012 from here: https://infinitekind.com/preview

  15. 45 Posted by etj92 on 13 Dec, 2020 03:41 PM

    etj92's Avatar

    Thanks Stuart, that’s installed and works a treat with the extension. I’m learning slowly with your help!
    Many thanks,
    Geoff

    Sent from Mail for Windows 10

  16. 46 Posted by Stuart Beesley ... on 13 Dec, 2020 03:42 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    You may be the very first user running a Python Extension in Moneydance.....!

  17. 47 Posted by davidvernonlong on 13 Dec, 2020 06:24 PM

    davidvernonlong's Avatar

    Hi,

     

    I did all of that and it seemed the script tried to run, but all I got was a screen with headings only, which took a few minutes.

     

    This the log of the attempt.

  18. 48 Posted by Stuart Beesley ... on 13 Dec, 2020 06:35 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Hi David, can you run as a script (and not an extension) and a) in the parameter screen - change DEBUG on to Y, b) send me that output, c) send a screen shot of the display.. Thanks

  19. 49 Posted by davidvernonlong on 13 Dec, 2020 07:50 PM

    davidvernonlong's Avatar

    Hi Stuart

     

    Here it is and screen shot. What I now noice is if I click on the screen then bits of it open up as I move over with mouse and click away.

     

    Screen shot is at end of the log

     

    Thanks

     

    David

  20. 50 Posted by Stuart Beesley ... on 13 Dec, 2020 08:19 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Hi David, ok looks like it will be more complicated to identify the problem. But worth doing. I don’t want you sending personal data over this forum which is public. Are you willing to reply with your email and then I can contact you directly with suggestions etc?

    Regards Stuart B

  21. 51 Posted by davidvernonlong on 13 Dec, 2020 08:47 PM

    davidvernonlong's Avatar

    Hi Stuart,

     

    Yes that would be good. You are right, had not thought of thar aspect.

     

    How do we do that? I need to give you my E Mail address in the text of a reply?

     

    Best

     

    David

  22. 52 Posted by Stuart Beesley ... on 13 Dec, 2020 08:59 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    ...

  23. 53 Posted by Stuart Beesley ... on 14 Dec, 2020 05:46 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Latest version released as an extension today.... (extension only works on MD2021.2012 onwards)

  24. 54 Posted by Stuart Beesley ... on 15 Dec, 2020 03:56 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    OK, we have identified and fixed a bug uncovered by David's data - thanks DVL. Updated extension and script attached

  25. 55 Posted by davidvernonlong on 17 Dec, 2020 10:03 AM

    davidvernonlong's Avatar

    Thanks, that works well.

    Would it possible to have a report similar to the “Investment Performance “ report on this basis.?

      As I have transferred some securities between accounts, and the only way to do this in MoneyDAnce is by dummy sales and purchases at cost, it means that I do not have a total view of the performance of those securities. The originating account will still have dividends and realised gains/losses , with any dividends, realized or unrealized gain/lossess after the transfer being in the new account.

    Thanks

    David

  26. 56 Posted by Stuart Beesley ... on 17 Dec, 2020 10:12 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Hi, I wish!! I would also like this for me too... I can't for the life of me work out the logic though... If you are able to work out the logic (I don't mean technical) then I might be able to try.....?

  27. 57 Posted by davidvernonlong on 17 Dec, 2020 10:40 AM

    davidvernonlong's Avatar

    Hi
    If I could take my data, download it into Excel, and manipulate there to
    give the desired result, would that help.?
    David

  28. 58 Posted by Stuart Beesley ... on 17 Dec, 2020 11:02 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Yes, if it's simple data. I really just need one stock, with transfers to/from several accounts, several times, with buy/sells across the multiple accounts, and the maths/logic. The sheet would need to show how to cope with the cost basis and the value/gains.... I think it's a brain twister.. Don't hurry though, I can't knock this up immediately....

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