Fw: Re: Finance::Quote ??

[Georg Stapper]

I set up a very simple account structure with assets, expenses and income in three different currencies (EUR, GBP and ZAR). There are two types of transactions: 3 income transactions (100 EUR, 100  GBP, 100 ZAR) and 3 expense transactions (100 EUR, 100  GBP, 100 ZAR). The base currency is EUR.

If I choose EUR as the report currency, then 2 exchange rates (EUR/GBP and EUR/ZAR) are sufficient to produce the correct results (see attached pdf). However, if I choose ZAR as the report currency I need also the the ZAR/EUR exchange rate otherwise the income and expenses in EUR are not calculated. Hence it makes a lot of sense, if "Get Quotes" actually pulls all the different exchange rates necessary for the report.

For all three currencies the "Get Online Quote" flag is set.

Cheers,
G.


--- On Thu, 22/1/09, Georg Stapper <georgstapper at yahoo.com> wrote:

> From: Georg Stapper <georgstapper at yahoo.com>
> Subject: Re: Finance::Quote ??
> To: "Frank H. Ellenberger" <f.ellenberger at online.de>
> Cc: gnucash-user at gnucash.org
> Date: Thursday, 22 January, 2009, 8:32 AM
> --- On Sat, 17/1/09, Frank H. Ellenberger
> <f.ellenberger at online.de> wrote:
> 
> > From: Frank H. Ellenberger
> <f.ellenberger at online.de>
> > Subject: Re: Finance::Quote ??
> > To: "Georg Stapper"
> <georgstapper at yahoo.com>
> > Cc: gnucash-user at gnucash.org
> > Date: Saturday, 17 January, 2009, 5:06 PM
> > Hi,
> > 
> > Am Saturday 17 January 2009 08:56:47 schrieb Georg
> Stapper:
> > > I read the multiple currency chapter twice and I
> still
> > don't see why
> > > Finance::Quote does not update the other FX
> rates.
> > 
> > Why should it? The target is usually, to show you the
> value
> > of your foreign 
> > investments in your domestic/base currency.
> > 
> 
> OK, but for me at least two of the currencies are equally
> important.
> 
> > > So, if I change my base currency to ZAR, I see
> the
> > updates FX rates with
> > > ZAR as the base rate, but e.g. the GBP/EUR FX
> rate is
> > not updated. Is that
> > > really the intended behaviour?
> > 
> > Hm, I believe switching the base currency in an file,
> which
> > contains 
> > transactions, is no good idea. To play around, you
> could
> > use the report 
> > currency.
> > 
> 
> 
> I tried that. However, this leads to the problem described
> in my mail "Reports -> Income & Expense ->
> Cash Flow" (see below).
> 
> Therefore I thought it might be good to have all possible
> exchange rates available. If that does not seem to be the
> case, what can I do to get the cash flow report right?
> 
> 
> > > Thanks
> > > G.
> > 
> > Frank
> 
> 
> 
> Hi,
> 
> I did not get a reply to the cash flow report currency
> problem so far. Is there anyone out there who has an idea
> how I can fix it? This seems to be a bug to me.
> 
> Sorry for pushing it a bit.
> 
> 
> I have set up my accounts with three different currencies.
> The main currency is EUR some sub-accounts are denominated
> in GBP or ZAR. I have set up all FX rates for the currencies
> in the Price Editor using Finance::Quote. The figures of the
> sub-accounts add up correctly for the main accounts. This
> makes believe that the currencies are set up properly.
> 
> If I try to get a cash flow report for a currency other
> than the one associated to the given locale (regional
> settings under Windows XP), the figures given for the
> account are taken as the figures for the currency set under
> Windows instead of the account currency. If I change the
> report currency (under the GnuCash preferences) to the
> account currency, the FX rates come into play and mess it up
> even more. 
> 
> How do I fix this?
> 
> Thanks for your help!
> 
> G.
> 
> 
> 
>       
> _______________________________________________
> 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.