--- title: "Pulling Indian Mutual Fund NAVs One Scheme at a Time? Three Ways to Get the Same Data in Far Fewer Calls." slug: mfpro-nav-fewer-calls-batch-files-parquet-aug2026 date_published: 2026-08-13T06:30:00.000Z original_url: https://www.tigzig.com/post/mfpro-nav-fewer-calls-batch-files-parquet-aug2026 source: fresh processed_at: 2026-08-13T06:30:00.000Z --- # Pulling Indian Mutual Fund NAVs One Scheme at a Time? Three Ways to Get the Same Data in Far Fewer Calls. If you are pulling Indian mutual fund NAVs from the MFPro API one scheme at a time, there are three ways to get the same data in far fewer calls, and all three are already in the API. - You can batch up to 50 schemes in a single call, and you can pass a date range along with it, so a handful of calls will usually cover what you would otherwise do in a few thousand. - If you want the current position across the whole universe, there is one file with the latest NAV for every scheme, around 38,000 of them. A good share of those are closed or matured schemes, and I have left them in rather than deciding on your behalf what counts as live, so you can filter down to the active ones yourself. - And if you want the full daily history for everything, that is one file as well, a little over 37 million records going back to April 2006. All updated 3x a day. Docs are at [tigzig.com/apis/mf-nav](https://www.tigzig.com/apis/mf-nav). ## What the docs cover, if you are deciding between the three If you are deciding between the three, the docs go into the detail. The data dictionary lists every field in both files, how the data is built covers the sources and the three-times-a-day sync, and there is now a guides and FAQ page that collects the questions that come up most, including why a lookup returns nothing and why an AUM figure can look lower than the number published elsewhere. All of it sits under Docs on the MFPRO App: [tigzig.com](https://www.tigzig.com) -> MFPRO And every page has a plain markdown version if you would rather hand it to an AI agent than read it yourself. ## A fourth way, if you do not want the file on disk at all And there is a fourth way if you do not want the file on disk at all. The full history file is parquet, and parquet supports range requests, so DuckDB or Polars can query it straight off the URL and pull only the bytes they actually need. Counting all 37 million rows moved under half a megabyte, and pulling one fund's complete history moved about 1.3 megabytes, out of a file of roughly 175 megabytes. Detailed writeup here: [Range requests on the MFPRO NAV file](https://www.tigzig.com/post/mfpro-range-requests-duckdb-polars-aug2026) ## Putting some numbers on it To put some numbers on it, if you want every active fund's latest NAV each morning, that is about 8,600 schemes. One at a time is 8,600 calls, batched at 50 it comes down to about 172, and the latest file is a single request, roughly 10 MB as CSV or about 1 MB if you take the gzipped version. The data is the same in all three cases. ## What counts as active, and how to check whether anything changed On active, I work it out from the data, and a scheme counts as active if it has reported a NAV in the last 45 days. I kept that window much wider than it needs to be as a buffer and you can apply a further cut based on the nav date. And if you are checking each day whether anything has changed, the files and the manifest both support conditional requests, so if you send `If-None-Match` or `If-Modified-Since` with what you already have you get a 304 back with no body at all, and you only pull the file on the days there is something new in it. ## Related Tools: [MFPRO - Mutual Fund Analytics](https://www.tigzig.com/mfpro), [MF File Converter](https://www.tigzig.com/mf-files-ai), [DUCKIT - CSV to DuckDB](https://www.tigzig.com/duckit-xlwings) Explore: [MF NAV API docs](https://www.tigzig.com/apis/mf-nav), [API and MCP catalog](https://www.tigzig.com/apis), [Claude for Analytics hub](https://www.tigzig.com/claude-for-analytics) More posts: [Range Requests on the MFPRO NAV File Are Fixed. DuckDB and Polars Queries No Longer Get Refused Midway.](https://www.tigzig.com/post/mfpro-range-requests-duckdb-polars-aug2026), [MF NAV API FAQ. Why Am I Getting an Error, Why Is There No SIF NAV, and Why Does the AUM Look Wrong?](https://www.tigzig.com/post/mf-nav-api-faq-aug2026), [MFPRO Mutual Fund API: Search Now Filters Across 12 Fields on a Scheme](https://www.tigzig.com/post/mfpro-search-filters-12-fields-jul2026), [Demystifying TIGZIG API Errors: A Practical Guide for MFPRO, TREMOR, and VIGIL Users](https://www.tigzig.com/post/tigzig-api-errors-practical-guide-jul2026) --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/mfpro-nav-fewer-calls-batch-files-parquet-aug2026 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