what exchange rate gnucash uses for reports - it's not what I entered manually
Derek Atkins
warlord at MIT.EDU
Mon Feb 11 13:57:05 EST 2013
321654 <krok.geena at gmail.com> writes:
>> ;; The multicurrency support has NOT been tested and IS ALPHA. I
> OK, thank you. I guess no gnucash for me.
> Can someone please put this warning to gnucash homapge: gnucash can
> not support multicurrency accounting.
> (or something like that)
No, because it's not true.. GnuCash does support multi-currency
accounting just fine (for MOST cases -- there are still some bugs in
terms of properly handing the cap-gains/losses). It's really just that
some of the reports may not output multi-currency in a way that you
want, but patches are always welcome. This is a community effort after
all. Also, in your particular case you "chose poorly" in choosing a
currency to overload for your non-standard use. If you chose something
like, XXX, then you would've been in a much better situation than
chosing an old pre-Euro Euroland currency.
> Now, how can one get of this list :)
At the bottom of every message is a URL that you can use to get to the
list administration page which lets you unsubscribe.
-derek
> On 2 February 2013 23:01, David T. <sunfish62 at yahoo.com> wrote:
>> 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.
>>
>>
> _______________________________________________
> 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.
>
>
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-user
mailing list