Lot Matching

rayplayer's Avatar

rayplayer

21 Jan, 2021 11:22 AM

Hi, I need some help - I have sold all of my BT shares, but when it came to lot matching things didn't match up.

I concluded that I hadn't done this right in the past and decided to 'cancel' thinking I'd come back to it and sort it out later.

I didn't take a screenshot before I 'cancelled' and now wish I had as I'm now struggling to get back to the lot matching? Any help would be appreciated. Also any tips on how to sort out a historical mess that I have created in the past?

Many Thanks

Ray

  1. 1 Posted by Stuart Beesley ... on 21 Jan, 2021 08:14 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Go to the investment account.
    Click securities (top right)
    Select the security in the little drop down (top right ish)
    Click edit LOTS (might be lot history)
    You should be able to change there.

    Let us know?

  2. 2 Posted by rayplayer on 22 Jan, 2021 12:11 PM

    rayplayer's Avatar

    Hi Stuart, I followed your instructions and its now all sorted.

    Many Thanks

    Ray

  3. 3 Posted by dtd on 22 Jan, 2021 07:52 PM

    dtd's Avatar

    I just sold some shares but when I go to the security, "edit lots" is greyed out.

    Maybe I'm missing something.

  4. 4 Posted by dwg on 22 Jan, 2021 08:05 PM

    dwg's Avatar

    You most likely have the security set to use Average Cost.

  5. 5 Posted by dtd on 22 Jan, 2021 08:08 PM

    dtd's Avatar

    Well, admittedly this is the first time I've sold this security since I moved to moneydance, so I assume Average Cost is the default.

    How do I change it? (I went to edit security - no love)

  6. 6 Posted by dwg on 22 Jan, 2021 08:13 PM

    dwg's Avatar

    On the security detail screen use the edit security button, the setting is a radio button on that screen.

    Yes Average Cost is the default. It is a suitable setting for funds but for shares, depending on where you are in the world, it may not be.

  7. 7 Posted by dtd on 22 Jan, 2021 08:16 PM

    dtd's Avatar

    don’t see it.

  8. 8 Posted by dtd on 22 Jan, 2021 08:19 PM

    dtd's Avatar

    tools/securities
    edit securities (pick stock)
    edite (radio button) next to security name

  9. 9 Posted by dwg on 22 Jan, 2021 09:50 PM

    dwg's Avatar

    I know the window that you re showing all I can say is that I'm currently on Linux system, yes I regularly use different machines, and all I can say is from the security details screen I end up with a dialog shown below

  10. 10 Posted by Stuart Beesley ... on 22 Jan, 2021 10:00 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Me too. It looks like you’re trying to edit the security from the tools/security screen and not the investment account security screen?

  11. 11 Posted by Stuart Beesley ... on 22 Jan, 2021 10:08 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    .

  12. 12 Posted by dtd on 23 Jan, 2021 03:01 AM

    dtd's Avatar

    Ok, so how do i get to your window vs my window? I showed my path.
    Show me yours.

  13. 13 Posted by dwg on 23 Jan, 2021 03:09 AM

    dwg's Avatar

    Look at my underlying screen image, I have the investment account open, I select the Security Detail screen, make sure the security I want is selected, then click on the Edit Security button from the group of six buttons underneath the summary information.

  14. 14 Posted by dtd on 23 Jan, 2021 04:04 AM

    dtd's Avatar

    Ok, i get-it. Still not intuitive, given it is a parameter.

    I set it correctly, then cannot enter any values, everything is non enterable or matchable. So, still no win.

  15. 15 Posted by dtd on 23 Jan, 2021 04:11 AM

    dtd's Avatar

    Also two pertinent items

    I get A "not match" in all situations.

    Also, I can't get rid of the window. It keeps popping up even after multiple cancels.''

    yes ultimately i can get rid of the window, but others might not. cancel does not work.

  16. 16 Posted by dtd on 23 Jan, 2021 04:18 AM

    dtd's Avatar

    You have allocated the incorrect amount of shares

    is the standard response.

  17. 17 Posted by Stuart Beesley ... on 23 Jan, 2021 07:42 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Keeps popping up means that not all shares are properly matched….

  18. System closed this discussion on 24 Apr, 2021 07: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