FX

[ Message Board ] [ Archives ] [ Search ]

Posted by Robert A on October 05, 2007 at 22:08:56:

Hi Mark
I'm still using version 6.8 while waiting for a version of FM that will seamlessly import from Quicken, complete with effective treatment of Ameritrade's typical cash plus money market sweep transactions.

Today I did something I've been meaning to do for years. Instead of using pink sheet symbols and US dollars for my Canadian stocks, I used their TSX symbols, which downloads prices in Canadian dollars. I then set up a Canadian Dollar investment, and tied all my Canadian stocks to it. This investment (USDCAD=X) currently has only one price - today's. I checked "Exchange Rate Adjusted".

Every thing worked perfectly, i.e., the Canadian stocks' prices were downloaded in Canadian dollars and automatically converted to US dollars using the current exchange rate.

I was very pleased until I looked back and saw that the program had back-adjusted all the past prices according to today's exchange rate, including my purchase prices from many months ago. This renders my past purchase (and sales) prices inaccurate as the US dollar - Canadian dollar exchange rate has changed very dramatically over the past year. It also renders past performance data inaccurate.

Is there a work-around for this problem?

Replies:

• Re: FX Mark 10:00:29 10/06/07 (0)