Re: Showing Canadian Investments in US$

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Showing Canadian Investments in US$ posted by Mark on May 04, 2003 at 10:48:29:

: : I have a few Canadian stocks mixed in with my US stocks. I've set up a dummy investment that lists the Canadian$:US$ exchange rate, as suggested in the Help section. Both ^CCD and ^XCD seem to work with Yahoo. I'm using US$ as my default currency, so wish to express my valuations in that currency.

: : However, I find that the when I select the "Exhange Rate Adjusted" view, Fund Manager divides by the exchange rate instead of multiplying, so I get more rather than fewer US dollars for my Canadian dollars (dinosaurs ruled the earth when that last happened!)

: : I've tried switching between the currency selected for my dummy investment (i.e. US$ and C$), but this seems to make no difference.

: : Is there any way of using the reciprocal of the exchange rate, or is there a ^??? symbol in Yahoo that will give me the C$:US$ rather than vice versa? (I've searched Yahoo for 30 minutes, but to no avail.)

: Hi Jack,

: I don't know the symbol for the reciprocal of the exchange rate either, but
: you can assign a property to your ^CCD investment, so it will have its price
: inverted when importing. See "Investment Properties.../Other/Invert Price
: When Updating".

: Thanks,
: Mark
: --
: Mark Beiley
:
: Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
:

Hi Mark:

Thanks for the advice - once again worked like a dream!

Perhaps in the next version of FM you might think about isolating the currency exchange facility from the investments portion of the program. The mechanism is already in place, is sophisticated, and works perfectly. It's just that the "fiddle" of allocating a zero-share investment to the exchange rate lacks the polish shown by the rest of your program.

It shouldn't be too difficult to include that as a separate routine.

Thanks again,

Jack

Replies: