What do IN9999999999, SYN and DUM codes mean in mutual fund portfolio files?

They are not all ISINs. Fund house portfolio files mix real ISINs with codes that only look like them. In the TigZig holdings file, the isin_type column says what each code in the isin column is.

The original is kept. The ISIN and the name exactly as the fund house filed them are in isin_as_filed and instrument_name_as_filed, so you can always go back to the filing.

Every mapping in one file. mf_portfolio_isin_mappings.csv has one row per ISIN as filed: the code it is grouped or remapped under, the reason, the first and last month it appears and the number of funds that hold it. It covers corporate actions and the CDs, CPs, T-bills and government securities grouped per issuer.

Holdings file: mf_portfolio_holdings.csv. Rules: the methodology page. Related: why a holding can change when the fund did not trade and how to join the holdings to fund size data.

Building something like this? How I work covers the rates, the availability and what I take on.

← All Agents FAQ