Stocks, advanced portfolio and multi-currency

Derek Atkins warlord at MIT.EDU
Mon May 13 09:51:45 EDT 2013


The stock's price's currency is implicit, based on the currency of its
parent brokerage account.  Most likely your MDA.TO stock account's
parent is denoted in USD and not CAD.  This means that all the existing
transactions in that account would also be wrong, denoted in USD, not
CAD.  That would explain the results you see.

You will need to delete all the transactions in the account, fix your
account hierarchy, and then re-enter all your buy/sell transactions in
the stock account.

-derek

Stefano M Canta <cantastefano at gmail.com> writes:

> The basis shows as 12766.46 CAD instead of 12766.46 USD. So the initial
> price is not correctly setup, and there is no way of specifying the
> currency of the initial price per share.
>
> Stefano
>
>
> -----
>
> Stefano Mihai Canta, Ph.D.
> Electrical Engineering Specialist
> Antenna Subsystem Operations
>
> Space Systems/Loral
> 3825 Fabian Way M/S G-43
> Palo Alto, CA 94303-4604
> Tel  1-650-852-5808
> Fax 1-650-308-1808
>
>
> On Sun, May 12, 2013 at 8:06 PM, Stefano M Canta <cantastefano at gmail.com>wrote:
>
>> Hello,
>> I have the following problem.
>> I am based in the US and my company offers a share purchase plan.
>> I invested 12766.46 USD to buy 181.223261 shares of MDA.TO, which is
>> exchanged in Toronto. The brokerage valued 12766.46 USD to be 13133.55 CAD
>> on May 8th 2013.
>>
>> The overall transaction is 12766.46 USD -> 13133.55 CAD -> 181.223261
>> MDA.TO.
>>
>> Now I want to use the advanced portfolio report to to show my basis, and
>> the possible gain, in USD.
>>
>> The problem is that the report uses the 13133.55 CAD but converts this
>> value to USD using the online quote instead of the original price of
>> 12766.46 USD. So every day my basis changes... This is not the behavior
>> that I want to see for the basis. I am fine with the value of the stock
>> changing every day according to the market value of MDA.TO and the
>> conversion rate of USD to CAD, but the basis should only be related to the
>> day I bought the stock.
>>
>> How do I change that in the report?
>>
>> Thanks,
>> Stefano
>>
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

-- 
       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