Why is Quicken not updating my investment accounts?

Robin Whyte

Quicken (Deluxe, Canada 2020 5.16.1) is not updating my investments properly, and not even close. My six Canadian TD brokerage accounts each contain US and Canadian funds. The TD website shows the price of each fund in US or Canadian funds, and then converts the US to Canadian to work out Market Value of the holding. The downloaded Qfx file doesn’t do the conversion, so the US market values are wrong, as it the value of the account. This affects all my accounts. Furthermore, at least one of the holdings, XDIV on TSE, is valued using XDIV on NYSE, a completely different holding of very different price. So the whole thing is nonsense. I have not had satisfaction with chat, and have reported this in detail to Quicken engineers. Is this a Quicken error? How is a Qfx file written and read?

Chris_QPW

Besides what @NotACPA said I will point out that downloading a QFX file shouldn't "do the conversion".  It makes no sense.

How would it convert between two currencies?

The currency exchange is based on the exact time of the transaction.  There is no way Quicken would know that and be able to do it.

Another thing that I believe that is going on since you have Quicken Mac is to understand that Quicken Mac doesn't really have multiple currency support.  You can change the currency sign on the account, but there isn't any functions that actually do anything with currencies in Quicken Mac.   It is just "numbers" to Quicken Mac.

NotACPA

Well, for starters, you can't hold CAD and USD in the same account in Q.  Likewise, you can't hold CAD securities and USD securities in the same account in Q.

SO, try separating them  and see if that helps.

Chris_QPW

Besides what @NotACPA said I will point out that downloading a QFX file shouldn't "do the conversion".  It makes no sense.

How would it convert between two currencies?

The currency exchange is based on the exact time of the transaction.  There is no way Quicken would know that and be able to do it.

Another thing that I believe that is going on since you have Quicken Mac is to understand that Quicken Mac doesn't really have multiple currency support.  You can change the currency sign on the account, but there isn't any functions that actually do anything with currencies in Quicken Mac.   It is just "numbers" to Quicken Mac.