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