[GNC] Changing Currency in Price Data
Ingo Planz
planz at pantherrey.de
Mon Apr 12 13:19:51 EDT 2021
I guess that would be the proper way to do it. I am not an accountant
either and am using GNC for my personal finances so everything's a bit
sloppy here ...
Actually the stock hasn't changed at all. Neither has my bank or the
place I would trade that stock -- both of which is in EUR/some European
Stock Exchange via my bank. I am using the price database to track the
value of my assets over time. This is somewhat approximate and not very
precise anyway, since a) I add new prices only about once a week. And
b) it's never been neccessarily prices from the exchange where I would
have bought or sold the stock.
What I did do was change the data source of the price data. It used to
be from a source that had prices at Frankfurt Stock Exchange in EUR.
Now I want to use a source that has price data from Tokyo SE (in JPY
obviously). Mainly because it's easier for me to automatically get and
insert into the price database. I am not intending to trade at Tokyo SE
(I don't think I even could), it's just a convenient data source for me
to use and I don't mind the inaccuracy.
I figured, that -- for simplicity -- I could just keep using the very
same security and just have price data in different currencies. After
all the price editor allows for setting a currency in every price entry.
Best regards,
Ingo
Am Mo, 12. Apr, 2021 um 11:30 VORMITTAGS schrieb Geoff
<cleanoutmyshed at gmail.com>:
> 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