Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Exchange Rates for reports

Questions about updating prices or transactions in Fund Manager

Postby Flijfi » Mon Feb 21, 2011 2:42 pm

Hi,

I am evaluating FM personal.
Impresive SW so far! :o

I have a set of accounts in 3 currencies (USD, BRL, EUR) and I intend to report in 2 currencies (BRL, USD).
I've set up my default currency as USD, and I defined the other 2 (as investments of a sub-portfolio: USDBRL=X & USDEUR=X).
I successfully retrieved NAV from the internet and I was able to import the historical NAV from OANDA (as per FAQ #17).

Here is my doubt:

For reporting purposes, I created a cash account with a couple of transactions of BRL 1000 for 2008 and 2010. (Off course, I do have a BRL/USD exchange rates for those dates).
I created a Portfolio Value Report for this investment (exchange Rate adjusted = ON).
I expected to see the value of this portfolio change over the time following the Exchange Rate changes, but it didn't happen it seems to stay constant using the last exchange rate.

Is this the expected behavior ?
Actually I track my investments adjusted by the event's exchange rate.

Thanks,

Flijfi
Flijfi
 
Posts: 24
Joined: Mon Feb 21, 2011 2:21 pm

Postby Mark » Mon Feb 21, 2011 2:46 pm

Hi Flijfi,

The exchange rate used for determining market value is the closing price recorded in your exchange rate investment on/before the date in question. If you haven't updated your exchange rate investment, then it will just use the last price in the exchange rate investment. Also, make sure you are assigning your exchange rate investments so they are used, under "Options / Currency Settings...". Also, if you haven't already seen it, we have a tutorial on tracking investments in multiple currencies:

http://www.fundmanagersoftware.com/tuto ... video.html
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11709
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Flijfi » Mon Feb 21, 2011 3:29 pm

Thanks Mark for your promptly reply.

I've changed so many times the setup that I missed the most basic of all, I've let the Currency setup fixed with a constant rate (what a shame!) :oops:

Now Portfolio Value report (converts OK for discrete dates), but graphic doesn't. Just a flat line.

Did I miss something else?

Regards,

Flijfi
Flijfi
 
Posts: 24
Joined: Mon Feb 21, 2011 2:21 pm

Postby Mark » Mon Feb 21, 2011 3:39 pm

Hi Flijfi,

Do you have closing prices recorded in your exchange rate investment for the time period of the graph? Look in the Data Register under the "Prices" data type at that exchange rate. Also look at the date range of the graph.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11709
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: Bing [Bot] and 12 guests

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