Currency Issues

John Ralls jralls at ceridwen.us
Mon Sep 15 22:29:45 EDT 2014


On Sep 15, 2014, at 3:28 PM, Les <lelliott5 at gmail.com> wrote:

> On 09/15/2014 05:09 PM, John Ralls wrote:
>> On Sep 15, 2014, at 12:15 PM, Les <lelliott5 at gmail.com> wrote:
>> 
>>> On 09/15/2014 01:00 PM, John Ralls wrote:
>>>> On Sep 15, 2014, at 10:04 AM, Les <lelliott5 at gmail.com> wrote:
>>>> 
>>>>> Several days ago, I wrote to this list concerning problems regarding
>>>>> exchange rates. (copy of email below).
>>>>> 
>>>>> In that email, I used terms such as folders and I should have used
>>>>> accounts and sub-accounts.  But the facts are still the same. 
>>>>> 
>>>>> Could someone please assist in solving this problem?
>>>>> 
>>>>> Thanks,
>>>>> Les
>>>>> 
>>>>> I have a bank with multiple currencies.  The primary currency for this
>>>>> bank is HKD.  Within this account I have a folder "saving" and type is
>>>>> cash.  Under "saving" is a folder "currency" with type cash and contains
>>>>> several other folders: CNY, HKD, etc
>>>>> 
>>>>> Everything works fine except CNY does not roll up properly (it does not
>>>>> maintain an exchange rate for CNY:HKD).  Is there a way to solve this? 
>>>>> Using LMDE v 1403 and GC 2.4.13.
>>>> By “does not roll up properly”, do you mean that the amount shown in the Currency Total sums all of the values of the sub-accounts except CNY, or that it assumes a 1:1 exchange rate for CNY->HKD?
>>>> 
>>>> Are you retrieving prices online, and do you have any prices in the Price database for CNY->HKD?
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>> I mean that the CNY:HKD does not work properly.  It appears that
>>> exchange rate between these two currencies is 1:1.
>>> I am retrieving prices online daily (week days).  I am receiving prices
>>> for 8 currencies (including CNY and Hkd).
>> Open Tools>Price Editor and in the list-box reveal CURRENCY and CNY. Make sure that those quotes are in HKD.
>> 
>> If they’re not, I don’t know how to fix it. I just suspect that it might explain your problem.
>> 
>> Regards,
>> John Ralls
>> 
> That is the issue; it is being priced in USD.

OK. Anyone know how to coerce F::Q to get exchange rates in the right counter-currency?

Regards,
John Ralls






More information about the gnucash-user mailing list