what exchange rate gnucash uses for reports - it's not what I entered manually

Sat Feb 2 16:01:44 EST 2013

Replying to my own message, I see that the scm source includes a note from the original writer (in 2004) that:

;;    The multicurrency support has NOT been tested and IS ALPHA.  I
;;    really don't if I used the correct exchange functions.  Search
;;    code for regexp "*exchange-fn".

I have no idea whether this note is still accurate.

________________________________
 From: David T. <sunfish62 at yahoo.com>
To: 321654 <krok.geena at gmail.com> 
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
Sent: Saturday, February 2, 2013 12:40 PM
Subject: Re: what exchange rate gnucash uses for reports - it's not what I entered manually

I will start by saying that I am not a programmer. 

That said, I see that you are referring to a static variable gnc_euro_rate_struct that appears to be the final exchange rate of currencies into the Euro when the Euro was installed back in 2002. See http://en.wikipedia.org/wiki/History_of_the_euro#Change_of_currency, where you will see a table that includes the Finnish Mark with the rate you include here.

The code you are citing is C source, and so I (the non-programmer) doubt it is invoked in the reports, which are written separately in Scheme. I don't know whether this variable is available to the Scheme report writer.

More likely is that because the FIM is discontinued, the final exchange rate of record is the last one being used. Not being at a GnuCash machine right now, I can't say whether it is possible to create a new price for the FIM using the price db. I certainly don't know how the report implements the price db for currencies.

I would have assumed that a report that depends on fluctuating valuations of currencies would follow the example set by reports that track the fluctuating value of commodities (that is, to use entries in the price db), but it could be that currency rates are handled differently because of their ISO-ness. It wouldn't be the first time that a report writer built a report that omitted a particular use case.

As for the adding of currencies to the definitions, for reasons that the developers have noted in the past, the currencies list used by GnuCash is based on the ISO currencies list. It is my understanding that if users create the additional functionality needed to accommodate other currencies, those changes might be integrated into GnuCash. So far, no one has submitted these alterations, however.

David

________________________________
From: 321654 <krok.geena at gmail.com>
To: David T. <sunfish62 at yahoo.com> 
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
Sent: Saturday, February 2, 2013 5:51 AM
Subject: Re: what exchange rate gnucash uses for reports - it's not what I entered manually

"nearest in time" setting did not help me. :(

I can see the FIM exchange rate is the source code (src/app-utils/gnc-euro.c)
Line 56
{ "FIM",  5.94573 },  /* finnmark */)

I guess this is used but why are my manually entered rates ignored, is
still a mystery.

BTW, this all started because gnucash is now allowing users to add
additional currencies.
I had to use something, that is not used any more, like FIM.

On 30 January 2013 01:18, David T. <sunfish62 at yahoo.com> wrote:
> Actually, the thread you cite is an email message to the list, not a bug.
> The official repository for GnuCash's reported bugs is Bugzilla
> (https://bugzilla.gnome.org/browse.cgi?product=GnuCash). In the thread you
> cite, an answer was provided by one of the developers at the time. Since
> there was no further response from that user, it must be assumed that the
> advice fixed his problem. I'll note that the advice given there was to check
> that the report options for prices was set to "nearest in time", which is
> the advice provided earlier in this thread; did you try that, and did it fix
> anything?
>
> A search of Bugzilla for the word "exchange" turned up a number of bugs, but
> none of them appeared to address any problems with reports.
>
> I have seen circumstances in my own data where exchange rates have not been
> entered into the price database, thus throwing off account values
> substantially, but I am not certain whether these omissions are due to a bug
> in GnuCash, or whether it is an artifact of importing these transactions in
> from an earlier financial package. I would have to do some testing to see
> whether this is an issue.
>
> Good luck,
> David
>
> ________________________________
> From: 321654 <krok.geena at gmail.com>
> To: gnucash-user at gnucash.org
> Sent: Tuesday, January 29, 2013 11:38 AM
> Subject: Re: what exchange rate gnucash uses for reports - it's not what I
> entered manually
>
> Looks like this is a really old bug (Nov 29, 2005) in gnucash :(
> http://gnucash.1415818.n4.nabble.com/exchange-rate-value-for-reports-td1417095.html
>
> If you have any idea how to fix this, please let me know.
>
>
> On 28 January 2013 22:02, wrote:
>> On Mon, Jan 28, 2013 at 9:51 PM, Derek Atkins <derek at ihtfp.com> wrote:
>>> Hi,
>>>
>>> On Mon, January 28, 2013 2:46 pm, Krokodill Geena wrote:
>>>> I have searched here and there but I still can not figure out, where
>>>> gnucash gets the exchange rate for the reports.
>>>> It is obviously not the exchange rate I have entered with Tools>Price
>>>> Editor > sect the currency, enter correct exchange rate, save (date is
>>>> today)
>>>> Guess what, report still show about 10 years old exchange rate. :)
>>>> Yes, I have disabled the automatic update and this did not help me at
>>>> all.
>>>>
>>>> Because there is now way to add a new currency, I had to use good old
>>>> and so dead FIM as a "place holder" to save me from manual conversions
>>>> (there is no FIM any more because it was wiped out by EU euphoria back
>>>> in 2002)
>>>>
>>>> Yes, I have disabled the automatic update and this did not help me at
>>>> all.
>>>> I even attempted to use Tools > Price Editor > Remove Old.
>>>> Nothing, still that same old rate :(
>>>>
>>>> Is it hardcoded somewhere? Where?
>>>
>>> Which report?
>>
>> Same with all the reports
>>
>> For now, I used Equity Statement For Period Covering 2013-01-01 to
>> 2013-12-31
>> 2013-01-01 is wrong
>> 2013-12-31 is also wrong
>>
>> I made a custom report with a currency price chart, selected price
>> database as the source.
>> Chart shows correct exchange rates.
>>
>>
>>> Have you looked in the report options to select your price source?
>>> Most likely you will want to change the it to "nearest in time"
>>>
>>>> Thank you for your help
>>>
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>> -derek
>>>
>>> --
>>>        Derek Atkins                617-623-3745
>>>        derek at ihtfp.com            www.ihtfp.com
>>>        Computer and Internet Security Consultant
>>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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 at 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.