Problem with MD rounding Commissions and changing totals from .QFX and .OFX

jason's Avatar

jason

03 Nov, 2018 03:38 AM

Hello,

Moneydance Version: 2017.8 (1691)
OS: Windows 10

I have having a trouble importing .QFX and/or .OFX files into my investment account from downloaded information from my USA stock Broker (Interactive Brokers (IB))

I live in Australia, so my base currency is AUD, however in my Moneydance file I have a USD Investment account.
When I import the .QFX or the .OFX file (problem happens with both) Moneydance seems to change the “Amount” value a little bit (normally by 1 cent one way or the other) or the Commission amount a little (normally by 1 cent) and therefore changes the price per share a little bit to suit.

It seems to be an error (maybe a rounding error) in the commission that is associated with the import transaction. It appears to be predominantly on Sells as the sell orders have many more instances of the commission not being an exact dollar amount. That is commission is more likely to $0.00000000 (or similar) rather than $0.00

However, I have downloaded a program that allows me to open and look at the .QIF file, and the QIF file looks 100% correct (See screen shot and attached file)

I have tried to show 4 examples in the screen shot attached

Whilst these 4 examples only show 1 case of the “Amount” being different and the Commission being “wrong” it appears that the error happens at about an even split.

As per above, this error may be due to the way that MD handles rounding of commission, however on the opposite hand the .QFX and .OFX files appear to have the correctly rounded information.

Any assistance would be appreciated.

Thanks

  1. 1 Posted by jason on 03 Nov, 2018 03:41 AM

    jason's Avatar

    Forgot to attach a couple of files, however does not appear that I can upload the .QFX file

  2. 2 Posted by sth on 04 Nov, 2018 05:35 PM

    sth's Avatar

    The QIF files are accurate in terms of commissions in USD as they should be but then MD converts them to AUD and they are off a penny or two? That may be using a different date exchange rate than you expect?

  3. 3 Posted by jason on 05 Nov, 2018 10:07 AM

    jason's Avatar

    Hi sth,
    No that is not the issue as the Investment account is set up in $US and the download is $US and the data is imported in $US. Additionally there would be problems with all of the commissions not just the ones that are of the form $0.00000000 (or similar) rather than $0.00.

    Worth noting that I originally thought that the data in the .QFX file must be at fault, so I downloaded a .csv file thinking I could manipulate the data and then import a .csv file into the investment account. This is when I noticed the pattern of the erros in MD being associated with trades where the commissions that had more than 2 decimal places and thus a rounding error.

    I have just opened the .QFX file in "notepad" and found that the .QFX file definitely has the commissions with more than 2 decimal places and in these instances MD does not round up at all - it just ignores the number past the second decimal place.

    See new screen shot attached in which a commission of 1.037633 is imported into MD as 1.03 instead of 1.04 resulting in the price per share being calculated as 27.959872 instead of 27.96 which is the information in the .QFX file.

    So definitely a bug with respect to the information that MD uses as data and what it then calculates from that data.

    Can someone from MD please respond, or is there a way that I can import a .csv file into an Investment account?

    Thanks

  4. 4 Posted by jason on 09 Nov, 2018 09:35 AM

    jason's Avatar

    Hello,

    Any response from IK / MD support would be appreciated

Reply to this discussion

Internal reply

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

Attaching KB article:

»

Already uploaded files

  • MD_Comparison_with_CSV.xlsx 9.89 KB
  • Moneydance_Screenshot.JPG 128 KB

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