MD using date posted instead of date traded

Dan P's Avatar

Dan P

29 Jul, 2021 09:13 PM

I had this problem with downloading investment 'BUYS' for some time now. I think it's a bug, MD may think otherwise.

When I get online BUY transactions from Vanguard, the OFX shows a Trade Date and a Settled date. The share price is the price on the trade date. But when imported, MD uses the share price with the settled date. This screws up my securities import, as the real price for 'posted date' is incorrect. I think MD should use the trade date for the security price table and settled date for the registry.
If there is an option I'm missing, I cannot find it.

Attached is a sample copy of the transaction data.

Thanks.
Windows 10, MD 2021.1 (3069)

  1. 1 Posted by Dan P on 20 Aug, 2021 03:19 PM

    Dan P's Avatar

    .

  2. 2 Posted by Dan P on 09 Sep, 2021 02:51 PM

    Dan P's Avatar

    Does anyone care to chime in?

  3. Support Staff 3 Posted by Sean Reilly on 09 Sep, 2021 04:23 PM

    Sean Reilly's Avatar

    Hi Dan,
    Sorry about not getting back to you. I have been looking into this but don't have a solution just yet. If you still have your OFX data handy, would there happen to be a DTPRICEASOF field in the file or data anywhere?

    Thanks,
    Sean

    --
    Sean Reilly
    Developer, The Infinite Kind
    https://infinitekind.com

  4. Support Staff 4 Posted by Sean Reilly on 09 Sep, 2021 04:37 PM

    Sean Reilly's Avatar

    Hi Dan,

    Actually, nevermind about checking the file. I see exactly what you mean and have fixed this for the next update to Moneydance.

    Thanks,
    Sean

    --
    Sean Reilly
    Developer, The Infinite Kind
    https://infinitekind.com

  5. 5 Posted by Dan P on 09 Sep, 2021 04:39 PM

    Dan P's Avatar

    Thanks, Sean!
    For reference, the OFX does have the DTPRICEASOF tag.

  6. Ethan closed this discussion on 12 Sep, 2021 10:09 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