Re: [GNC] Trading accounts

Thanks for that.

I added
WHERE
  namespace != 'CURRENCY'

As some of the stocks have the same ticker as some currency,
so show up as a duplicate.

On Mon, Aug 10, 2026 at 11:56 PM Wm Tarr <[email protected]> wrote:

> I don't think you can do it in gnc but here is some SQL that does it
>
> ===
>
> with m_cnt as (
>
> select mnemonic, count(*) as cnt
>
> from commodities
>
> group by mnemonic
>
> having cnt > 1
>
> )
>
> select namespace, mnemonic
>
> from commodities
>
> where mnemonic in (select mnemonic from m_cnt)
>
> ;
>
>
> ===
>
> Wm
>
> On 2026-08-10 01:36, Fred Tydeman wrote:
> >
> > Anyone know of a way to find stocks in more than one Namespace?
> >
> >
> _______________________________________________
> gnucash-user mailing list
> [email protected]
> 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.
>
_______________________________________________
gnucash-user mailing list
[email protected]
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.