Displaying Cost Basis in Default Currency

[mclouter]

There appears to be no option to display the Cost Basis in the default currency when the investment was purchased in a non-default currency, e.g. by recording the initial exchange rate in the New Investment dialogue. Is this correct?

[Mark]

Hi mclouter,

You can do this. Just turn on "View / Exchange Rate Adjusted", and all values will be shown in the default currency, including any cost basis figures. You do need to make sure you've set up all your currencies/exchange rates as you're using them under "Options / Currency Settings...". In case you haven't seen it, there is a tutorial on setting this up here:

https://www.fundmanagersoftware.com/tut ... video.html

[mclouter]

Mark:

Thanks for the response. I have actually set things up to do as the video describes and the current price/value columns are displayed correctly when I switch back and forth, but the Cost column is only correct when displayed in the native currency. It seems that the current exchange rate is being used to display the default currency number for the Cost, which is not useful. Are you suggesting that it is possible to automatically retrieve the exchange rate at the time of the initial purchase? (Given the recent tanking of the Canadian dollar the difference can be quite dramatic!)

[Mark]

Hi mclouter,

It sounds like you need to get historical pricing for your exchange rate investment. The cost figure will use the exchange rate as of the date of your purchase(s). If you assigned a transaction specific exchange rate it will use that, otherwise it will use the global exchange rate as of the transaction date. If you didn't use a transaction specific exchange rate and don't have a global exchange rate recorded on the transaction date it will interpolate one from the nearest recorded global exchange rate. I'm wondering if you only have 1 historical exchange rate recorded (for the current date only), so all exchanges are being done with this one rate?

Look at your exchange rate investment (the one you have assigned under "Options / Currency Settings...") in the Data Register using the Data Type of "Prices". These are all your daily global exchange rates. See if you have exchange rates for the date(s) of your purchase(s). If you don't have historical exchange rates, you can either manually enter some, import them from OANDA, or retrieve using Bloomberg Historical. For help on this, see this FAQ:

https://www.fundmanagersoftware.com/faq ... wnload.php

[mclouter]

Many thanks.
I've manually entered the exchange rates for each Buy transaction and everything is fine.