tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/87192-investment-performance-report-account-groupingsInfinite Kind: Discussion 2023-05-07T22:20:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-03T12:31:21Z2023-02-03T12:31:22ZInvestment Performance Report / Account Groupings<div><p>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</p></div>Gary Blumtag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-04T11:31:58Z2023-02-04T11:31:58ZInvestment Performance Report / Account Groupings<div><p>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.</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-04T11:42:38Z2023-02-04T11:42:38ZInvestment Performance Report / Account Groupings<div><p>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.</p>
<p>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.</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-04T16:15:43Z2023-02-04T16:15:44ZInvestment Performance Report / Account Groupings<div><p>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. <br>
Maybe I need to delete all of the impacted transactions and try fresh?<br>
On Saturday, February 4, 2023 at 06:42:38 AM EST, Ben <a href="mailto:tender+d16c1c41e8@tenderapp.com">tender+d16c1c41e8@tenderapp.com</a> wrote:</p>
<table>
<tr>
<td></td>
</tr>
</table></div>Gary K. Blumtag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-04T21:26:38Z2023-02-04T21:26:44ZInvestment Performance Report / Account Groupings<div><p>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.</p></div>Garytag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T12:28:14Z2023-02-05T12:28:14ZInvestment Performance Report / Account Groupings<div><p>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.<br>
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.</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T14:15:45Z2023-02-05T14:15:45ZInvestment Performance Report / Account Groupings<div><p>Ah. Do you have ‘duplicate’ securities for the same security? In tools/securities do any appear twice?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T14:32:23Z2023-02-05T14:32:23ZInvestment Performance Report / Account Groupings<div><p>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)<br>
On Sunday, February 5, 2023 at 09:15:44 AM EST, Stuart Beesley (Mr Toolbox) <a href="mailto:tender+d16c1c41e8@tenderapp.com">tender+d16c1c41e8@tenderapp.com</a> wrote:</p>
<table>
<tr>
<td></td>
</tr>
</table></div>Gary K. Blumtag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T14:56:50Z2023-02-05T14:56:50ZInvestment Performance Report / Account Groupings<div><p>Can u send a screen shot so I can see what you are referring to?</p>
<p>Can you run toolbox. Txn tools. Detect non-hierarchical txns?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T14:57:16Z2023-02-05T14:57:16ZInvestment Performance Report / Account Groupings<div><p>I bet you still have duplicates.</p>
<p>Also run fix duplicate securities within investment account too.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T19:51:30Z2023-02-05T19:51:30ZInvestment Performance Report / Account Groupings<div><p>I have never used the Toolbox extension. <br>
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<br>
nothing about Detech non-hierachical txns</p>
<p>For the <br>
On Sunday, February 5, 2023 at 09:57:23 AM EST, Stuart Beesley (Mr Toolbox) <a href="mailto:tender+d16c1c41e8@tenderapp.com">tender+d16c1c41e8@tenderapp.com</a> wrote:</p>
<table>
<tr>
<td></td>
</tr>
</table></div>Gary K. Blumtag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T20:11:10Z2023-02-05T20:11:10ZInvestment Performance Report / Account Groupings<div><p>... and below those options....?</p>
<p>Enable update mode....</p>
<p>see screenshot</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T21:53:22Z2023-02-05T21:53:30ZInvestment Performance Report / Account Groupings<div><p>This has worked! Thank you!<br>
On Sunday, February 5, 2023 at 03:11:19 PM EST, Stuart Beesley (Mr Toolbox) <a href="mailto:tender+d16c1c41e8@tenderapp.com">tender+d16c1c41e8@tenderapp.com</a> wrote:</p>
<table>
<tr>
<td></td>
</tr>
</table></div>Gary K. Blumtag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T22:07:01Z2023-02-05T22:07:01ZInvestment Performance Report / Account Groupings<div><p>What worked? It fixed something? Your report now works? More detail on what happened please? Thx.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T22:14:59Z2023-02-05T22:14:59ZInvestment Performance Report / Account Groupings<div><p>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.<br>
Thx<br>
On Sunday, February 5, 2023 at 05:07:02 PM EST, Stuart Beesley (Mr Toolbox) <a href="mailto:tender+d16c1c41e8@tenderapp.com">tender+d16c1c41e8@tenderapp.com</a> wrote:</p>
<table>
<tr>
<td></td>
</tr>
</table></div>Gary K. Blumtag:infinitekind.tenderapp.com,2009-01-14:Comment/578104422023-02-05T22:16:11Z2023-02-05T22:16:11ZInvestment Performance Report / Account Groupings<div><p>Thanks!! Great to hear! 👍<br>
Toolbox 🧰 +1 😃</p></div>Stuart Beesley (Mr Toolbox)