Security Master And Symbology

Map ticker, CIK, ISIN, FIGI, SEDOL and CUSIP on (identifier, DATE) rather than on identifier, and detect when the entity behind one changed. TRIGGER - ticker to CIK, ISIN to CUSIP, FIGI, SEDOL, ISIN or CUSIP check digit, identifier validation; a reused ticker, a renamed company, a merger or ticker change breaking a join; security master, symbology, cross-reference table, PERMNO, entity resolution; "the fundamentals attached to the wrong company"; building a universe from company_tickers.json. Load before any join keyed on a symbol - an identifier is not an entity, neither is stable, and the SEC's own name windows both overlap and leave gaps. SKIP for FINDING an identifier you do not have yet (finding-and-searching-data), for split/dividend adjustment and delisted price history (market-data-sourcing), for the point-in-time vintage of the fundamentals (fundamental-and-macro-data), for auditing a finished result (research-integrity-guards), and for A-share code changes (china-ashare-data).

howard-lynn-ye Updated 1 repo stars

File contents

howard-lynn-ye/fin-skills commit d991f10d2c

Frequently asked questions

npx get-skill add howard-lynn-ye/security-master-and-symbology