Can I use the toolbox to edit cost basis?

bschottmi's Avatar

bschottmi

05 Sep, 2023 11:28 PM

I had three bonds move from TD Ameritrade to Schwab last weekend. On all three, the quantity Schwab shows in 1000 time the quantify TD Ameritrade had. See attached.
I adjusted the current price so the Current Value is correct, but is there some way that I can fix the costs basis? I see no such option under Edit Securities and have review the toolbox but did not find anything.
Any assistance greatly appreciated.
Bill Schott

  1. 1 Posted by dtd on 05 Sep, 2023 11:53 PM

    dtd's Avatar

    What I do when this happens is to create a Sell/Buy transaction between the two accounts. I sell at the cost basis price, transfer the "money" over, and buy at the cost basis price - it's not a real transaction, but it moves the stock over, and at the basis price.

    If you keep the TD Ameritrade account, and rename it to the Schwab account, that should maintain your history, and you can adjust based on whatever extraneous transactions that Schwab sends (i.e. zero them out, etc.)

  2. 2 Posted by dtd on 05 Sep, 2023 11:55 PM

    dtd's Avatar

    Also, looking at your graphic, just as you fixed the current price, maybe change 1000 to be the cost basis (look it up from Ameritrade, or actually from Schwab) - Ameritrade should have "sent that over".

  3. 3 Posted by Stuart Beesley ... on 06 Sep, 2023 05:01 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    No, nothing can edit the cost basis.. It does not exist. It's a calculation. You need to fix the raw data.

    • How did you move the Securities between Accounts in MD?

    • I would suggest that if your qty is wrong, then fix the quantity..? If not, why not?

  4. 4 Posted by bschottmi on 06 Sep, 2023 11:39 AM

    bschottmi's Avatar

    There was no "move". I lost the ability to connect to TD Ameritrade on
    9/1. And I think I did it wrong 8-(. I created two new MD investment
    accounts and downloaded transactions from Schwab. I did not think about
    just linking the original accounts to MD+.
    Apparently in the move, Schwab created these bonds as 20,000 units where TD
    had 20 $1000 bonds. I like your idea of doing a sell and buy to fix it,
    but it failed. The cost basis did change, but is still over $1,000,000

    But I'll keep trying along those lines.

    Bill

  5. 5 Posted by Stuart Beesley ... on 06 Sep, 2023 12:16 PM

    Stuart Beesley (Mr Toolbox)'s Avatar
    1. Check your decimal places settings on the security
    2. Delete the new txns. Then Sell/Xfr out of old account and Buy into new account. USE THE COST BASIS when selling and buying (not the value)
  6. System closed this discussion on 06 Dec, 2023 12:20 PM.

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