[GNC] Changing Currency in Price Data
Geoff
cleanoutmyshed at gmail.com
Sun Apr 11 21:30:19 EDT 2021
Here's my 20 cents on this topic (and I am not an accountant):
If the security changed currency, it should be treated as a corporate
event, and set up as a new security. The balance of the original
security should be set to zero, and you can twiddle the exchange rates
to record any gains or losses. It might be helpful to think of it as a
take over or buy out.
If an underlying security is listed on multiple exchanges, or listed in
multiple currencies, again you should treat them as separate securities,
with separate price feeds. It might be helpful to think of each them as
separate derivatives (eg options etc). You can bet your bottom
dollar/euro/yen that there will be market makers sitting in front of
each of them taking a clip.
Regards
Geoff
=====
On 12/04/2021 2:57 am, David Carlson wrote:
> Isn't it possible that a stock can be quoted in more that one currency? If
> it is traded on more than one exchange or priced privately, possibly if it
> is not traded publicly but a private price is publicly available as a few
> securities such as XDNIX (quoted on Yahoo) in the United States. I think
> GnuCash can track such cases if the user wants to track them.
>
> On Sun, Apr 11, 2021 at 11:16 AM John Ralls <jralls at ceridwen.us> wrote:
>
>>
>>
>>> On Apr 10, 2021, at 6:25 AM, Ingo Planz <planz at pantherrey.de> wrote:
>>>
>>> Hi everyone,
>>>
>>> in my price data, the currency for one of the stocks has changed. It
>> used to be in EUR, which is also the default currency and reporting
>> currency. Since recently that stock price is stored in JPY.
>>> I also do have the corresponding exchange rate in the price database as
>> well.
>>>
>>> However, both the values computed for both the Accounts tab as well as
>> reports (method: nearest in time) ignore the newer JPY prices and use the
>> final EUR price.
>>>
>>> If I do delete all the EUR prices, it works as expected and computes
>> values by converting the JPY prices with the exchange rate.
>>>
>>> Am I missing something or am I doing it wrong? Can I change the currency
>> in the stock price data like this?
>>
>> GnuCash understands the currency in which the stock is priced to be the
>> currency of the stock account's immediate parent, so you would create a
>> parent account of type ASSET denominated in JPY and make that new account
>> the stock account's parent.
>>
>> But why exactly did the stock's quote currency change? That's not a common
>> occurrence.
>>
>> Regards,
>> John Ralls
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
More information about the gnucash-user
mailing list