Don't understand basis calculation after stock split and subsequent sales

Richard Ledbetter's Avatar

Richard Ledbetter

30 May, 2024 06:46 PM

I purchased 10 shares of this stock . The stock split 10 for 1. Subsequently I sold a portion of the stock in two separate transactions. Attached is a document showing transactions and the security detail.

My calculations would indicate the remaining basis should be 3525.38. (5892.3/100 = 58.92 per share)
60 shares * 58.92 = 3535.38.

Instead the basis appears as -7070.76. Negative 2 * the remaining basis.
I am either missing something or the calculation of cost basis is wrong in the security detail.
Your

  1. 1 Posted by Stuart Beesley ... on 30 May, 2024 07:33 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Questions.
    1. What version of MD? You need the latest Alpha to get the latest CB calculation engine (it’s been rewritten)
    2. Average or LOT control?

  2. 2 Posted by Stuart Beesley ... on 30 May, 2024 07:40 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    PS. Quickly using a calculator I also get £3,535.38.

    So, from this I deduce you are not using MD2024 and you are using Average Cost basis?

    Assuming I’m correct, you will need 2024, but due to the splits you will need the alpha build 5129… really this is for testing only.

  3. 3 Posted by Richard Ledbett... on 30 May, 2024 08:14 PM

    Richard Ledbetter's Avatar

    Thank you for responding.

    1. I am using MD 2024.1. (5118).

    2. As best I know I am using average basis. I honestly don’ know how to set this.

    Richard Ledbetter
    [email blocked] <mailto:[email blocked]>

    860-649-7719 home
    860-965-1475 mobile

  4. 4 Posted by Stuart Beesley ... on 30 May, 2024 08:34 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    That is odd. 5118 should be ok.

    I’ll test this scenario out tomorrow…

  5. 5 Posted by Stuart Beesley ... on 30 May, 2024 09:01 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Just checked the code. This scenario was fixed after 5118. So you need a MD2024.2 build. Probably Moneydance 2024.2 (5129) Or later.
    I expect this will go PREVIEW soon.

  6. 6 Posted by dtd on 30 May, 2024 11:30 PM

    dtd's Avatar

    I'd wait for the preview unless you enjoy testing alpha versions. But as Stuart says, it is very close to beta (i.e. preview)...

  7. 7 Posted by Richard Ledbett... on 30 May, 2024 11:42 PM

    Richard Ledbetter's Avatar

    Thank you. I will wait for the new version. Appreciate your response!

    Richard Ledbetter
    [email blocked] <mailto:[email blocked]>

    860-649-7719 home
    860-965-1475 mobile

  8. 8 Posted by Stuart Beesley ... on 31 May, 2024 06:39 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Just to confirm/prove to you (and me) that the update will fix this, I just tested it... It's all OK. See screenshots from 5118 and then the latest 5219.

  9. 9 Posted by Stuart Beesley ... on 31 May, 2024 01:09 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    5130 is now PREVIEW status
    https://infinitekind.com/preview

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • trade_desk.pages 29.9 MB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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