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.
: Mark Beiley
: Fund Manager for Windows 3.1x/95/98/NT
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...