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