Tiny residual holdings showing up in Portfolio views after R27.20 Quicken update [edited]
Vince3
Member ✭✭
I just downloaded the latest Quicken update and now out of the blue a few hidden securities are showing up on my update register. They all are marked hidden. What's the fix?
0
Best Answers
-
q_lurker
SuperUser ✭✭✭✭✭
One of the "improvements" for R27 20 is
- Improved: Quicken now allows up to six numbers after the decimal point when calculating fractional shares.
You might want to go to the last sale of each applicable security in the applicable account and edit that sale choosing the Sell All Shares selection.6 -
Jim_Harman
SuperUser ✭✭✭✭✭
I edited the title of this post to more clearly describe the problem.-- Jim QWin Premier subscription5
Answers
Are these securities that you held at one time then sold all your shares and now they show with a non-zero balance in one or more of your accounts?
Note that hiding securities in Quicken only removes them from selection lists, it does not make them go away if you have a nonzero balance.
They are suddenly showing up in my update screen. These are accounts that have been hidden for years and haven't shown up for a very long time. It happened directly after I updated to the latest Quicken update Version R27.20 last week. They all have zero balance. It also appears to be pretty random as other hidden stocks and accounts are not showing up.
Are they hidden securities as you said in your original post, or hidden accounts, or both? An account can generally hold multiple securities.
To your second question: One was a single purpose stand alone account for a specific Mutual Fund. The other 2 or 3 are securities held in a brokerage account or in an IRA Account with other securities. In both cases they are hidden.
As I said above, hiding a security or account does not affect whether it appears in these views, it only affects the account and security selection lists when you customize the view.
Click on the Options gear at the top right of this view and see if "Show closed lots" is selected. You want it un-checked. If that is selected, securities with a zero balance on the As of date (normally today) may appear in the view, depending on the customization settings for the view.
Unfortunately Quicken settings sometimes change when the software is updated.
- Improved: Quicken now allows up to six numbers after the decimal point when calculating fractional shares.
Speculation: It may be that what Quicken had computed as 0 shares to 5 or less digits is now computing as 0.000001 to 0.00005 shares in the new release. Your portfolio view may not be showing that level of precision.You might want to go to the last sale of each applicable security in the applicable account and edit that sale choosing the Sell All Shares selection.
It's possible that you still have tiny fractions of shares left over in these holdings that make them non-zero.
Try clicking on Customize for the view, then on the Securities tab check Show (hidden securities). Are the problem securities selected? If so, un-checking them should make them disappear from the view.
To eliminate any fractional left-over shares, you could go to the last sale of these securities in the problem account(s) and select "Sell all shares in this account." Keep the total proceeds the same as it was originally.
Be sure to back up your data file before modifying historical data, in case something goes wrong.
All the other problems disappeared after I went to the last sale and entered "Sell All Shares".
If you have any ideas on that last straggler I'd appreciate it. But thanks a lot for the help!! I would have never figured that one out.
Be especially alert for any sale or remove transaction that might have taken your share count negative at any point in that account. Also, if you had real-world short sales on that security in that account, make sure they were properly closed with a CvrShort transaction. .
1)I did an in-kind transfer of all shares of two funds. Quicken now shows -0.000008 and -0.000002 shares in the original account. There is no "Transfer all shares" option for this type of transaction. I entered a Reinvest Dividend transaction to cancel out the negative share balance.
2)I had sold all shares in a different account and could not edit the transaction to "Sell all shares" (I was able to click the box, but it did not change the number of shares). The negative fractional share remained. I had to do a Reinvest Dividends to remove the negative share balance.
A third account was fixed using "Sell all Shares". In that case, the share balance was positive.
Summary: the phantom shares only appear in portfolio view, not reports; a negative share balance couldn't be fixed using Sell All Shares.
That fixed the issue for me
Improved: Quicken now allows up to six numbers after the decimal point when calculating fractional shares.
This was not sufficiently tested.
Nothing is more rewarding that spending an afternoon scouring my portfolio looking for odd positions to adjust for a .00001 or so share imbalance. The trick for checking 'sell all shares' works most of the time unless there is a negative share balance. In that case, to correct the negative share balance you have to correct the transaction manually.
The good news is that this problem is nowhere near as severe as the problem this past year wherein Quicken failed to download transactions from the financial institutions. The bad news is that Quicken is wasting my time and that is precisely the opposite reason why I use Quicken.
TA3 understates the situation by saying "This was not sufficiently tested."