Eric, Where you went astray in answering before was second-guessing my question: I asked you to report on specific entries in the price database. As I expected, you found the problem when you finally looked where I was trying to point you.
The reason that it was a problem is that GnuCash looks for a direct price before trying for indirect ones, so if it finds a direct price no matter how old that's what it will use. Regards, John Ralls > On Nov 15, 2020, at 4:21 AM, Eric Coates <twistedw...@talktalk.net> wrote: > > John > > Re: "...unfortunately your answers don't completely answer them" and I > thought I'd answered them in excruciating detail! But no matter. > > Your additional question sent me looking in the price data base and yes, > indeed, there were some old prices in GBP (from a long time ago and a long > way down the listing). I removed them and the CoA now shows the numbers I'd > expect. So it was an input problem, now all is well. > > However, this exercise has thrown up a question in my mind. At the moment I > cannot quite formulate it so I need to do some reading. I may be back! > > Thank you for your time and patience, I appreciate it. > > Take care > > Eric > > =========================== > > On 14/11/2020 23:23, John Ralls wrote: >> Eric, >> >> Keep in mind that the calculations are simple multiplications and additions >> and as you noted thousands of users don't have a problem with them, so the >> problem is bad inputs to those calculations. We need to find the sources of >> those inputs and they're most likely in the pricedb. The questions I asked >> are a start to that process; unfortunately your answers don't completely >> answer them. Please try again. >> >> I've another one as well: See if there are any entries for the stocks in GBP. >> >> Regards, >> John Ralls >> >> >> >>> On Nov 14, 2020, at 1:23 PM, Eric Coates via gnucash-user >>> <gnucash-user@gnucash.org> >>> wrote: >>> >>> John >>> >>> The heading for the column starting with £15824.56 is "Present(GBP)" >>> ... for the column starting €14805.44 is "Total" >>> >>> I agree that the bottom three amounts in the first column adds up to >>> £15824.56 >>> >>> Also >>> The total value of the three stock in Euro terms (see below) is €14805.44 >>> >>> The price of the shares and the Euro/Pound exchange rate were obtained at >>> (about) 1000 GMT this morning (ie approximately 11 hours ago). I "froze" >>> the book at that time so that I could work with fixed values. >>> >>> The full details for each share follows: >>> >>> Airbus >>> 114 shares @ €85.56 equals €9753.84 @ (€0.89662 = £1) thus value >>> =£8745.49 *NOT £11631.65* >>> >>> Deutsche Post >>> 80 shares @ €38.92 equals €3113.60 @ (€0.89662 = £1) thus value =£2791.72 >>> *NOT £2361.44* >>> ** >>> SAP >>> 19 shares @ €102.00 equals €1938.00 @ (€0.89662 = £1) thus value =£1737.65 >>> *NOT £1831.77* >>> >>> >>> For completeness: >>> The implied Euro/Pound exchange rates for >>> Airbus (the conversion of €9753.84 to £11631.65) 1.1925 >>> Deutsche Post (the conversion of €3113.60 to £2791.72) 0.7584 >>> SAP (the conversion of €1938.00 to £1831.77) 0.9452 >>> >>> Take care >>> >>> Eric >>> >>> ======================================* >>> * >>> >>> * >>> * >>> >>> On 14/11/2020 17:30, John Ralls wrote: >>> >>>>> 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. >>> _______________________________________________ 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.
