After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 653127 - Advanced portfolio basis currency conversion is using latest exchange rates
Advanced portfolio basis currency conversion is using latest exchange rates
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Reports
2.4.x
Other Linux
: Normal major
: ---
Assigned To: gnucash-reports-maint
gnucash-reports-maint
Depends on:
Blocks:
 
 
Reported: 2011-06-21 20:38 UTC by guitoun
Modified: 2018-06-29 22:59 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description guitoun 2011-06-21 20:38:54 UTC 
Hi there,
It looks like the advanced portfolio report is using the latest exchange rate for the basis instead of the exchange rate at the time of the transaction.
If I buy some shares in a USD account and included them in an advanced report in EURO, the basis price will be converted from the money-in price in USD to EURO with today's exchange rate value instead of the exchange rate at the time the transaction occured.
Thanks.
Comment 1 Carsten Rinke 2013-04-24 09:49:55 UTC 
I see this as a valid comment.

My understanding is that the basis indicates the value the account needs to reach to achieve profit when being sold.

Given following scenario:
1 unit is bought at a time when 1 USD = 1 EUR
Some time later the price in USD is unchanged for the item, but the currency exchange rate has changed to 1 USD = 0.6 EUR.
If the item would be sold at that time, it would be sold in USD and the account would return a loss of 0.4 EUR (assuming no fees or whatsoever), so the unrealized gain should indicate -0.4 EUR, but the basis of 1 EUR would still be valid.

I checked and this behaviour still applies in GnuCash 2.5.0 on Ubuntu 12.04.

Therefore, I suggest to move this bug to status NEW.
Comment 2 Mike Alexander 2014-01-20 06:42:09 UTC 
I think this has been fixed by the changes to the Advanced Portfolio report that I've checked in today.  If you disagree, let me know.  These changes will be in the next release or you can get the new version at http://svn.gnucash.org/trac/browser/gnucash/trunk/src/report/standard-reports/advanced-portfolio.scm now.
Comment 3 John Ralls 2017-09-24 22:48:43 UTC 
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 4 John Ralls 2018-06-29 22:59:25 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=653127. Please update any external references or bookmarks.