Based on an earlier interaction we have had about this issue with Thomson, we were told that the best way to handle these duplicates with the same DCN and SEQNUM is to keep the observation with the latest maintenance date. This is due to insiders filing amendments to the information they had filed before. You might also want to use the amendment indicator to check whether you are dealing with amended filings.
Articles in this section
- Thomson Reuters Role Codes
- First Call: Inclusion of Conference Call Data
- "Target Price" Data removed from WRDS
- Thomson Reuters Cleanse Codes
- Handling Observations with the Same DCN and SEQNUM
- Thomson-Reuters Mutual Fund Holdings: Net Asset Values (NAV) for Closed-end Funds
- What is PERMKEY in Thomson Reuters Ownership Datasets (Thomson Institutional 13f, or Mutual Funds)?
- Do you have institutions declaring their bond ownership in the 13f data?
- I read in a paper that the authors obtained Price Target from First Call for the period 1996 to 2000. Is this data in the First Call or IBES databases on WRDS? DUPLICATE
- I find cases in the Thomson (Thomson Reuters) institutional holdings data where the total number of shares held by institutions for a company exceeds the total number of shares outstanding for that company. Why?