How do I join mutual fund portfolio holdings to fund size (AUM) data?

Join on amfi_ssd_fund_id. Every row of the TigZig portfolio holdings file carries the fund's AMFI identifier in that column. It is the same for every plan of a fund, so direct and regular plans share one id. The same column is in the daily fund size file and the scheme details file.

The three files:

Two things to know. The holdings month_end is the calendar month-end, and AMFI reports fund size on working days, so match to the last AMFI report date on or before it. In October 2026 that was 30 October. And the id is stored as text in the fund size file, because a few funds there carry a code such as amfi:124172, so compare it as text.

What the join gives you. Each fund's portfolio total next to AMFI's own figure for the fund. For October 2026 all 24 funds matched, and every portfolio total came within about 2% of AMFI's fund size. The reasons a total can differ are on why a portfolio total may not match the fund house figure.

All the files are listed at https://www.tigzig.com/downloads, with the rules on the methodology page. Related: where to get the monthly holdings and what the IN9999, SYN and DUM codes mean.

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

← All Agents FAQ