Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Problem with currencies (base currency other than USD)

Questions about updating prices or transactions in Fund Manager

Postby possing » Sat Sep 20, 2008 6:53 am

Dear Fund Manager Team,

I'm currently testing a trial of fund manager and I find the program among the best that I have seen so far!!

However, I have encountered one problem, when using investments in other currencies. My base currency is Danske Kroner (DKK).

I have set up USD and GBP as alternative currencies ( I download /DKKUSD and DKKGBP from MSN historical) to transform foreign denominated investments into DKK. Everything works out fine until I close down Fund Manager and restarts the program.

When I restart the program, when 'View Exchange Rate Adjusted' option is turned on, then the program changes the buy/sell prices of the entered investments and the actual price of the asset.

I have tried to figure out, what the program does. It seems to me as if the program reads the (original) GBP price as if it is actually a DKK investment. Then when it opens the program it interchange the DKK (which is actually in GBP) into GBP.

Example:

Asset: Global Oceanic Carriers (GOC.L)

Original input:
Price GBP at May 02, 2006: 59 GBP
GBP/DKK at May 02, 2006: 0.092 (i.e. 0.092 DKK = 1 GBP)
Price DKK at May 02 2006: 641.30 DKK

Now turn on exchange rate adjustment, save all investments, save all portforlios and restarts the program. The data has now changed to

Price GBP at May 02, 2006: 5.42 GBP (=59*0.092)
Price DKK at May 02, 2006: 59 DKK

Further the programs has changed the purchase price in GBP to 5.42, but it has not changed the recorded transaction on my money account. Here the original price 59GBP is still applied. Hence, the cost base of my portifolio is messed up.

How do I solve this problem? Can I change some setting somewhere to avoid this?

Thanks in advance.

Best Possing
possing
 
Posts: 2
Joined: Sat Sep 20, 2008 6:30 am

Postby Mark » Tue Sep 23, 2008 10:58 am

Hi possing,

Is everything okay before you exit and re-start? Does it make a difference if you save your portfolio with "View / Exchange Rate Adjusted" on or off? This kind of sounds like a bug. I tried entering everything as you've described here, and couldn't reproduce the problem. After re-starting the price of GOC.L correctly toggles between 59 and 641.30, depending on the state of "View / Exchange Rate Adjusted".

If you don't mind sharing your data files, you can do a "File / Backup..." and email me this file, along with instructions on how to reproduce the problem, like where you're looking in the program at the price. I'll try to reproduce the problem, or see what isn't as expected.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11693
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby possing » Wed Sep 24, 2008 3:46 am

Hi Mark,

Thanks a lot for your reply. I found out that the problem depends if the option 'View exchange rate adjusted' is on or off when I save the portfolio/investment file. When the option is on then the problem turns up when I re-open the saved file. That is both on restart (when the programs make an auto save) and on manual saving.

I will send you my portfolio file. If you can send your mail adress to peter.possing.andersen@gmail.com then I will return the file to you together with instructions how to reproduce the problem.

Thank a lot in advance.

/Possing
possing
 
Posts: 2
Joined: Sat Sep 20, 2008 6:30 am

Postby Mark » Wed Sep 24, 2008 8:26 am

Hi Possing,

Thanks for your help. I've just sent you an email, so you can reply to that with the backup file.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11693
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 16 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2025 Beiley Software, Inc. All rights reserved.