In the following, the first word on the COA is the Type of account.
When I had the Canada stock as a child of CAD cash account,
the Advanced Portfolio report did not include the CAD stock
(even when I said to select all children of Fidelity).
Assets
Asset Fidelity (in USD)
Cash CAD (in CAD)
Stock EIF:CA
I had changed the chart of accounts to:
Assets
Asset Fidelity (in USD)
Asset Canada (in USD)
Cash CAD (in CAD)
Stock EIF:CA
so both the CAD cash and the Canada stock are a child of
an asset accout in USD. The Advanced portfolio report is OK
(once I removed the USD price quote for the CAD stock).
Based upon your post, I have changed the chart of accounts to:
Assets
Asset Fidelity (in USD)
Asset Canada (in CAD)
Cash CAD (in CAD)
Stock EIF:CA
so both the CAD cash and the Canada stock are a child of
an asset accout in CAD. The Advanced portfolio report is OK.
On Mon, Oct 21, 2024 at 3:34 PM Derek Atkins <de...@ihtfp.com> wrote:
> Hi,
>
> The Currency of a stock is based upon the currency of its parent account.
> How do you have your brokerage set up?
> To get this to work, you would need a "Foreign-Brokerage CAD" asset
> account as the parent for the CAD-enumerated stock account. Do you have
> that?
>
> -derek
>
> On Mon, October 21, 2024 9:06 am, Fred Tydeman wrote:
> > I am running Gnucash 5.9 on Fedora Linux 40
> > My home currency is USD
> > My Fidelity brokerage account has one stock on a Canada stock exchange.
> > I have run Reports: Assets&Liabilities: Advanced Portfolio.
> > In the options, I changed the date to yesterday (Oct 19).
> > The line in the report for that Canada stock was very wrong.
> > I left clicked on the blue highlighted Price.
> > The popup shows a date of last January.
> > I opened Tools: Price Database
> > There is a price for last January (but in USD, not CAD like the rest of
> > the
> > prices).
> > There is a CAD price for Oct 18, yet it is not being used in the report.
> >
> > I have removed the USD price entry from the Price Database and the report
> > is OK (after Reload).
> > Seems wrong to use a price from 9 months ago when there is a current
> > price.
> >
> > Also, not sure how USD prices are mixed in with CAD prices for a CAD
> > stock.
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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 617-623-3745
> de...@ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>
>
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
