[GNC] multiple currencies in one transaction

Jeff Abrahamson jeff at p27.eu
Thu Aug 15 15:14:42 EDT 2019


On 15/08/2019 18:55, John Ralls wrote:
>> On Aug 15, 2019, at 7:38 AM, Jeff Abrahamson <jeff at p27.eu> wrote:
>>
>> Somewhat related, I thought to import historical currencies, as I'm back
>> filling some data for analysis purposes.  I grabbed 10 years of daily
>> quotes and imported them (3600 or so rows of data per currency).  All ok
>> for GBP - EUR.  When I do the same for CHF - EUR, gnucash says it's done
>> it, but the price database doesn't show more than a handful.  When I do
>> it for JPY - EUR, gnucash says it's done but the price editor shows none
>> of them.  The proposed exchange rates when entering transactions are
>> consistent with what the price editor thinks it knows.
>>
>> Is there a limit on FX rates?  (This is about 4000, which doesn't strike
>> me as terribly large.)
> Did you look at both both directions in the price db?
>
> Between versions 2.6.8 and 3.5 GnuCash inverted quotes < 1.0 because of a mis-begotten rounding scheme in 2.6 that truncated at 6 decimal places. The rounding was fixed in 3.0 but the reversal wasn't removed until Mike Alexander noticed it when working on a bug last spring.
>
> Aside from a few days in January 2015 the CHF has traded at less than 1 EUR and the JPY of course always trade that way, so most of the CHF rates and all of the JPY rates should show up under EUR.

I did look in both directions.  Under euro there were no exchange rates
listed in the price database.

I'll play with it a bit more and see what I can find.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.com/



More information about the gnucash-user mailing list