Fx rate applied in reverse

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Download FT.com .csv file
2. Import to hle-ofx-quotes - price in (e.g.) Euro shown correctly
3. Import to MM 

What is the expected output? What do you see instead? In Portfolio view stock 
Last Price should be shown in (e.g.) Eur. In this case it is shown multiplied 
by the Fx rate. e.g. €45.60 is shown in hle-ofx-quotes, but when imported to 
MM (with MM fx €/£ rate set at 1.14) it shows up as €51.98. This is then 
multiplied by qty. of shares to produce (an incorrect) value. MM handles mixed 
currencies within an account by showing values in the column in the quoted 
currency, and adjusting the account total to show correct total in the BASE 
currency. i.e. with mixed currencies the sum of the value column items does not 
equal the account total. (!) 

What version of the product are you using? On what operating system?
Money 2004 Version 12 (UK), first under Windows XP SP3 and now under Windows 7 
SP1. Same result in both cases.

Please provide any additional information below.
1. Huge thanks to Hung Le for producing this software.
2. It has worked for me using both Google and ft.com sources, except for this 
fx glitch, which is consistent from both sources.
3. The problem seems to occur when the import to MM is executed.
4. The account in question contains 15 stocks quoted in GBP and 1 in Eur. 
Before Microsoft withdrew their update service the Eur value appeared correctly 
in the Last Price column in Portfolio view, and the account total was correct 
in GBP. As explained above the arithmetic total of the items in the Mkt Val 
column did not equal the Total Account Value, which had been adjusted for the 
different exchange rate. This compromise by Microsoft, although misleading, was 
probably the simplest way to fix a tricky problem.
5. Please contact me if this explanation has confused you -- it isn't the 
easiest thing to describe.

John McIntyre 

Original issue reported on code.google.com by johnmcin...@dsl.pipex.com on 26 Mar 2011 at 6:10

[GoogleCodeExporter]

Hi John, first thanks for the kind words.

Yes, multi-currency is one of the area that need work. Part of the problem is 
that I am not using it so I don't have a lot of insight into what is going on.

We had some long discussion at this URL: 
http://microsoftmoneyoffline.wordpress.com/2010/02/12/java-app-to-update-quotes/
(search for string 'two wrongs will make it right' and the post at time 
'February 17, 2011 @ 1:15 pm')

To summarize:
  . Main cause: MM does not honor the currency setting per security in the generate OFX file

See if the note from this "issue" will help: 
http://code.google.com/p/hle-ofx-quotes/issues/detail?id=5&q=label%3ABuild_20110
226_001

Let me know if it works/not work for you. 

Best,

Original comment by hle...@gmail.com on 27 Mar 2011 at 3:35

• Changed state: Accepted

[GoogleCodeExporter]

See also: 
http://help.infinitekind.com/discussions/switching-to-moneydance-from-microsoft-
money/1536-multi-currency-ofx-support

Original comment by hle...@gmail.com on 21 Nov 2011 at 3:38