What baffles me is that this problem does not seem like it would be hard for
Microsoft to solve. For example, the report of "net worth over time"
calculates the value of all assets at any time at the latest exchange rate
only. How hard would it be to download a time series from some exchange rate
database and multiply each asset value by the exchage rate for the currency
in which it is denominated relative to base currency? By failing to do this,
reports like "net worth over time" become useless for anyone who owns assets
denominated in more than one currency: when the exchange rate fluctuates,
the reported value of my assets five years ago changes!!!

"Richard" wrote:

- quote -

"Richard" <rffuller[at]hotmail.com.nospam> wrote in message
news:0B508157-F8D6-4E70-9986-FE1AB49832BC[at]microsoft.com...

- quote -

I doubt it.
--
Chris Cowles
Gainesville, FL

Hi

I am evaluating the trial version of Money 2007 and it can do everything
that I want it to do with the exception of correctly tracking foreign stocks.

The problem is that of the calculation of Cost Basis (Book cost). I have a
number of stocks quoted on the London and European exchanges.

When I record a "Buy", money asks me for the exchange rate and correctly
calculates the Base Currency cost of the transaction. However, in the
Portfolio review, if the exchange rate then changes, the Pounds Sterling and
Euro stocks then show an incorrect Book Cost (both in local and base
currency) which appears to be based on the Current exchange rate, rather than
the "Booked" exchange rate that was entered when the stock was bought.

This is quite obviously wrong, as the Cost of the transaction should not
change over time. Because of this error, it means that all the Gain/Loss and
Return calculations are incorrect, making the portfolio manager and
investment valuation and performance reports unusable.

If I enter the same stock transactions in Quicken, their Portfolio manager
correctly reports the unrealized gain/loss. However, Quicken does not support
automatic updating of non-US stocks - catch 22 situation!!

As an aside, another really useful feature would be to be able to analyse
the gain/loss split by both price appreciation and exchange rate movement.

I notice that I am not the first person in this forum to raise this issue.
Does Microsoft have any plans to correct this error in the near future?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communities...t.public.money