My Quicken File is full of duplicate securities spanning nearly the entire alphabet. The duplicates all have the same symbol. For example, AUTODESK INC and AUTODESK INC COM. I know I can merge these securities. But I have 1249 securities Quicken is tracking (for whatever reason… maybe every stock I've ever held at any time?). When I go to merge, one, with years of history, says the two have different values on 118 days. I'm not too torn up over that (though it would be very hard to find the days where they differ so I just hope it is due to small decimal rounding).
Is there an automated way to clean these up? If not, which should I choose? Should I keep ASTRAZENECA ADR REP 0.5 ORD or ASTRAZENECA ADR REP 0.5 ORD (AZN)? They both show with the same ticker? And how can I prevent new securities with existing tickers being created, just because the security label name has a cosmetic change on a future download?