Re: Inability to correct GBP value for Euro priced shares
> On Jun 10, 2017, at 3:19 PM, Fred Bone wrote: > > On 10 June 2017 at 14:52, John Ralls said: > >> >>> On Jun 10, 2017, at 10:35 AM, Fred Bone >>> wrote: > [...] >>> I can verify that an old price in GBP trumps a new one in EUR. This >>> *has* to be a bug, surely? >>> >>> I will log a bug on Bugzilla shortly. >> >> It might be a bug, but it's so minor and obscure that we're not even going >> to consider it. I've made a detailed response on the bug report [1], but >> the executive summary is that securities priced in multiple currencies >> don't exist. > > True, but this misses the point. The OP had accidentally created a > Pricedb entry in the base currency that (had it not been eliminated) > would forever poison the valuation. I doubt whether he was the first or > last to do this. One use-case I can think of is when the user wishes to > reflect a valuation at a particular point in time as supplied by the > broker. It seems illogical that if this happens to be in the book > currency it will override any subsequent ones, while if in the > commodity's currency the reverse is true. Right. The OP made a mistake. There is no way GnuCash can anticipate, correct, or flag every possible mistake a user might make, and frankly even trying would be a misuse of very scarce developer time. Commodities don't have currencies. Accounts have a commodity which might be a currency. Accounts are priced to their parent accounts, and GnuCash can do that only one price/exchange rate at a time. > > Your claim (in the response) that an intermediate account in the > commodity's currency would cure the problem >> In order for GnuCash to correctly handle stock investments in currencies >> other than the book currency they need to be subaccounts of an account >> denominated in that currency, > does not reflect what I find. I omitted tne intermediate in my sample > purely because it changes nothing; my own books do include such an > intermediate and I can readily reproduce the OP's problem. > I wrote: > Doing that without changing anything else will allow GnuCash to display the > correct value for investments (EUR), but the rollup to Investments will still > be wrong as long as that bogus price for GET.PA is in the pricedb. That's exactly what I observed: The value on the Accounts page was correct for the intermediate account (Investments EUR) but not for the rollup to GBP (Investments). Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
On 10 June 2017 at 14:52, John Ralls said: > > > On Jun 10, 2017, at 10:35 AM, Fred Bone > > wrote: [...] > > I can verify that an old price in GBP trumps a new one in EUR. This > > *has* to be a bug, surely? > > > > I will log a bug on Bugzilla shortly. > > It might be a bug, but it's so minor and obscure that we're not even going > to consider it. I've made a detailed response on the bug report [1], but > the executive summary is that securities priced in multiple currencies > don't exist. True, but this misses the point. The OP had accidentally created a Pricedb entry in the base currency that (had it not been eliminated) would forever poison the valuation. I doubt whether he was the first or last to do this. One use-case I can think of is when the user wishes to reflect a valuation at a particular point in time as supplied by the broker. It seems illogical that if this happens to be in the book currency it will override any subsequent ones, while if in the commodity's currency the reverse is true. Your claim (in the response) that an intermediate account in the commodity's currency would cure the problem > In order for GnuCash to correctly handle stock investments in currencies > other than the book currency they need to be subaccounts of an account > denominated in that currency, does not reflect what I find. I omitted tne intermediate in my sample purely because it changes nothing; my own books do include such an intermediate and I can readily reproduce the OP's problem. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
> On Jun 10, 2017, at 10:35 AM, Fred Bone wrote: > > On 10 June 2017 at 16:47, Eric Coates said: > > [...] >> At some point, somehow I had managed to enter a price for Airbus shares in >> GBPs (I've no idea how; when adding a price manually the price is >> automatically set in Euros, I must have worked extra hard to make this >> mistake!). I removed just that one price and everything works as expected. >> >> My apologies to Fred and Maf for wasting their time. And thanks for the >> support. Without that I suspect I would not have kept investigating. I now >> know a lot more about organising accounts, buying shares in "foreign" >> currencies and pricing. > > No apology needed, in my direction at least. > > I can verify that an old price in GBP trumps a new one in EUR. This *has* > to be a bug, surely? > > I will log a bug on Bugzilla shortly. It might be a bug, but it's so minor and obscure that we're not even going to consider it. I've made a detailed response on the bug report [1], but the executive summary is that securities priced in multiple currencies don't exist. Shares in a company may trade separately in multiple countries in different currencies (Royal Dutch Shell comes to mind, having class A shares that trade in EUR in Frankfurt and class B shares trading in GBP in London), but one can't buy e.g. LSE shares for GBP and then sell those same shares on Euronext for EUR. Your broker might be willing to exchange them for you if they happen to make a market in both, but the fee is likely to exceed any arbitrage gain you might have made. GnuCash's treatment of currencies is different; ISO-4217 and GnuCash recognize precious metals as currency because they *are* fungible across currencies. Beware, though: That's actual lumps of metal, not futures or units of funds or partnerships holding metal. The latter are securities and trade in only one currency. Regards, John Ralls [1] https://bugzilla.gnome.org/show_bug.cgi?id=783636 ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
On 10 June 2017 at 16:47, Eric Coates said: [...] > At some point, somehow I had managed to enter a price for Airbus shares in > GBPs (I've no idea how; when adding a price manually the price is > automatically set in Euros, I must have worked extra hard to make this > mistake!). I removed just that one price and everything works as expected. > > My apologies to Fred and Maf for wasting their time. And thanks for the > support. Without that I suspect I would not have kept investigating. I now > know a lot more about organising accounts, buying shares in "foreign" > currencies and pricing. No apology needed, in my direction at least. I can verify that an old price in GBP trumps a new one in EUR. This *has* to be a bug, surely? I will log a bug on Bugzilla shortly. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
This is by way of a sign off note on this issue. Based on (my understanding of) Fred Bone's suggestion that it may be old prices that were causing the problem I deleted all the old prices in the pricing database and, as already noted, the problem went away - ie I was getting a correct current valuation of my Airbus holdings. However, still wondering if it may be the existence of some manually entered prices was causing the problem I reverted to the original accounts and started further investigations. And discovered it WAS a manually entered price that was causing the problem. It was me what had screwed up! At some point, somehow I had managed to enter a price for Airbus shares in GBPs (I've no idea how; when adding a price manually the price is automatically set in Euros, I must have worked extra hard to make this mistake!). I removed just that one price and everything works as expected. My apologies to Fred and Maf for wasting their time. And thanks for the support. Without that I suspect I would not have kept investigating. I now know a lot more about organising accounts, buying shares in "foreign" currencies and pricing. So, sorry and thanks guys. (And if Maf is a lady, a further apology.) ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
On 9 June 2017 at 12:54, Eric Coates said: > Fred > > In my original post I included the following "89(the number of > shares)*€73.07(the value of each share)*0.87(the Euro to GBP exchange > rate) ie £5658" and compared that with the value £3989 as reported in > the account listing. At that time I had "many" values in the price > database for both the Euro/pound and AIR.PA valuations. > > I have just deleted all old values in both for Euro/pound and AIR.PA and > the valuation in the account listing changed - and is consistent with a > manual calculation of the value. > > Problem solved! Well done, that man! > > But other questions arise: > > (A) Why does the existence old prices stop gnuCash from using the newest > price? Is there any connection with the fact that both Euro/pound and > AIR.PA had manually entered values? I doesn't in my case. I have about 20 old values for EUR and it's definitely using the latest - if I add another one the valuation changes. Most of them are "user:xfer-dialog" and only the latest is "user:price-editor". And I now have two "Finance::Quote" entries for GET.PA and it's using the later one of those. I just added (manually) another GET.PA entry with a silly price and yes, the value was updated to match. Adding another one dated 2012 made no difference. So I have no idea where your discrepancy came from, sorry. Can you see a EUR entry that matches the implied exchange rate? > (B) It's not clear from my original post but my "real" version of > gnuCash has a different structure from the version I described. (I made > them so that the reported structure was closer to "best practice" as I > understood it.) Is there a connection between your solution and the > changes I made. I take it you are referring to the account hierarchy. I can't think why that would affect the value shown in the Accounts tab for a single entry. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
Fred
In my original post I included the following "89(the number of
shares)*€73.07(the value of each share)*0.87(the Euro to GBP exchange
rate) ie £5658" and compared that with the value £3989 as reported in
the account listing. At that time I had "many" values in the price
database for both the Euro/pound and AIR.PA valuations.
I have just deleted all old values in both for Euro/pound and AIR.PA and
the valuation in the account listing changed - and is consistent with a
manual calculation of the value.
Problem solved! Well done, that man!
But other questions arise:
(A) Why does the existence old prices stop gnuCash from using the newest
price? Is there any connection with the fact that both Euro/pound and
AIR.PA had manually entered values?
(B) It's not clear from my original post but my "real" version of
gnuCash has a different structure from the version I described. (I made
them so that the reported structure was closer to "best practice" as I
understood it.) Is there a connection between your solution and the
changes I made.
(C) Deleting the old values removes a (sometimes useful) resource. It's
a shame to have to lose it
(D) Should I care if I have a working solution?
I will now go back to my real accounts and using the ideas gathered so
far try to come up with a simpler structure than I've currently got.
I'll be keeping my fingers crossed all the time!
Eric
On 09/06/17 11:29, Fred Bone wrote:
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?
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
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?
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
Morning Eric, Fairly sure I copied the list too, am doing so here so that the thread makes it to the archives there. As I said, I'm at a loss to explain what you are seeing. If the price DB has sensible numbers, I don't know why the specific share account would be so far off. I haven't done much more than dabble with share accounts, maybe someone else who knows more might be able to jump into the thread in due course. Good luck fighting it, especially given this morning's fluctuating exchange rates! Maf. On Thursday, 8 June 2017 23:00:22 BST Eric Coates wrote: > Hi Maf > > It looks as if you sent the note below to just me so I reply to "just > you"! If I misunderstand (a) my apologies and (b) I'll repost to the > mailing list. > > I've only just joined the gnuCash mailing list system so I'm not too > sure of the exact protocols. > > There's no need to apologise, I've made enough daft mistakes in my life > to accept that comments (possibly) correcting me are to be valued. > > Warning: Beware British humour ahead. And spelling! > > Re: Your comment "If you are sure you're getting prices for AIR.PA then > I'm at a loss." > > I am sure - but only to the extent that the gnuCash Price Editor update > function is telling me the truth. But sometimes you have to trust > someone/thing! > > At 2228 London time (you'll have to work out your own time differential) > on 8th June (2017 just 'cos a pedant!) gnuCash reports that €1 is > £0.879500 and AIR.PA is €73.7500; quick searches on Google (a few > minutes later) show £0.88 and €73.75 respectively. So, perhaps, gnuCash > tells the truth - at least this time. > > Take care > > Eric > > PS: I have done quite a few investigations of my situation using > "generations" of my accounts from 31st May (each just making a "simple" > change to the previous generation). The version I reported on is > Generation 3; tomorrow I intend to create the next generation and see > what happen if (somehow) I can get the Airbus dividends entered into the > accounts in Euros and transfer the sums to pound denominated accounts > (using realistic exchange rates to avoid any possible problems in using > a 1:1 rate). If I succeed and there is a change in behaviour I'll report > via the mailing list. Perhaps I should report even if there is no > change, at least it'll close down another avenue of enquiry. > > On 08/06/17 21:02, Maf. King wrote: > > Hi Eric, > > > > Sorry for being off the mark. It happened to me a while back that I was > > getting a price for a symbol in USD not GBP because I'd missed the ".L" > > for a London share - it seemed to me to be too much of a co-incidence > > that when gnc- fq-dump looked up AIR (not AIR.PA) I got a USD figure that > > could be munged close to your observed result. > > > > If you are sure you're getting prices for AIR.PA then I'm at a loss. > > > > what does the GC price editor give as the most recent values for the > > AIR.PA & EUR/GBP prices? > > > > Maf. -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Inability to correct GBP value for Euro priced shares
Hi Eric, Sorry for being off the mark. It happened to me a while back that I was getting a price for a symbol in USD not GBP because I'd missed the ".L" for a London share - it seemed to me to be too much of a co-incidence that when gnc- fq-dump looked up AIR (not AIR.PA) I got a USD figure that could be munged close to your observed result. If you are sure you're getting prices for AIR.PA then I'm at a loss. what does the GC price editor give as the most recent values for the AIR.PA & EUR/GBP prices? Maf. On Thursday, 8 June 2017 18:41:10 BST you wrote: > Maf > > Thanks for taking the time. > > Airbus Group is Air.PA and it is that stock whose value I "collect". > > The difference between the €73.07 I quoted and "your" €73.50 is > (probably) because the price I collected was from 31st May. I "froze" my > accounts at that time to allow (some) certainty in my investigations. > > 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. > > Eric > > On 08/06/17 15:04, Maf. King wrote: > > Hi Eric, > > > > Are you sure you're getting the correct price for the shares? > > > > There's a stock called AIR which is (presently) USD 34.64, and given the > > current $/£ rate makes 89 shares worth around £4k. > > > > You may be after the stock AIR.PA, showing right now as €73.50 > > > > > > gnc-fq-dump yahoo_europe AIR.PA > > > > Finance::Quote fields Gnucash uses: > > symbol: AIR.PA <=== required > > > >date: 06/08/2017 <=== recommended > > > >currency: EUR <=== required > > > >last: 73.50<=\ > > > > nav: <=== one of these > > > > price: 73.50<=/ > > > >timezone: <=== optional > > > > HTH, > > Maf. > > > > On Thursday, 8 June 2017 14:36:07 BST Eric Coates wrote: > >> 8th June 2017 > >> > >> I’m having trouble with getting a valuation (in pounds sterling – > >> hereafter GBP – I am based in the UK) for a share I own that is priced > >> in Euros. > >> > >> To bore you with the details my original account listing was of this > >> form: > >> > >> Assets > >> > >> >My Assets > >> > > >> >>My Portfolio > >> >> > >> >>>My Cash > >> >>> > >> >>>My Shares > >> >>> > >> Airbus Group > >> > >> Standard GBP denominated shares > >> > >> etc etc > >> > >> At this point everything except “Airbus Group” was denominated in GBPs, > >> Airbus Group was denominated in Euros. > >> > >> I noticed the problem when I realised that value of the Airbus Group > >> shares (in the column headed "Present(GBP)"was given as £3989 but the > >> real value should be 89(the number of shares)*€73.07(the value of each > >> share)*0.87(the Euro to GBP exchange rate) ie £5658. (All the numbers > >> are rounded.) > >> > >> Using the information I found during various web searches (insofar as I > >> understood it all) it seemed the problem might be that the account “My > >> Shares” was denominated in GBP but “Airbus Group” is denominated in > >> Euros. I modified the account structure to the following form: > >> > >> Assets > >> > >> >My Assets > >> > > >> >>My Portfolio > >> >> > >> >>>My Cash > >> >>> > >> Cash Euros > >> > >> Cash Pounds > >> >>> > >> >>>My Eurex Shares > >> >>> > >> Airbus Group > >> >>> > >> >>>My LSE Shares > >> >>> > >> Standard GBP denominated shares > >> > >> etc etc > >> > >> With “Cash Euros”, “My Eurex Shares” and “Airbus Group” denominated in > >> Euros, everything else is denominated in GBPs. > >> > >> I transferred some funds from “Cash Pounds” to “Cash Euros”; the > >> original “Airbus Group” was deleted and a new account was reconstituted > >> (there were very few entries) with the purchase made from “Cash Euros”. > >> > >> The result was that the GBP value of the Airbus shares was (still) shown > >> as £3989. > >> > >> More web searches revealed nothing that I recognised as of relevance. > >> > >> The only thoughts that I have that may be significant are: > >> (A) “Cash Euros” and “Airbus Group”, although denominated in Euros, are > >> deep(ish) in a tree denominated in GBPs and, in particular, “Cash Euros” > >> is a sub-account of “My Cash” which is de
Re: Inability to correct GBP value for Euro priced shares
Maf Thanks for taking the time. Airbus Group is Air.PA and it is that stock whose value I "collect". The difference between the €73.07 I quoted and "your" €73.50 is (probably) because the price I collected was from 31st May. I "froze" my accounts at that time to allow (some) certainty in my investigations. 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. Eric On 08/06/17 15:04, Maf. King wrote: Hi Eric, Are you sure you're getting the correct price for the shares? There's a stock called AIR which is (presently) USD 34.64, and given the current $/£ rate makes 89 shares worth around £4k. You may be after the stock AIR.PA, showing right now as €73.50 gnc-fq-dump yahoo_europe AIR.PA Finance::Quote fields Gnucash uses: symbol: AIR.PA <=== required date: 06/08/2017 <=== recommended currency: EUR <=== required last: 73.50<=\ nav: <=== one of these price: 73.50<=/ timezone: <=== optional HTH, Maf. On Thursday, 8 June 2017 14:36:07 BST Eric Coates wrote: 8th June 2017 I’m having trouble with getting a valuation (in pounds sterling – hereafter GBP – I am based in the UK) for a share I own that is priced in Euros. To bore you with the details my original account listing was of this form: Assets >My Assets > >>My Portfolio >> >>>My Cash >>> >>>My Shares >>> Airbus Group Standard GBP denominated shares etc etc At this point everything except “Airbus Group” was denominated in GBPs, Airbus Group was denominated in Euros. I noticed the problem when I realised that value of the Airbus Group shares (in the column headed "Present(GBP)"was given as £3989 but the real value should be 89(the number of shares)*€73.07(the value of each share)*0.87(the Euro to GBP exchange rate) ie £5658. (All the numbers are rounded.) Using the information I found during various web searches (insofar as I understood it all) it seemed the problem might be that the account “My Shares” was denominated in GBP but “Airbus Group” is denominated in Euros. I modified the account structure to the following form: Assets >My Assets > >>My Portfolio >> >>>My Cash >>> Cash Euros Cash Pounds >>> >>>My Eurex Shares >>> Airbus Group >>> >>>My LSE Shares >>> Standard GBP denominated shares etc etc With “Cash Euros”, “My Eurex Shares” and “Airbus Group” denominated in Euros, everything else is denominated in GBPs. I transferred some funds from “Cash Pounds” to “Cash Euros”; the original “Airbus Group” was deleted and a new account was reconstituted (there were very few entries) with the purchase made from “Cash Euros”. The result was that the GBP value of the Airbus shares was (still) shown as £3989. More web searches revealed nothing that I recognised as of relevance. The only thoughts that I have that may be significant are: (A) “Cash Euros” and “Airbus Group”, although denominated in Euros, are deep(ish) in a tree denominated in GBPs and, in particular, “Cash Euros” is a sub-account of “My Cash” which is denominated in GBPs. Does this somehow interfere with the correct accounting? (B) My broker pays Airbus dividends to me in GBPs and thus some of the transactions in the “Airbus Group” account reference the “Cash Pounds” account. If this is the problem: assuming the dividend I receive is £12.34 would it be possible to credit €12.34 to “Cash Euro” and transfer it to “Cash Pounds” at an exchange rate of 1:1 without screwing up something else? I suppose I could just live with the “error” but what is accounting without accuracy! A separate set of accounts for one share seems too much like overkill. Thanks in advance for any help or advice offered. Eric Coates ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies
Re: Inability to correct GBP value for Euro priced shares
Hi Eric, Are you sure you're getting the correct price for the shares? There's a stock called AIR which is (presently) USD 34.64, and given the current $/£ rate makes 89 shares worth around £4k. You may be after the stock AIR.PA, showing right now as €73.50 gnc-fq-dump yahoo_europe AIR.PA Finance::Quote fields Gnucash uses: symbol: AIR.PA <=== required date: 06/08/2017 <=== recommended currency: EUR <=== required last: 73.50<=\ nav: <=== one of these price: 73.50<=/ timezone: <=== optional HTH, Maf. On Thursday, 8 June 2017 14:36:07 BST Eric Coates wrote: > 8th June 2017 > > I’m having trouble with getting a valuation (in pounds sterling – > hereafter GBP – I am based in the UK) for a share I own that is priced > in Euros. > > To bore you with the details my original account listing was of this form: > > Assets > > >My Assets > > > >>My Portfolio > >> > >>>My Cash > >>> > >>>My Shares > >>> > Airbus Group > > Standard GBP denominated shares > > etc etc > > At this point everything except “Airbus Group” was denominated in GBPs, > Airbus Group was denominated in Euros. > > I noticed the problem when I realised that value of the Airbus Group > shares (in the column headed "Present(GBP)"was given as £3989 but the > real value should be 89(the number of shares)*€73.07(the value of each > share)*0.87(the Euro to GBP exchange rate) ie £5658. (All the numbers > are rounded.) > > Using the information I found during various web searches (insofar as I > understood it all) it seemed the problem might be that the account “My > Shares” was denominated in GBP but “Airbus Group” is denominated in > Euros. I modified the account structure to the following form: > > Assets > > >My Assets > > > >>My Portfolio > >> > >>>My Cash > >>> > Cash Euros > > Cash Pounds > >>> > >>>My Eurex Shares > >>> > Airbus Group > >>> > >>>My LSE Shares > >>> > Standard GBP denominated shares > > etc etc > > With “Cash Euros”, “My Eurex Shares” and “Airbus Group” denominated in > Euros, everything else is denominated in GBPs. > > I transferred some funds from “Cash Pounds” to “Cash Euros”; the > original “Airbus Group” was deleted and a new account was reconstituted > (there were very few entries) with the purchase made from “Cash Euros”. > > The result was that the GBP value of the Airbus shares was (still) shown > as £3989. > > More web searches revealed nothing that I recognised as of relevance. > > The only thoughts that I have that may be significant are: > (A) “Cash Euros” and “Airbus Group”, although denominated in Euros, are > deep(ish) in a tree denominated in GBPs and, in particular, “Cash Euros” > is a sub-account of “My Cash” which is denominated in GBPs. Does this > somehow interfere with the correct accounting? > > (B) My broker pays Airbus dividends to me in GBPs and thus some of the > transactions in the “Airbus Group” account reference the “Cash Pounds” > account. If this is the problem: assuming the dividend I receive is > £12.34 would it be possible to credit €12.34 to “Cash Euro” and transfer > it to “Cash Pounds” at an exchange rate of 1:1 without screwing up > something else? > > I suppose I could just live with the “error” but what is accounting > without accuracy! > > A separate set of accounts for one share seems too much like overkill. > > Thanks in advance for any help or advice offered. > > > Eric Coates > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Inability to correct GBP value for Euro priced shares
8th June 2017 I’m having trouble with getting a valuation (in pounds sterling – hereafter GBP – I am based in the UK) for a share I own that is priced in Euros. To bore you with the details my original account listing was of this form: Assets >My Assets >>My Portfolio >>>My Cash >>>My Shares Airbus Group Standard GBP denominated shares etc etc At this point everything except “Airbus Group” was denominated in GBPs, Airbus Group was denominated in Euros. I noticed the problem when I realised that value of the Airbus Group shares (in the column headed "Present(GBP)"was given as £3989 but the real value should be 89(the number of shares)*€73.07(the value of each share)*0.87(the Euro to GBP exchange rate) ie £5658. (All the numbers are rounded.) Using the information I found during various web searches (insofar as I understood it all) it seemed the problem might be that the account “My Shares” was denominated in GBP but “Airbus Group” is denominated in Euros. I modified the account structure to the following form: Assets >My Assets >>My Portfolio >>>My Cash Cash Euros Cash Pounds >>>My Eurex Shares Airbus Group >>>My LSE Shares Standard GBP denominated shares etc etc With “Cash Euros”, “My Eurex Shares” and “Airbus Group” denominated in Euros, everything else is denominated in GBPs. I transferred some funds from “Cash Pounds” to “Cash Euros”; the original “Airbus Group” was deleted and a new account was reconstituted (there were very few entries) with the purchase made from “Cash Euros”. The result was that the GBP value of the Airbus shares was (still) shown as £3989. More web searches revealed nothing that I recognised as of relevance. The only thoughts that I have that may be significant are: (A) “Cash Euros” and “Airbus Group”, although denominated in Euros, are deep(ish) in a tree denominated in GBPs and, in particular, “Cash Euros” is a sub-account of “My Cash” which is denominated in GBPs. Does this somehow interfere with the correct accounting? (B) My broker pays Airbus dividends to me in GBPs and thus some of the transactions in the “Airbus Group” account reference the “Cash Pounds” account. If this is the problem: assuming the dividend I receive is £12.34 would it be possible to credit €12.34 to “Cash Euro” and transfer it to “Cash Pounds” at an exchange rate of 1:1 without screwing up something else? I suppose I could just live with the “error” but what is accounting without accuracy! A separate set of accounts for one share seems too much like overkill. Thanks in advance for any help or advice offered. Eric Coates ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
