Sotcks in different currencies with differents bank accounts currencies

Derek Atkins warlord at MIT.EDU
Mon Apr 18 10:51:44 EDT 2005


#3 should work fine if you enter the transactions from the USD account
and not from the Stock account.  It defintely wont work if you enter
it from the Stock account.

-derek

Nicolas Scheffer <nico at airboum.net> writes:

> Derek,
>
> Thanks for your answer.
> Yes i would like to have some enhancement trough a patch to be able to 
> use all my accounts correctly.
> To be sure regarding my requirements, here is a sort of summary:
>
> I am using Gnucash with the Euro as a default currency and also in all 
> report.
> I have two bank accounts:
> - one in Euro, Bank A
> - one in USD, Bank B
>
> I have three brokers for trading:
> 1) one in Euro when i buy stocks in Europe linked to Bank A
> 2) one when i buy stocks outside Europe (mainly US) linked to bank A <- 
> working only if i enter each USD transaction converted in Euro, 
> fetching price stocks and report are working
> 3) one when i buy stocks in the US only (USD) linked to bank B <- not 
> working at all, if i enter the USD price report are wrong when i update 
> stocks price, normally i should be able to enter the transaction with 
> the origin currency (USD) and got the report converted to my default 
> currency <- not working
>
> --------------
>
> 1) is working perfectly
>
> 2) is working only if i convert the origin transaction (USD) to Euro 
> before to enter it, but it could be better if i could enter it in USD 
> directly, because when i define the stock the currency is USD, why i 
> need to enter it in Euro to have it working ?
>
> 3) is not working at all.
>
> Thanks a lot for your help.
>
> Regards
>
> Nicolas
>
>
>
> On 15 avr. 05, at 14:48, Derek Atkins wrote:
>
> Nicolas Scheffer <nico at airboum.net> writes:
>
>> Derek,
>>
>> Is there a change to have the implicit and explicit exchange rates to
>> handle my current problem ?
>
> No.  At least not in any short timeframe.
>
>> Or it's a current real limitation on GnuCash ?
>
> Yes.  Maybe.  There are potentially three "currencies" in every
> two-split transaction:
>
> 1) The "currency" of account A
> 2) The "currency" of account B
> 3) The Transaction "common currency".
>
> At this point there is no way for the user to set #3.  If you're
> working from a currency-based account then #3 is set to the same
> currency as that account (e.g. if you're in a USD Bank account then
> transactions are created with USD common-currency).
>
> However if you create txns in a non-currency account (e.g. Stock
> account, or the General Ledger) then Gnucash "chooses" the locale
> currency as the the txn common currency.
>
> I don't know if making this currency visible to the user would
> aleviate your issue.  Regardless, the restriction that all txns in a
> particular account are denoted in the account commodity will never go
> away.
>
>> I suppose i am not alone to have different bank accounts with different
>> currencies (USD and Euros) and handling stocks on both bank account
>> with different currencies ?
>
> You're the first person that I've heard speak about it.  If you want
> it done, I suggest sending in a patch.
>
>> regards
>>
>> Nicolas
>
> -derek
>
>> On 21 déc. 04, at 22:18, Derek Atkins wrote:
>>
>> Nicolas Scheffer <nico at airboum.net> writes:
>>
>>> Derek,
>>>
>>> Regarding you first answer my bank account is Euro and if i buy USD
>>> stocks trough this bank account, why i cannot apply an exchange rate
>>> like expenses on a bank account ?
>>
>> Your Euro bank account can only handle Euro transactions.  You can't
>> translater between Euro, USD, *AND* a stock in one transaction.
>>
>>> For the second answer, if i fill the transaction trough the bank
>>> account i will have also an exchange rate window or i will have the
>>> same problem ?
>>
>> You should get the exchange-rate dialog.
>>
>>> Maybe i do something wrong to setup my different accounts (stocks,
>>> banks, etc..) or does the current conception of Gnucash is not perfect
>>> to handle such case ?
>>
>> Gnucash does not handle implicit exchange rates, which is what you're
>> asking for.  GnuCash also does not handle explicit transaction
>> currencies, which is also what you're asking for.
>>
>>> Regards
>>>
>>> Nicolas
>>
>> -derek
>
> -- 
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
>
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available



More information about the gnucash-user mailing list