|
#2
| |||
| |||
| It looks like the designers did not give any thought to this issue at all. I have the same issue, but I noticed that in some cases it calculates the revenue based on historical exchange rates, and in other cases it does it in the original currency without converting. The last case is probably when the transaction was downloaded automatically, and no exchange rate was recorded with it. I even managed to "ruin" this cases by re-entering the transaction manually. Here is how Microsoft should have designed it: - If the transaction/investment is in a foreign currency, but the account is in local currency, than all transactions should be calculated at the local currency by using the historical exchange rate. - If the transaction/investment is in foreign currency, and the account is in foreign currency than all transactions should be shown and calculated in their original foreign currency values. Only when preparing the tax report, and assuming that the tax report is in the local currency, each transaction should be presented at the local currency value based on the historic exchange rate. If the tax report is in foreign currency (probably done for paying taxed abroad) than – even then the values should be left at the original foreign currency values. I hope someone from the Microsoft Money development team reads this, and implements my suggestion. "Fads": - quote - > I am using Money 2005 (US Version). I am using the base currency as the US > Dollar. I have 2 investment accounts which are USD & Euro. > I have several transaction in both accounts that include Stock, Mutual > Funds, & Other investments. > The problem is reporting the average cost of the Euro denominated > investments. When i recorded a Euro stock i have also recorded the Euro > Exchange Rate at that time ( as an example, in december 2003 Buy 100 shares > at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that the > average cost of this investment is 9.24 Euro, and not 10 Euro.... It seems > that the Portfolio manager is also considering the gain in the exchange rate > (The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average cost... > The problem is that i want to keep the exchange rate profit/loss seperate... > Each of the investment account is independent.... i tried to fix it in the > Portfolio Manager setting (extend the value of the transaction in the > investment currency) but it does not make any difference... > Is there a way to fix this? > Thanx for any suggestion or help... |
|
#1
| |||
| |||
| I haven't thought this out, but it seems to me the only workaround would be keep your Euro denominated investments also in dollars, without any conversion (i.e. pretend they are in dollars, not Euros and ?1= $1). This should work for all calculations internal to the investments. For your net worth reports (in real $), you could exclude these accounts and include a separate asset account that you manually set to the real dollar value of your Euro investments each time you run your Net worth report. Or you could keep two parallel accounts (one with the real conversion value and one with fixed 1:1 conversion) and selectively use one or the other for the relevant reports. [Note, if this makes no sense, please refer to the first five words of this post]. -- Peace, BobJ "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in message news:eIaLctkLGHA.1532[at]TK2MSFTNGP12.phx.gbl... - quote - > I haven't played with this, but I suspect there is no easy way around what > you are seeing. I suspect that what you are seeing is a result of it > converting the individual transactions to the default currency (dollars) > and then converting the average dollar cost back to Euros to display it. > Money's model for multi-currency support appears to be very simplistic. > "Fads" <Fads[at]discussions.microsoft.com> wrote in message > news:3A5CF7E5-6826-4B42-9607-37944D38162A[at]microsoft.com... > > I am using Money 2005 (US Version). I am using the base currency as the > > US > > Dollar. I have 2 investment accounts which are USD & Euro. > > > I have several transaction in both accounts that include Stock, Mutual > > Funds, & Other investments. > > > The problem is reporting the average cost of the Euro denominated > > investments. When i recorded a Euro stock i have also recorded the Euro > > Exchange Rate at that time ( as an example, in december 2003 Buy 100 > > shares > > at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that > > the > > average cost of this investment is 9.24 Euro, and not 10 Euro.... It > > seems > > that the Portfolio manager is also considering the gain in the exchange > > rate > > (The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average > > cost... > > > The problem is that i want to keep the exchange rate profit/loss > > seperate... > > Each of the investment account is independent.... i tried to fix it in > > the > > Portfolio Manager setting (extend the value of the transaction in the > > investment currency) but it does not make any difference... > > > Is there a way to fix this? |
| | |||
| |||
| I haven't played with this, but I suspect there is no easy way around what you are seeing. I suspect that what you are seeing is a result of it converting the individual transactions to the default currency (dollars) and then converting the average dollar cost back to Euros to display it. Money's model for multi-currency support appears to be very simplistic. "Fads" <Fads[at]discussions.microsoft.com> wrote in message news:3A5CF7E5-6826-4B42-9607-37944D38162A[at]microsoft.com... - quote - > I am using Money 2005 (US Version). I am using the base currency as the US > Dollar. I have 2 investment accounts which are USD & Euro. > I have several transaction in both accounts that include Stock, Mutual > Funds, & Other investments. > The problem is reporting the average cost of the Euro denominated > investments. When i recorded a Euro stock i have also recorded the Euro > Exchange Rate at that time ( as an example, in december 2003 Buy 100 > shares > at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that > the > average cost of this investment is 9.24 Euro, and not 10 Euro.... It seems > that the Portfolio manager is also considering the gain in the exchange > rate > (The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average > cost... > The problem is that i want to keep the exchange rate profit/loss > seperate... > Each of the investment account is independent.... i tried to fix it in the > Portfolio Manager setting (extend the value of the transaction in the > investment currency) but it does not make any difference... > Is there a way to fix this? |
|
#-1
| |||
| |||
| I am using Money 2005 (US Version). I am using the base currency as the US Dollar. I have 2 investment accounts which are USD & Euro. I have several transaction in both accounts that include Stock, Mutual Funds, & Other investments. The problem is reporting the average cost of the Euro denominated investments. When i recorded a Euro stock i have also recorded the Euro Exchange Rate at that time ( as an example, in december 2003 Buy 100 shares at Euro 10 - exchange rate 1.1)... The pertfolio manager indicates that the average cost of this investment is 9.24 Euro, and not 10 Euro.... It seems that the Portfolio manager is also considering the gain in the exchange rate (The euro was at 1.1 in 2003 and is 1.19 now) as part pf the average cost... The problem is that i want to keep the exchange rate profit/loss seperate... Each of the investment account is independent.... i tried to fix it in the Portfolio Manager setting (extend the value of the transaction in the investment currency) but it does not make any difference... Is there a way to fix this? Thanx for any suggestion or help... |
| Tags |
| accounts, average, cost, investments, multicurrency |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Multi-Currency Investment Accounts! Fads: I am using Money 2005 (US Version). I am using the base currency as the US Dollar. I have 2 investment accounts which are USD & Euro. I have... | Microsoft Money | 1 | 02-10-2006 02:27 AM | |
| weighted average cost Thomas: My home page shows that one of my investments is 'the poorest performing investment in your portfolio. It's down 84.88% from a weighted average... | Microsoft Money | 2 | 01-16-2004 12:58 PM | |
| weighted cost average Brian Jusseaume: Good evening all, Question concerning Money's investment reports. I used the add shares function to enter some older investments that I had. I... | Microsoft Money | 2 | 10-05-2003 02:10 AM | |
| Thread Tools | |
| Display Modes | |
| |