BUG - Unable to clear out a security, nano-shares remain. With workaround solution
Unable to clear out a security, nano-shares remain. I suspect it's due to a failure with math during stop splits. Reported via quicken problem reporting.
I have an asset I sold years ago. But when I go to Investing >> Dashboard >> Brokerage (or all accounts), small quantities of the asset remain. With -0.000,009 shares (0.9 micro shares or 900 nano shares). I was unable to zero out the account.
I did try going to the last sale I had of 230 shares.
— I had a purchase of 2760 shares
— A 12:1 reverse stock split
— 2760 ÷ 12 = perfect 230 shares, but 0.083,333 division probably done base 2)
— A sale of 230 sharesHere's the split transaction itself. It doesn't show any math being done, just an "old shares / new shares" box..
At that last sale on 11/1/2021, I tried selecting "sell all shares in this account". When I select "Enter/Done", I get a pop up that says "Number of shares selected is more than the available. Maximum available shares on this security is 229."
I tried setting the sale to 229 shares and adjusting the per-share price. Saved. Then when I edit the sale again and select "sell all shares" it auto-adjusts back to 230, then tells me I can only sell 229.
So I can sell 230 shares. But if I try to sell all shares, I'm guessing there's a "divide by 12 " rounding error (binary division vs base 10 division) and the remaining fractional amount has created the error. Search on the quicken board has shown I'm not the only one with this issue.
https://community.quicken.com/discussion/7879735/how-to-zero-out-securities-value
https://community.quicken.com/discussion/7884862/zeroing-out-a-security-and-getting-a-residual-negative-basis
I found an option once, that gave me a pop up box where you could zero out an security per a certain day, but now I can't find it. I'd appreciate any help.
I found a "Bad but works" fix for the issue. I manually adjusted the shares and changed the original purchase price. This destroys history, but did eliminate the division step that appears to have been occurring in the background. The renaming nano.shares were gone. I prefer not to do that—I prefer for Quicken to work correctly.
A more elegant fix would be for Quicken to utilize base 10 math in all instances, because I have similar instances in occurring in other closed transactions. I'm undoing my fix here (restoring an older data file) because I prefer the issue be fixed rather than me slapping bandaids.
