KMyMoney Digest, Vol 155, Issue 3 - Unable to close a Share/Equity account

[Michael Calder]

G'day again,

And thanks for your replies and help.

I have found HOW to open the Database - RTFM 😳

BUT - 1. It is a DB;*SQLCipher Version 3 (encrypted SQLite)*
and I do not have a PASSWORD. The file was Created on 28/07/2010, 13 years ago!
I do not recall ever creating a PW and although I have earlier recorded PWs on a
PW protected file created 2018 which I managed to "remember" (fluke) the PW there is
nothing that works on my DB. Was there ever a default PW?

2. Regarding the stock split transaction, I think I did that before I did the fiddle of
the original 1802 to 1803 but will do another delete of the split and then re-enter the details.

I deleted the split entry and also the original Buy 1802 which was an Off Market Transfer when the stock,
which I had inherited from my mother some years previously, was transferred into Joint names.
(Comment:The transfer generated capital gains on which Tax was paid; so all done legally)
I then shut down the computer - waited and restarted - and then re-entered an Off Market transfer Buy
for 1803 on 29/7/2002 and the 1 for 3 split of 601 on 25/2/2011.

The "books" all balance and the stock now shows Value $0.00 and Quantity 0, as it should.
Unfortunately Right Click on the stock in Investments - Equities still has "Close account' greyed out.

To prove KMyMoney is all OK I did a Sell (all) on another stock I will be selling soon and had no
problem Closing the account and then Reopen account and cancelling the Sell.

Any more ideas on how to look inside the Database.

Mike.

On 18/11/23 23:00, kmymoney-request at kde.org wrote:
> Today's Topics:
>
>     1. Re: KMyMoney Digest, Vol 155, Issue 2 (Michael Calder)
>     2. Re: Unable to close a Share/Equity account (Jack)
>     3. Re: Unable to close a Share/Equity account (Thomas Baumgart)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 18 Nov 2023 07:09:48 +1100
> From: Michael Calder<michaelcalder at iinet.net.au>
> To:kmymoney at kde.org
> Subject: Re: KMyMoney Digest, Vol 155, Issue 2
> Message-ID:<d1679cea-10a1-47e0-87a0-9e619d61313d at iinet.net.au>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
>
> G'day ,
>
> Correction - the second price should also be*$5.85*  - Sorry.
>
> Mike.
>
> On 17/11/23 23:00,kmymoney-request at kde.org  wrote:
>> Today's Topics:
>>
>>      1. Unable to close a Share/Equity account (Michael Calder)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Fri, 17 Nov 2023 16:39:10 +1100
>> From: Michael Calder<michaelcalder at iinet.net.au>
>> To:kmymoney at kde.org
>> Subject: Unable to close a Share/Equity account
>> Message-ID:<b11817a8-a004-4589-b42c-0be96221fa92 at iinet.net.au>
>> Content-Type: text/plain; charset=UTF-8; format=flowed
>>
>>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:<http://mail.kde.org/pipermail/kmymoney/attachments/20231118/db14fc09/attachment-0001.htm>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 17 Nov 2023 16:10:21 -0500
> From: Jack<ostroffjh at users.sourceforge.net>
> To:kmymoney at kde.org
> Subject: Re: Unable to close a Share/Equity account
> Message-ID:<Z3MSZGJU.IUPSL6GG.6R4NH3WW at 3JJOBUNM.SAR64GGH.Q3LDWJJB>
> Content-Type: text/plain; charset=us-ascii; DelSp=Yes; Format=Flowed
>
> On 2023.11.17 00:39, Michael Calder via KMyMoney wrote:
>> 	I have a similar problem to that in KMyMoney Digest, Vol 155,
>> Issue 1 - "delete loan account (Jochen)"
>> Since 2010 I handled Investments without problems, except for the
>> recent Online "yahoo" one which is currently OK.
>> My current Investments show 23 Equity accounts of which 9 were closed
>> without problems.
>> 	I recently sold all shares in an equity which had been SPLIT
>> (consolidated) on a 1 for 3 basis on 18/2/11.
>> The original holding was 1802 which resulted in 601 being sold at
>> 5.85 each BUT! The Investments view showed
>> a "residual" Value of -$1.95 with Quantity 0 and Price $5.80. As
>> expected I cannot "Close account" as the value is not zero.
>> 	Examining the figures 1.95/5.85 is 0.3333333 and the problem
>> stems from the 1 for 3 consolidation back in 18/2/2011.
>> I have tried a "fiddle" by increasing the original 1802 to 1803 and
>> this results in the Value changing to the desired $0.00
>> but "Close account" remains greyed out.
>> 	How do I find "a copy of your data file"?
> It is possible that the residual is indeed due to a rounding problem,
> which I believe was fixed some time ago.  As the split is a likely
> candidate, the first, quick, thing I would try is to edit and save that
> stock split transaction.  That should apply the newer rules to the
> calculation of the number of shares.  There is also a perl script to
> help identify such transactions, but I've got to hunt for it and then
> figure out how to use it.
>
> In terms of finding your data file, its name is shown on the title bar
> of the program, and if you do a File/Open... it should show you the
> directory where the file is located.  (If you are using an SQL back
> end, then you don't have a "data file" you have a "data database.")
>
> Jack
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 18 Nov 2023 10:21:05 +0100
> From: Thomas Baumgart<thb at net-bembel.de>
> To: KMyMoney Users' mailing list<kmymoney at kde.org>
> Subject: Re: Unable to close a Share/Equity account
> Message-ID: <12345378.O9o76ZdvQC at sy-346-nb>
> Content-Type: text/plain; charset="utf-8"
>
> On Freitag, 17. November 2023 22:10:21 CET Jack via KMyMoney wrote:
>
>> On 2023.11.17 00:39, Michael Calder via KMyMoney wrote:
>>> 	I have a similar problem to that in KMyMoney Digest, Vol 155,
>>> Issue 1 - "delete loan account (Jochen)"
>>> Since 2010 I handled Investments without problems, except for the
>>> recent Online "yahoo" one which is currently OK.
>>> My current Investments show 23 Equity accounts of which 9 were closed
>>> without problems.
>>> 	I recently sold all shares in an equity which had been SPLIT
>>> (consolidated) on a 1 for 3 basis on 18/2/11.
>>> The original holding was 1802 which resulted in 601 being sold at
>>> 5.85 each BUT! The Investments view showed
>>> a "residual" Value of -$1.95 with Quantity 0 and Price $5.80. As
>>> expected I cannot "Close account" as the value is not zero.
>>> 	Examining the figures 1.95/5.85 is 0.3333333 and the problem
>>> stems from the 1 for 3 consolidation back in 18/2/2011.
>>> I have tried a "fiddle" by increasing the original 1802 to 1803 and
>>> this results in the Value changing to the desired $0.00
>>> but "Close account" remains greyed out.
>>> 	How do I find "a copy of your data file"?
>> It is possible that the residual is indeed due to a rounding problem,
>> which I believe was fixed some time ago.  As the split is a likely
>> candidate, the first, quick, thing I would try is to edit and save that
>> stock split transaction.  That should apply the newer rules to the
>> calculation of the number of shares.  There is also a perl script to
>> help identify such transactions, but I've got to hunt for it and then
>> figure out how to use it.
> That is located e.g. at
>
> https://invent.kde.org/office/kmymoney/-/blob/master/contrib/getsplitpart.pl?ref_type=heads
>
> and contains a bit of documentation how to use it.
>
>> In terms of finding your data file, its name is shown on the title bar
>> of the program, and if you do a File/Open... it should show you the
>> directory where the file is located.  (If you are using an SQL back
>> end, then you don't have a "data file" you have a "data database.")
> The above mentioned script does not work with an SQL back end
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20231120/7c899d1f/attachment.htm>