tag:infinitekind.tenderapp.com,2009-01-14:/discussions/suggestions/12956-totalling-of-stock-holdingsInfinite Kind: Discussion 2021-07-12T14:30:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T18:01:47Z2020-12-12T18:01:47ZTotalling of Stock Holdings<div><p>😆. 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.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T18:20:50Z2020-12-12T18:20:50ZTotalling of Stock Holdings<div><p>Thanks Stuart, Rather than go down the extension route I’ll wait for the upgrade as I can cope with that!<br>
Geoff</p>
<p>Sent from Mail for Windows 10</p></div>etj92tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T18:23:52Z2020-12-12T18:23:52ZTotalling of Stock Holdings<div><p>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...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T19:37:42Z2020-12-12T19:37:42ZTotalling of Stock Holdings<div><p>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</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T21:39:03Z2020-12-12T21:39:03ZTotalling of Stock Holdings<div><p>Hi,</p>
<p>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.</p>
<p>Thanks</p>
<p>David</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T21:58:27Z2020-12-12T21:58:27ZTotalling of Stock Holdings<div><p>Do you mean you are using an old version of moneydance or the script? What Moneydance version do you have?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T22:29:20Z2020-12-12T22:29:20ZTotalling of Stock Holdings<div><p>Hi<br>
An old version of the script.<br>
David</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-12T22:42:25Z2020-12-12T22:42:25ZTotalling of Stock Holdings<div><p>Ok. Assuming you do mean my stockglance2020 script (and not the very original stockglance extension or stockglance75 scripts)...</p>
<p>Menu>Window>Show Moneybot console<br>
OPEN > select the new StockGlance2020.py file<br>
Click RUN (not run snippet)<br>
If on a Mac, ignore the two silly xxx.dylib messages (click bin or ignore)<br>
Hey presto.</p>
<p>As for missing stocks, run with the hide hidden XYZs set to NO (so nothing is excluded).<br>
Let me know if it works or whether you still have missing stocks?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T10:29:31Z2020-12-13T10:29:31ZTotalling of Stock Holdings<div><p>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.<br>
Many thanks for your help, Geoff</p>
<p>Sent from Mail for Windows 10</p></div>etj92tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T10:33:31Z2020-12-13T10:34:40ZTotalling of Stock Holdings<div><p>FYI. When you run the script it tells you the version in the title bar heading in brackets.<br>
PS - to use the extension you will have to unzip the zip file and install / load the enclosed .mxt file.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T11:18:42Z2020-12-13T11:18:42ZTotalling of Stock Holdings<div><p>Morning Stuart,<br>
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</p>
<p>Sent from Mail for Windows 10</p></div>etj92tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T11:30:05Z2020-12-13T11:30:05ZTotalling of Stock Holdings<div><p>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!<br>
Geoff</p>
<p>Sent from Mail for Windows 10</p></div>etj92tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T11:31:48Z2020-12-13T11:31:48ZTotalling of Stock Holdings<div><p>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</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T12:07:02Z2020-12-13T12:07:02ZTotalling of Stock Holdings<div><p>You get 2021.2012 from here: <a href="https://infinitekind.com/preview">https://infinitekind.com/preview</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T15:41:06Z2020-12-13T15:41:06ZTotalling of Stock Holdings<div><p>Thanks Stuart, that’s installed and works a treat with the extension. I’m learning slowly with your help!<br>
Many thanks,<br>
Geoff</p>
<p>Sent from Mail for Windows 10</p></div>etj92tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T15:42:33Z2020-12-13T15:42:33ZTotalling of Stock Holdings<div><p>You may be the very first user running a Python Extension in Moneydance.....!</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T18:24:56Z2020-12-13T21:41:00ZTotalling of Stock Holdings<div><p>Hi,</p>
<p>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.</p>
<p>This the log of the attempt.</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T18:35:20Z2020-12-13T18:41:15ZTotalling of Stock Holdings<div><p>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</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T19:50:33Z2020-12-13T21:51:01ZTotalling of Stock Holdings<div><p>Hi Stuart</p>
<p>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.</p>
<p>Screen shot is at end of the log</p>
<p>Thanks</p>
<p>David</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T20:19:51Z2020-12-13T20:19:51ZTotalling of Stock Holdings<div><p>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?</p>
<p>Regards Stuart B</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T20:47:27Z2020-12-13T20:47:27ZTotalling of Stock Holdings<div><p>Hi Stuart,</p>
<p>Yes that would be good. You are right, had not thought of thar aspect.</p>
<p>How do we do that? I need to give you my E Mail address in the text of a reply?</p>
<p>Best</p>
<p>David</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-13T20:59:44Z2020-12-13T21:14:37ZTotalling of Stock Holdings<div><p>...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-14T17:46:20Z2020-12-14T17:46:20ZTotalling of Stock Holdings<div><p>Latest version released as an extension today.... (extension only works on MD2021.2012 onwards)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-15T15:56:49Z2020-12-15T15:56:49ZTotalling of Stock Holdings<div><p>OK, we have identified and fixed a bug uncovered by David's data - thanks DVL. Updated extension and script attached</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-17T10:03:24Z2020-12-17T10:03:24ZTotalling of Stock Holdings<div><p>Thanks, that works well.</p>
<p>Would it possible to have a report similar to the “Investment Performance “ report on this basis.?</p>
<p>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.</p>
<p>Thanks</p>
<p>David</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-17T10:12:45Z2020-12-17T10:12:45ZTotalling of Stock Holdings<div><p>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.....?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-17T10:40:25Z2020-12-17T10:40:25ZTotalling of Stock Holdings<div><p>Hi<br>
If I could take my data, download it into Excel, and manipulate there to<br>
give the desired result, would that help.?<br>
David</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242020-12-17T11:02:18Z2020-12-17T11:02:18ZTotalling of Stock Holdings<div><p>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....</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242021-02-15T22:40:35Z2021-02-15T22:40:35ZTotalling of Stock Holdings<div><p>To StockGlance2020 users. All my extract scripts have now been consolidated into a single script/extension called extract_data. The old individual scripts have been decommissioned.</p>
<p><a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478550242021-02-16T15:34:23Z2021-02-16T15:34:23ZTotalling of Stock Holdings<div><p>Is anyone from IK monitoring this discussion and could comment on if there is a formal development submission to augment the investment reporting capability such that we can get reports of our investments per portfolio (vs per account)?</p>
<p>Like the OP, I need a report that will give me totals for my individual holdings, regardless of which account they are in. In other words, I don't want to subtotal by account. In fact I'd like the option of the other way around: for each holding, give me my totals (as well as associated data like gains, etc) and optionally tell me which account(s) contain each of my holdings.</p>
<p>If such a request is in the queue for development, are there any timelines for availability?</p></div>CanSaver