Inability to correct GBP value for Euro priced shares

Fred Bone Fred.Bone at dial.pipex.com
Fri Jun 9 06:29:56 EDT 2017


On 8 June 2017 at 18:41, Eric Coates said:

[...]
> But your comment has raised another observation: I updated (on 7th June)
> my collected share values and AIR.PA had risen to €73.95 BUT the value
> of the 89 shares is still reported as £3989 (in the "Present GBP" column
> of the account listing). (The change in the value of holdings in GBP
> denominated shares did change in line with the updated prices.)
> 
> In fact, an examination of the real value of the Airbus shares 
> (expressed in Euros) ie €73.03 and the implied present value in GBP
> £3989/89 ie £44.82 implies an exchange rate of €1 = £1.62 which has
> never (I believe) been the case. It looks as if gnuCash is just making
> things up.
> 
> Or, more likely, I'm totally misunderstanding what's happening.

Could be a problem with EUR-to-GBP.

I have some Euro-denominated shares (Eurotunnel CDIs) and I get a 
valuation consistent with the entries in the Pricedb. I clean the thing 
out periodically ("Remove old") so there's only one price-in-EUR to deal 
with, and it is evidently using the latest EUR-to-GBP entry (since number 
of shares * price-in-EUR * EUR-price-in GBP, rounded, gives the displayed 
value, and earlier EUR-to-GBP values aren't close enough).

So:
1. How many entries do you have in Pricedb for AIR.PA?
2. How many Currency entries for EUR?
3. What is the product of the share quantity and the latest entries of 
the above two?



More information about the gnucash-user mailing list