Home → Investments →

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

• Edit

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

• trade_desk.pages 29.9 MB

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

   

   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?

   • Edit

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

   

   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.
   …

   • Edit

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

   

   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

   • Edit

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

   

   That is odd. 5118 should be ok.

   I’ll test this scenario out tomorrow…

   • Edit

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

   

   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.

   • Edit

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

   

   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)...

   • Edit

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

   

   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

   • Edit

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

   

   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.

   • 5118.png 66.3 KB
   • 5127.png 85.4 KB
   • Edit

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

   

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

   • Edit

10. System closed this discussion on 30 Aug, 2024 01:10 PM.

11. Richard Ledbetter re-opened this discussion on 08 Nov, 2024 02:58 AM

12. 10 Posted by Richard Ledbett... on 08 Nov, 2024 02:58 AM

    

    Just to let you know the calculation now appears to be correct. I updated in the last few weeks.

    Thanks again!

    Richard Ledbetter
    [email blocked]

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

    • Edit

13. 11 Posted by Stuart Beesley ... on 08 Nov, 2024 05:27 AM

    

    👍 ✅

    • Edit