> On Nov 14, 2020, at 8:28 AM, Eric Coates via gnucash-user > <gnucash-user@gnucash.org> wrote: > > Hi > > I appear to have found a significant miscalculation in GnuCash - no > disrespect or criticism intended. > > The "base currency" I use in my accounts is GBP (£) but I have some > sub-accounts that are denominated in Euros (€). > > I attach a screen shot of part of my chart of accounts (the two columns of > numbers are headed "Present(GBP)" and "Total"). The sub-sub-account "Eric ISA > (ii) Shares-Euro" is a placeholder of currency Euro within a parent > sub-account in currency GBP, itself under Assets also in GBP. > > The pertinent line is the first one of the screen shot; the Total is shown as > €14805.44 (which is a correct calculation based on the numbers of shares and > their values) but this number appears to be converted to £15824.56. This is > obviously wrong as the exchange rate is €1 = £0.8966. Also the conversions of > the individual shares to GBPs are also in error - but, interestingly, the > implied Euro/GBP exchange rates are different (1.19 for Airbus, 0.76 for > Deutsche Post and 0.95 for SAP). > > (The share prices and the exchange rate were all obtained through the "Get > Quotes" feature and were confirmed by web searches.) > > If this were a general problem I'm sure it would have caused quite a flurry > of messages so I can only assume that, somehow, I've screwed up somewhere > (not unusual!) but I can't find where it is. > > If any one can point me to my error I'd appreciate it. > > For completeness I'm running GnuCash 3.8 with Finance::Quote 1.49 on Ubuntu > 20.04 (Frankly, I can't see that having any bearing on this problem. But what > do I know?) > > Take care, keep well
The amounts in GBP add up to 15,824.56. What are the headings of the two amount columns on the accounts page? In the price database find the latest prices for the three securities. What are the latest prices, including currencies, dates, and amounts? What are the GBP->EUR and EUR->GBP exchange rates for each of the dates of those stock prices and what is the latest of each? Regards, John Ralls _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
