INFO: Schwab now downloads up to 48 months (4 years) vs. 18 months (1.5 years)

dtd's Avatar

dtd

30 May, 2021 10:37 PM

Due to circumstance, I had to do a reset sync on a Schwab account. Got 4 years of data, which surprised me vs the traditional 18 months I've seen before. Since I converted to Moneydance a bit over a year ago, I now have about 3 years of duplicate transactions to go through.

Will do so, but it will become my afternoon, and I just thought this might be a bit of useful info for others.

  1. 1 Posted by dtd on 30 May, 2021 10:39 PM

    dtd's Avatar

    It would be nice if "Reset Sync" allowed you to set a reset date vs. set to zero.

    But I've said that before in quite a few areas....

  2. 2 Posted by dtd on 30 May, 2021 10:41 PM

    dtd's Avatar

    @Stuart - yes, I know, I could have used Toolbox. But I didn't expect the four years of data until it had already happened. And I'm detailed enough to just deal with it vs. deleting all the new entries. i.e. I'm keeping the new entries and deleting the old, as I tell others to do. Just a couple hours work.

  3. 3 Posted by dtd on 31 May, 2021 12:21 AM

    dtd's Avatar

    It also seems to have messed up my "share history sold" area.

    And I cannot seem to fix it. Is the share history allocated to a transaction and I've now deleted it? Even when I reallocate (and Ive learned how to do it correctly) MD says "shares allocated incorrectly". It seems I cannot fix the share history sales area now.

  4. 4 Posted by dtd on 31 May, 2021 12:37 AM

    dtd's Avatar

    This would be for Ford in 2017. (i.e. the 4 year bit) I've redone the transactions, but the security history no longer seems to remember the lot buy/sell transactions. Any way to relink these?

  5. 5 Posted by dwg on 31 May, 2021 12:55 AM

    dwg's Avatar

    I would expect the lot information would be part of the transaction, it really relates to the specific transaction given what lots sold are user selected for the security purchased on that date in that account only not for the overall security.

  6. 6 Posted by dtd on 31 May, 2021 01:09 AM

    dtd's Avatar

    Ok. More info - It's all about "fixing" late 2017. Now, with the share history forgetting the transaction allocation (it MUST be assigned to the transactions, or things don't make sense), I cannot reallocate the share sales to the new transactions.

    In particular, it's about an 82 share sale and a 518 sale. Neither work. I could post both, but the 82 is much simpler. I always end up with "incorrect allocation", for both.

    Any thoughts on how to make this right?

  7. 7 Posted by dtd on 31 May, 2021 01:11 AM

    dtd's Avatar

    dwg - I agree - so I'm trying to relink the information to the "new" transactions.

    But cannot seem to make that work.

  8. 8 Posted by dtd on 31 May, 2021 01:20 AM

    dtd's Avatar

    I just tried pursuing the "make both work" combined together (i.e. the 82/518 combination), but still get the "incorrect allocation". Does not appear I can fix this with the current software profile.

  9. 9 Posted by dtd on 31 May, 2021 01:33 AM

    dtd's Avatar

    And so, just for kicks and grins, here is the 518 one....

    Any thoughts? I think there is a bug here.

  10. 10 Posted by dtd on 31 May, 2021 01:58 AM

    dtd's Avatar

    I don't know how to better "state my case".

  11. 11 Posted by Stuart Beesley ... on 31 May, 2021 06:50 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    Dtd. Toolbox has options to reset the lot matching. I’ve seen that where it’s set wrongly, you need to reset it before trying to fix. It can also attempt auto matching for you too. Try on a test dataset

  12. 12 Posted by dtd on 01 Jun, 2021 01:42 AM

    dtd's Avatar

    In testing this further, it appears that there are double allocations that cause the problem. i.e. one lot is assigned to x sold shares, then that same lot which is recreated is assigned as x shares to a different x sold shares.

    So we get duplicates. When looking carefully, you can see that " -16 " shares are left to allocate, as 16 shares are allocated in one place, then 16 again to an assignment that had been abandoned due to the deletion.

    The only way to fix this within moneydance is to VERY carefully walk through each lot assignment, (never hit ok), and zero out the duplicates and then properly assign them to the recreated lots.

    Just documenting the issue.

    (Stuart's toolbox helped, but I was really looking for a way to fix this within MD)

  13. 13 Posted by dtd on 01 Jun, 2021 01:47 AM

    dtd's Avatar

    Even if it never gets fixed, this should be given a bug number, if so, I can also provide more detailed info.

  14. System closed this discussion on 31 Aug, 2021 01:50 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac