NPS Fund NAV API – Track the Latest NAV of National Pension Scheme Funds
Effortlessly access the latest Net Asset Values (NAVs) of India's National Pension Scheme (NPS) funds with our lightweight and easy-to-use API. The site currently provides three types of API: Simple API for NAV, Detailed API, and Historical API. Integrate real-time NAV data into your Google Sheets, Microsoft Excel, or any financial planning tool.
Simple API for NAV
You can fetch NAV values for any NPS fund using its unique scheme code. Check out these examples:
- SBI Pension Fund Scheme NAV: https://npsnav.in/api/SM001001
- UTI Retirement Pension Fund Scheme NAV: https://npsnav.in/api/SM001002
- HDFC Pension Scheme E NAV: https://npsnav.in/api/SM008001
How to Track NAV in Google Sheets
Easily track the latest NAV of NPS funds in Google Sheets by using the IMPORTDATA
function:
=IMPORTDATA("https://npsnav.in/api/SM001001")
Learn more about integrating NPS NAV into Google Sheets
How to Track NAV in Microsoft Excel
For Microsoft Excel users, use the WEBSERVICE
function to fetch NPS NAV data directly:
=WEBSERVICE("https://npsnav.in/api/SM001001")
Access Detailed NPS Fund Data
Use the detailed API to get more information about each NPS fund, including its NAV and other performance data. Here's an example:
Example Query
https://npsnav.in/api/detailed/SM001001
Example Result
{ "Last Updated": "01-10-2024", "PFM Code": "PFM001", "PFM Name": "SBI PENSION FUNDS PRIVATE LIMITED", "Scheme Code": "SM001001", "Scheme Name": "SBI PENSION FUND SCHEME - CENTRAL GOVT", "NAV": "46.7686", "1D": "0.10", "7D": "0.13", "1M": "1.34", "3M": "3.51", "6M": "6.73", "1Y": "13.98", "3Y": "8.16", "5Y": "9.23" }
This API returns detailed information, such as 1-day, 7-day, 1-month, 3-month, 6-month, 1-year, 3-year and 5-year returns.
Access Historical NPS Fund NAV Data
Our historical API allows you to access past NAV values of NPS funds. Use this API to track the historical performance of your investments. Here's an example:
Example Query
https://npsnav.in/api/historical/SM001001
Example Result
{ "data": [ { "date": "01-10-2024", "nav": 46.7686 }, { "date": "30-09-2024", "nav": 46.7231 } ], "metadata": { "currency": "INR", "dataType": "NAV", "lastUpdated": "01-10-2024" } }
Track daily historical NAV performance of any NPS fund for smarter financial planning.
Full List of NPS Scheme Codes
To explore all available NPS funds, visit the full list of scheme names and their codes: View NPS Scheme Codes
Why Use NPSNAV.in API?
- Versatile API Options: Access multiple API types—simple text-based NAV values, detailed fund data, and historical NAV performance—all tailored to meet different needs.
- Easy Integration: Our APIs are designed for seamless integration with tools like Google Sheets, Excel, or any financial application.
- Comprehensive Data: From real-time NAV updates to detailed fund performance and historical data, our APIs cover all aspects of NPS fund tracking.
- Unlimited Usage: No restrictions or usage limits—use the API as much as needed, without sign-ups or registrations.
- Always Up-to-Date: We strive to provide the most up-to-date NAV data compared to other sites, ensuring that you have the latest information for smarter financial planning.