Portfolio 2.0 cash tracking is inaccurate due to currency conversion
When handling a portfolio in GBP but logging a USD-based transaction, the "total cost" is shown at the current exchange rate, and that (variable) value is subtracted from the cash holdings.
But this means over time, the amount of cash in GBP can vary due to the fluctuating exchange rate, over-inflating the amount of cash in the portfolio.
Whilst displaying the current cost basis might be useful, for adjusting the cash holdings, I think it should be fixed in time at the point of purchase.
Example: create a GBP portfolio with £1000 and buy 1 AMD share at $182 on the 15th July. The exchange rate at the time was 1.29851 and the cost at the time was £140.16 (this value will never change). But after entering this, the cash holding is reduced to £862.26 (a difference of £137.74, not the original amount of £140.16 (the exchange rate as I write this is approx 1.3216 and, $182 / 1.3216 = $137.71 - the total cost value).
As the exchange rate rises in favour of the USB, this over-inflates the cash in the portfolio, though if the rate decreases since the purchace, it could push it negative.
Can this be fixed please?
Brian Ruthven
shared this idea
