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

Fri Nov 24 14:17:18 GMT 2023

On Sonntag, 19. November 2023 14:51:37 CET Michael Calder via KMyMoney wrote:

> 
> 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?

Not really. How do you open the database for reading in KMyMoney? Don't you have
to supply a password there also? OTOH, did you try to leave it empty?

> 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.

See above. Another idea would be to use 'Save as...' and create a new database. Not sure
if that will work though.

Thomas

> 
> 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
> >

-- 

Regards

Thomas Baumgart

-------------------------------------------------------------
My friend couldn't afford to pay his water bill.
So I sent him a 'get well soon' card.
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 868 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20231124/a7fb9732/attachment.sig>