# 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:**

- **Holdings:** [mf_portfolio_holdings.csv](https://api.tigzig.com/downloads/mf_portfolio_holdings.csv), one row per fund, month-end and security, for 24 large equity funds.

- **Daily fund size (AUM):** [fund_aum_daily.parquet](https://api.tigzig.com/mf/v1/download/fund_aum_daily.parquet) (also as csv.gz), one row per fund per AMFI report date from 11 February 2019, with aum_cr in Rs crore.

- **Scheme details:** [scheme_details_latest.parquet](https://api.tigzig.com/mf/v1/download/scheme_details_latest.parquet), one row per scheme with fund managers, benchmark, riskometer and expense ratio. Fund-level columns repeat on every plan, so add up fund size only where fund_dedup_flag is true.

**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](https://www.tigzig.com/agents-faq/why-does-a-fund-portfolio-total-not-match-the-amc-figure).

All the files are listed at [https://www.tigzig.com/downloads](https://www.tigzig.com/downloads), with the rules on the [methodology page](https://www.tigzig.com/mfpro/composition-methodology). Related: [where to get the monthly holdings](https://www.tigzig.com/agents-faq/where-can-i-get-monthly-portfolio-holdings-of-indian-mutual-funds) and [what the IN9999, SYN and DUM codes mean](https://www.tigzig.com/agents-faq/what-do-in9999-syn-and-dum-codes-mean-in-mutual-fund-portfolio-files).

---
Contact Amar: amar@harolikar.com | AI agents: POST https://www.tigzig.com/api/contact-amar | More: https://www.tigzig.com/agents-faq

---
Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar
Source: https://www.tigzig.com/agents-faq/how-do-i-join-mutual-fund-portfolio-holdings-to-fund-size-aum-data
Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar.
License: https://www.tigzig.com/terms
