Re: Currency change
[ Q2 00 - Q2 01 Archive ]
[ Current Message Board ]
[ Archives ]
[ Search ]
Posted by Agis on January 05, 2001 at 11:03:37:
In Reply to: Re: Currency change posted by Mark on January 04, 2001 at 18:23:22:
: : : : 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 : Hi Agis,
: There is no good way to convert currencies in the middle of an investment.
: You could use the currency method to handle this. What part did you get stuck
: on? The basic idea is that since the currency is changing in the middle
: you assign one of your currencies to handle all investments under this situation.
: You would create/assign an exchange rate investment (Options/Currency Settings...".
: This exchange rate will have one value while the investments were under
: the old currency and another value while they are under the new currency. : Thanks,
: Mark
: --
: Mark Beiley
:
: Fund Manager for Windows 3.1x/95/98/NT
:
: Hi Mark, Here's what I've done:
I've created an exchange investment (EURO), associated it with a currency, and set the default currency to EURO.
All historical data displays fine (i.e. the conversion to EURO works as expected), but when I enter a new closing price (in EURO, of course), FM understands it as it is in Drachmas (e.g. when I enter 340.75 [the exchange rate], FM interprets it as 1 EURO). Is there a way to also enter a currency, instead of only the value? I can't understand what I'm doing wrong... Thanks you,
Agis
Replies:
|