Re: [GNC] Apparent Miscalculation

2020-11-16 Thread Christopher Lam
Because it's what it was written to do. Try the closest direct price first if one exists. If not try with 1 intermediate currency. If not, it fails. https://github.com/Gnucash/gnucash/blob/maint/libgnucash/engine/gnc-pricedb.c#L2576 On Mon, 16 Nov 2020 at 10:55, Eric Coates via gnucash-user <

Re: [GNC] Apparent Miscalculation

2020-11-16 Thread Eric Coates via gnucash-user
Hi SAP 19 shares @ €102.00 equals €1938.00 @ (€0.89662 = £1) thus value =£1737.65 *NOT £1831.77* You avoided answering the question about your recorded EUR-GBP rate. Mea culpa! It should have read "€1 = £0.89662" - and I spent over an hour writing that email! On the bright side the

Re: [GNC] Apparent Miscalculation

2020-11-16 Thread Fred Bone
On 14 November 2020 at 21:23, Eric Coates said: [...] > 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 >

Re: [GNC] Apparent Miscalculation

2020-11-15 Thread John Ralls
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

Re: [GNC] Apparent Miscalculation

2020-11-15 Thread Eric Coates via gnucash-user
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

Re: [GNC] Apparent Miscalculation

2020-11-14 Thread John Ralls
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

Re: [GNC] Apparent Miscalculation

2020-11-14 Thread Eric Coates via gnucash-user
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

Re: [GNC] Apparent Miscalculation

2020-11-14 Thread John Ralls
> On Nov 14, 2020, at 8:28 AM, Eric Coates via gnucash-user > 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

[GNC] Apparent Miscalculation

2020-11-14 Thread Eric Coates via gnucash-user
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