Re: [GNC] Trading accounts

An easy way to check duplicates would be to take a look at the price 
database and glance through duplicates....

On 8/10/26 12:55 PM, Wm Tarr 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.