[GNC] Feature request: Stock currency setting

Wm wm_o_o_o at yahoo.co.uk
Wed Oct 31 08:35:01 EDT 2018


On 27/10/2018 13:30, rsbrux via gnucash-user wrote:
>>>
> You can just move the account, but the transaction currency is immutable so you will have to delete and re-create the transaction.
> 
> As for adding a trading currency to the security editor, it’s possible but the code for creating transaction currency is kind of splattered around (register, transfer dialog, scheduled transactions, importers, maybe more) so getting it right would be a bit of work.
> <<
> 
> Thanks for the response.  To get the desired results, I found it necessary to delete the account I had created for transactions in that security and then > recreate each of the transactions using the "orphaned" transactions as a model.

Don't use the orphans for long, *always* move the tx to an appropriate 
account unless you are the sort of person that throws all their 
financial documents in a drawer and sorts them out only when they have to.

 >
   If currency is a property of a transaction, would it be easier to 
provide a way to change a transaction's currency than that of a security?

Not really.  A transaction is between two accounts, gnc's model uses a 
commodity per account, nothing wrong or right about that, you just have 
to build your CoA appropriately.

  That would have at least made it possible for me to reuse the 
previously entered transactions, by changing their currency and 
assigning them to the new account.  It isn't even clear to me that 
currency *is* a security property.  In the price editor I found prices 
for the security in question in both CHF and USD.

Transactions are cheap, accounts more expensive :)

gnc rewards building a good CoA, it is all to do with double entry and 
good practice, if you come from a single entry finance world it can be 
more formal than you expect.

Anyway, in the real world stock ABCD bought in two currencies is almost 
certainly actually two holdings of that stock not one *unless* there was 
a currency exchange before the purchase, in which case why not reflect 
that in your accounts?

A parallel is people owning stock ABCD in a retirement account and an 
investment account, same stock, two separate holdings, gnc recognizes 
the separation even though you may not acknowledge it.

In general, use a CASH or BANK type account of CURRENCY CCC to buy a 
commodity priced in that currency, I do something like this.

ASSET mixed stuff below GBP <-- or whatever your book currency is
    \ USD account
	\ shares, etc in USD
    \ EUR account
   	\ shares, etc in EUR

It isn't really limiting, all you have to do is put a "plain" account on 
top of the more complex underlying asset, that way most transactions and 
reports will work as expected.

And if you think about it, gnc is reflecting reality, when you buy a RUB 
asset using CHF there are two exchanges, CHF => RUB => commodity.

-- 
Wm













More information about the gnucash-user mailing list