Unable to close a Share/Equity account

[Thomas Baumgart]

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

-------------------------------------------------------------
Q: Are you concerned about the increase in artificial intelligence?
A: No, but I'm concerned about the decrease of real intelligence.
-------------------------------------------------------------
-------------- 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/20231118/0cc45c3d/attachment.sig>