Re: Currency change

[ Q2 00 - Q2 01 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Currency change posted by Mark on January 03, 2001 at 19:30:07:

: : Hi,

: : Prices in the Greek stock market have changed (as of today) from Drachmas to Euros. Is there a way to convert all historical data, using a fixed exchange rate, so that I can keep updating the investment files and not lose the history?

: : Thanks

: Hi Agis,
: Do you have the same number of shares, or did it scale? If it scaled with
: the ratio of the price, you can use a split. Otherwise, you could use
: one of the currency settings to adjust your historical data versus new
: prices. The exchange rate would be different as of today. You would need
: to create/assign an exchange rate investment. The other option is to export
: your prices, multiply them in Excel or something, and then re-import them.

: Thanks,
: Mark
: --
: Mark Beiley
:
: Fund Manager for Windows 3.1x/95/98/NT
:
:

Thanks Mark,

Using a spreadsheet is almost impossible, as I have about 350 investments, and cannot do it manually.
I tried to follow your aother aporach, but got stuck
What I want to do is this: Convert all investments (including the cash account) to EUR and start updating prices in EUR. Is there an easier way?

Thank you,
Agis

Replies:

• Re: Currency change Mark 18:23:22 01/04/01 (6)
  • Re: Currency change Agis 11:03:37 01/05/01 (5)
    • Re: Currency change - one last question Agis 11:22:13 01/05/01 (1)
      • Re: Currency change - one last question Mark 20:21:48 01/05/01 (0)
    • Re: Currency change Agis 11:13:56 01/05/01 (2)
      • Re: Currency change Mark 21:44:06 01/05/01 (1)
        • Re: Currency change Mark 21:52:51 01/06/01 (0)