Investment Performance Report / Account Groupings
This problem did not used to exist for me but now when I run an Investment Performance report, the holdings from the same account are broken out into different subgrouping and are inactive/crossing with other holdings of the same security. The report used to be where I would check my balances vs my statements and to see how the performance of my investments were over different time periods. Now it is unusable
|?||Show this help|
|ESC||Blurs the current field|
|r||Focus the comment reply box|
|^ + ↩||Submit the comment|
You can use
Command ⌘ instead of
Control ^ on Mac
1 Posted by Ben on 04 Feb, 2023 11:31 AM
I had a similar problem and you prompted me to probe it. Different report settings didn't work, but did highlight that one particular holding was misbehaving, a new one of the same security as another account. It only had one income transaction so I deleted that. The report went back to normal and is still fine even after I've created the transaction.
2 Posted by Ben on 04 Feb, 2023 11:42 AM
I've found out how to recreate the problem. I had a reminder for income from that security in account #1. I'd edited that reminder to be for the same security in account #2 instead. A test logging of income using that reminder scrambled the report again.
A new reminder created from my manual recreation tests fine. I guess there's some invisible account information in reminders that isn't changed when editing the reminder.
3 Posted by Gary K. Blum on 04 Feb, 2023 04:15 PM
Based on what you are suggesting, I think maybe this happened to me as I created a new security for the same ticker to add to a 2nd account and basically wound up with the same security in my database twice. But I just changed all of the transactions for the duplicate to the original in the hopes that would clear it up, but it didn't.
Maybe I need to delete all of the impacted transactions and try fresh?
On Saturday, February 4, 2023 at 06:42:38 AM EST, Ben <[email blocked]> wrote:
4 Posted by Gary on 04 Feb, 2023 09:26 PM
Was there a way that you were able to determine the offending security? I deleted the 5 securities that I duplicated, but the report didn't fix itself.
5 Posted by Ben on 05 Feb, 2023 12:28 PM
Ouch. In my case, when I ran a performance report that started a little before and ended a little after the opening of the new account, there was one particularly rogue section of the report containing the new account and the security for which I had a bad transaction (the report had another section for the new account and the securities in it that didn't have bad transactions). It showed an opening balance when it should have shown no balance and a buy. That whole section disappeared when I deleted the bad transaction, and now I have a single good section for the new account with no opening balances for any of the securities in it, only buys.
So maybe the clue is that the report shows an opening balance for a security in account #2 when it should only have an opening balance for that security in account #1.
6 Posted by Stuart Beesley ... on 05 Feb, 2023 02:15 PM
Ah. Do you have ‘duplicate’ securities for the same security? In tools/securities do any appear twice?
7 Posted by Gary K. Blum on 05 Feb, 2023 02:32 PM
I did, but I cleaned those up but still have the issue. It is clearly related to my wife's IRA account (which trades in parallel to my own IRA. I was putting in transactions for the accounts at different times and I had duplicated a couple of the securities. Now my IRA shows all in one section but her's is broken apart into a couple and some of holdings from mine are broken out into individual sections as well (though they are properly a part of the main section)
On Sunday, February 5, 2023 at 09:15:44 AM EST, Stuart Beesley (Mr Toolbox) <[email blocked]> wrote:
8 Posted by Stuart Beesley ... on 05 Feb, 2023 02:56 PM
Can u send a screen shot so I can see what you are referring to?
Can you run toolbox. Txn tools. Detect non-hierarchical txns?
9 Posted by Stuart Beesley ... on 05 Feb, 2023 02:57 PM
I bet you still have duplicates.
Also run fix duplicate securities within investment account too.
10 Posted by Gary K. Blum on 05 Feb, 2023 07:51 PM
I have never used the Toolbox extension.
I added it, but under Transaction tools, I only see diagnose functions of:-View Register Transactional Sort OrderExtract Attachments to FolderDIAG: Diagnose Attachments and detect Orphans too
nothing about Detech non-hierachical txns
On Sunday, February 5, 2023 at 09:57:23 AM EST, Stuart Beesley (Mr Toolbox) <[email blocked]> wrote:
11 Posted by Stuart Beesley ... on 05 Feb, 2023 08:11 PM
... and below those options....?
Enable update mode....
12 Posted by Gary K. Blum on 05 Feb, 2023 09:53 PM
This has worked! Thank you!
On Sunday, February 5, 2023 at 03:11:19 PM EST, Stuart Beesley (Mr Toolbox) <[email blocked]> wrote:
13 Posted by Stuart Beesley ... on 05 Feb, 2023 10:07 PM
What worked? It fixed something? Your report now works? More detail on what happened please? Thx.
14 Posted by Gary K. Blum on 05 Feb, 2023 10:14 PM
Running the FIX: Non-Hieracrchical Security Acct Txns found 12 transactions (dividends) that had somehow crossed between the two accounts. Once they were fixed, the report now works properly.
On Sunday, February 5, 2023 at 05:07:02 PM EST, Stuart Beesley (Mr Toolbox) <[email blocked]> wrote:
15 Posted by Stuart Beesley ... on 05 Feb, 2023 10:16 PM
Thanks!! Great to hear! 👍
Toolbox 🧰 +1 😃