Re: Canadian currency exchange

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

In Reply to: Re: Canadian currency exchange posted by Mark on March 15, 2004 at 20:49:50:

: : : : : : Hi Mark,

: : : : : : For quite some time I have been retrieving the Canadian currency exchange rate (Symbol ^CCD) using the Yahoo quote server and it has always retrieved it in the format .9999 however since the beginning of this month the format has changed to 99.99. Needless to say, this affects my U.S. investments when I convert them to Canadian currency. Has anything changed in this regard?

: : : : : : Thanx,
: : : : : : Sheldon

: : : : : Hi Sheldon,

: : : : : I assume you're using the Yahoo quote server? You can find the symbols
: : : : : for exchange rates here:

: : : : : http://finance.yahoo.com/m3?u

: : : : : For the one I believe you're looking for, you would use:

: : : : : CADUSD=X

: : : : : They have the conversions available in either direction. The value for
: : : : : CADUSD=X is 0.7457,and the value for USDCAD=X is 1.3411.

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

: : : : Mark:
: : : : I have the same problem, the exchange rates are now out by a factor of 100. In addition, the symbols used in Yahoo's convertor table don't seem to be available when I try to update. It seems like something has changed very recently.
: : : : Thanks,
: : : : Stew

: : : Hi Stew,

: : : I do see that the price for ^CCD is being reported as 75.62 currently. It
: : : sounds like for some reason Yahoo recently changed it from reporting as
: : : 0.7562 to 75.62. I'm not sure why or when, but since it is 75.62 you may
: : : want to change to the other symbol (CADUSD=X). I just tested this one,
: : : and it retrieves fine from the Yahoo server, with the price like 0.7562.

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

: : Hi Mark,
: : I've got the same problem as discussed here. (Price format changed on Feb 27th) I use the Yahoo-Historical server because I only get updates weekly. The symbol (CADUSD=X) does not work on this server. Do you know of another symbol for this server? If not, can 'Splits' some how be used to adjust the price format?

: : Thanks,
: : Clive

: Hi Clive,

: Thanks for pointing this out, I didn't realize these weren't available on
: the historical server. In this case, I'd recommend using the "File / File
: Operations / Scale Prices..." menu command. You'd want to do this with only
: the ^CCD investment open, and scale by 0.01.

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

Mark:

This Canadian $ change by Yahoo has got me all screwed up. I tried the operation you suggested above, but get very odd results. When I edit the ^CCD data, Open, High and Low values are given as, say 0.76, while the close is given as 1.32, the reciprocal. But that applied only to some blocks of data. And the Canadian stocks, when viewed in US $ still show a huge step when Yahoo switched to the new system.

When I download the CDN$ data from scratch, and apply your file operation, the same thing happens. What's the problem here? How can I get my Cnadian stocks to show sensible graphs again?

Hope you can help!

Jack

Replies:

• Re: Canadian currency exchange Mark 21:10:19 03/19/04 (7)
  • Re: Canadian currency exchange Jack 08:22:04 03/22/04 (6)
    • Re: Canadian currency exchange Jack 04:42:32 04/04/04 (5)
      • Re: Canadian currency exchange Mark 10:58:38 04/04/04 (4)
        • Re: Canadian currency exchange Jack 08:31:48 04/06/04 (3)
          • Re: Canadian currency exchange Mark 10:15:02 04/06/04 (2)
            • Re: Canadian currency exchange Jack 08:33:15 04/15/04 (1)
              • Re: Canadian currency exchange Mark 10:38:31 04/15/04 (0)