Totalling of Stock Holdings
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.
Comments are currently closed for this discussion. You can start a new one.
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
1 Posted by etj92 on 20 Nov, 2019 03:21 PM
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 Posted by Stuart Beesley ... on 06 Dec, 2019 07:18 PM
Me too!
3 Posted by soleroadams on 07 Dec, 2019 10:00 PM
Me too
4 Posted by davidvernonlong on 09 Dec, 2019 01:28 AM
I switched from Quicken, and this was available on Quicken. Anything Quicken can do Money Dance can do better.
5 Posted by etj92 on 09 Dec, 2019 05:24 AM
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 Posted by davidvernonlong on 09 Dec, 2019 09:28 AM
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 Posted by avp2 on 12 Jan, 2020 05:17 PM
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.
System closed this discussion on 12 Apr, 2020 05:20 PM.
Stuart Beesley (Mr Toolbox) re-opened this discussion on 24 Sep, 2020 05:35 PM
8 Posted by Stuart Beesley ... on 24 Sep, 2020 05:35 PM
I have written a script that may do this for you.
(Note I am a user, not support). Let me know if this helps?
https://infinitekind.tenderapp.com/discussions/moneydance-development/3063-stockglance2020-python-script-to-display-and-extract-the-totals-of-stockfund-unit-qty-balances-by-security
9 Posted by etj92 on 25 Sep, 2020 09:01 AM
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
10 Posted by Stuart Beesley ... on 25 Sep, 2020 09:21 AM
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:
11 Posted by etj92 on 25 Sep, 2020 11:21 AM
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
Maddy closed this discussion on 25 Sep, 2020 01:11 PM.
Stuart Beesley (Mr Toolbox) re-opened this discussion on 25 Sep, 2020 02:10 PM
12 Posted by Stuart Beesley ... on 25 Sep, 2020 02:10 PM
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:
13 Posted by etj92 on 26 Sep, 2020 09:58 AM
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
14 Posted by Stuart Beesley ... on 26 Sep, 2020 10:00 AM
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
15 Posted by Stuart Beesley ... on 26 Sep, 2020 10:14 AM
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....
16 Posted by etj92 on 26 Sep, 2020 10:20 AM
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
17 Posted by Stuart Beesley ... on 26 Sep, 2020 10:24 AM
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
18 Posted by Stuart Beesley ... on 26 Sep, 2020 10:53 AM
version 3b - Changed display to tell user when file is generated and to prevent access to .moneydance system folder
19 Posted by etj92 on 26 Sep, 2020 11:04 AM
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
20 Posted by Stuart Beesley ... on 27 Sep, 2020 06:49 PM
For consistency, posting version 3c with an extra feature...
21 Posted by Stuart Beesley ... on 28 Sep, 2020 10:16 PM
Version 3d - several fixes/enhancements
22 Posted by Stuart Beesley ... on 29 Sep, 2020 06:36 PM
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
23 Posted by etj92 on 29 Sep, 2020 06:48 PM
Thanks for all the hard work Stuart.
Sent from Mail for Windows 10
24 Posted by Stuart Beesley ... on 26 Oct, 2020 09:42 AM
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.
25 Posted by Stuart Beesley ... on 31 Oct, 2020 12:47 PM
StockGlance2020 version 5a. Finally found and fixed issue where it fails to create file on some Windows 10 installations (due to system folder access restrictions) .. Attached
26 Posted by etj92 on 31 Oct, 2020 01:46 PM
Stuart, That's now working a treat. Love the extra features. Once again, thank you very much.
27 Posted by Stuart Beesley ... on 05 Nov, 2020 04:07 PM
StockGlance2020 version 5c - hopefully final version - added parameter to allow user to choose no rounding of pricing (optional)
28 Posted by Stuart Beesley ... on 11 Nov, 2020 05:44 PM
Latest update (v5e)
29 Posted by Stuart Beesley ... on 27 Nov, 2020 10:33 AM
All, if you use my StockGlance2020 script or others from me, please update them all to the latest version. ZIP of all attached.
30 Posted by etj92 on 12 Dec, 2020 05:56 PM
Hi Stuart,
Seasons Greetings to you.
Is there any way to memorise the column widths I set in the StockGlance table or do I have to reset them every time I use StockGlance?
Thanks,
Geoff