Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Wrong transaction exchange rate because of currency template

Questions about updating prices or transactions in Fund Manager

Postby Djobydjoba » Sat Aug 19, 2023 2:03 am

Hi Mark,

I have two currency templates, one in EUR (my main currency) and one in USD. Quite frequently I switch to the USD template to display the prices in USD, for market analysis.

Sometimes I forget that the USD template is loaded and it may happen that I enter new transactions with this wrong template. I've just noticed the problem thanks to a misplaced buy marker in an investment graph:

20230819-sam.10h33-01.png
20230819-sam.10h33-01.png (13.37 KiB) Viewed 971 times


NB: the investment is in EUR (not default) currency.

Opening the transaction, the Specific Exchange Rate is wrong. I have to fix it to 1 EUR = 1 €.

20230819-sam.10h38-01.png
20230819-sam.10h38-01.png (11.97 KiB) Viewed 971 times


I've seen the online help is quite clear in this regard:

When using transaction specific exchange rates you would generally not also utilize currency templates. Transaction specific exchange rates are recorded against only a single default currency, so changing that default currency would make the transaction specific exchange rates invalid. If you are only concerned about looking at items like market price/value, and aren't factoring in transaction costs, you could temporarily use currency templates, realizing that your transactions specific exchange rates will make the associated transaction cost calculations incorrect while the default currency has been changed from its original value.

but I would like to point out that when a new transaction is recorded, even for a investment in EUR with the EUR currency template loaded, the transaction specific exchange rates is always filled to "1 EUR = 1 €". So it is not a voluntary choice of mine to use the transaction specific exchange, it is always activated by default with any new transaction, as soon as the investment is not in the default currency.

I'm quite sure I've done the mistake elsewhere so I will check all my transactions.

My question is: could there be a mechanism to prevent this kind of error? An idea I have is if we could specify in the program what the default currency template is (ie. the template that has to be loaded each time we have to record a new transaction), the program could maybe alert us when the a new transaction is going to be recorded with an invalid exchange rate. I don't know if that makes sense. But maybe there could be a way to prevent this kind of error?
Djobydjoba
 
Posts: 790
Joined: Tue Mar 09, 2010 9:39 am

Postby Mark » Sun Aug 20, 2023 10:25 am

Hi Djobydjoba,

One item to note is when you're recording this transaction, if your currency template is set to USD, you should see the label on this option display as: X EUR = 1 USD instead of X EUR = 1 €.

Another point is that this option is defaulted to whether or not you used it last time. So, if the last time you recorded a buy, you leave the "Specify Exchange Rate to Default" un-checked, the next time it will initialize to un-checked. It isn't always activated by default, it is initialized based on whether you used it or not last time you added/edited a transaction.

I understand the issue you're bringing up. I'm hesitant to add a new option for a default currency template to address this though as it may be adding more confusion than the benefit it provides.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11577
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Djobydjoba » Sun Aug 20, 2023 11:52 am

this option is defaulted to whether or not you used it last time

I hadn't noticed that, good to know. With that info and the realization of the potential issue I'll be more attentive the next few times. So no, a new option doesn't seem necessary.

Thank you.
Djobydjoba
 
Posts: 790
Joined: Tue Mar 09, 2010 9:39 am


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 18 guests

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