>
>
> List of "stocks" in more than one Trading account:
>
>
Google Chrome AI came up with:
SELECT
c.mnemonic,
COUNT(a.guid) AS trading_account_count
FROM
accounts a
INNER JOIN
commodities c ON a.commodity_guid = c.guid
WHERE
a.account_type = 'TRADING'
GROUP BY
c.mnemonic
HAVING
COUNT(a.guid) > 1;
Again, it found several duplicates. However, some of them are stocks
that have the same symbol as a currency.
_______________________________________________
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.
