Home → Investments →

Portfolio View Display Broken / MD Freezes

• Edit

Timppa

15 Oct, 2024 11:17 PM

I maintain a Charles Schwab investment account with transactions in MD going back to 2019. Last week they split a number of their ETFs. One of these ETFs, post-split, has broken MD. I noticed initially when my portfolio view was wrecked. See attached (redacted information to preserve my privacy; what's redacted IS displaying correctly)

I've identified the offending transaction (attached), which insofar as I can tell is an unremarkable post-split sale (Schwab forced cash-in-lieu sales of fractional shares) with similar sale transactions on other securities that split the same day not manifesting any issues.

With the offending transaction identified, I went back to a backup file from before the split, and attempted to work with it in isolation. I can enter the transaction successfully if I do it WITHOUT recording the split in the security price history. If I record that split, then enter the transaction, MD freezes. Conversely, I can enter the transaction without the split, but as soon as I add the split to the security history MD will freeze. The error log is empty of any information connected to this transaction/security. I believe the freeze occurs before MD can write any information thereto.

These are manual transaction entries and splits. I am not trying to import or download.

Toolbox finds a duplicate security but it's in a totally different account and deleting it does not change the above behavior.

The first two diagnostics (Validate and fix base security & Diagnose currencies / securities) are mostly error free. The latter finds 34 examples of the following error, and fixing them does not change the above behavior:

@@ WARNING: 'VWILX - Vanguard International Growth Fund - Admiral Class' relative_to_currid / rel_curr_id should only be None or NOT your base currency (currently USD : None)!
 ----------------------------------------------------------------
You have 34 Warning(s)..
These are where your Currency records show a relative currency that's not None...;
... or where Securities have an incorrect relative currency set..
... or where a Currency/Security's new 'rrate' (relative rate) is not set, or different to the legacy 'rate'...
... or where an 'invalid' / 'infinity' / ZERO / Not A Number (NaN) rate / 'rrate' was found
NOTE: Often these issues are from 'legacy' MD2017 records that need updating to MD2019+ format by adding the 'rrate' field
      MD2021.2 has fixes built in to address the 'rrate' issues....
Consider running the 'FIX CURRENCIES & SECURITIES' option

I am officially out of ideas here. :(

• Screenshot_2024-10-15_at_15.09.12.png 111 KB
• Screenshot_2024-10-15_at_15.56.56.png 15.4 KB

1. 1 Posted by dtd on 16 Oct, 2024 02:38 AM

   

   There was a bug recently where (specifically Apple, but basically with splits occurring on non consecutive dates) errors could occur.

   What version of MD are you using? This issue has been corrected, but I'm not sure where in the "version stream" it was fixed. (I'm a tester, still "just a user", so my experience goes all the way to alpha versions...)

   • Edit

2. 2 Posted by Stuart Beesley ... on 16 Oct, 2024 06:30 AM

   

   You don’t mention your version. As dtd says….

   The cost basis calculation engine was rebuilt for 2024. There was one bug with (some) splits causing an infinite loop (or hang).

   It’s fixed in 2024.2. There is a preview available
   https://infinitekind.com/preview

   And also an later alpha available
   https://infinitekind.com/prepreview

   However there are other issues in these builds being resolved (virtually done). So I would wait for alpha build 5170 or later which should be out today (we believe).

   Or wait until it makes a new preview… soon.

   • Edit

3. 3 Posted by Timppa on 16 Oct, 2024 03:23 PM

   

   Okay, I put everything in the post except my version. Doh! 🤦🏻‍♂️

   2024.1 (5118)

   I'll try 5170 and report back.

   Interestingly enough, the offending ETF (SCHD) split 3 to 1. There's no other split history in my price database for this security. Another ETF (FNDX) without a split history split 3 to 1 and does not manifest this problem. Whatever is triggering this bug must be very specific. :(

   • Edit

4. 4 Posted by Stuart Beesley ... on 16 Oct, 2024 03:39 PM

   

   It’s caused by an infinitesimal rounding issue causing a very small 0.00001 (for example) remainder when dividing shares by split amounts and this causes a loop. You either get lucky or not

   • Edit

5. 5 Posted by Timppa on 16 Oct, 2024 07:12 PM

   

   These were forward splits, so it should have been a multiplication operation, and the bug only manifested with the combination of split + sale transaction. Either in a vacuum did not break MD.

   Happy to share that 5170 seems to have resolved the issue. There are other ETFs which forward split I need to account for, in different accounts, but those I was able to enter w/o issue on 5118 so I assume (hope) it'll be the same here. If I don't update this thread within 24 hours you can assume I'm good. :)

   Thanks for the patience with my brain fart of neglecting to include version information. 🤦🏻‍♂️

   • Edit

6. Timppa closed this discussion on 17 Oct, 2024 09:09 PM.