NPS Fund NAV API Documentation

Effortlessly access the latest Net Asset Values (NAVs) of India's National Pension Scheme (NPS) funds with our lightweight and easy-to-use API. Integrate real-time NAV data into your Google Sheets, Microsoft Excel, or any financial planning tool.

API Playground

1. Schemes API

Fetch the list of all available NPS scheme codes along with their scheme names. This endpoint is useful for discovering valid scheme_code values before using other APIs.

Endpoint:

https://npsnav.in/api/schemes

Response Example:

{
  "data": [
    ["SM001001", "SBI PENSION FUND SCHEME - CENTRAL GOVT"],
    ["SM001002", "SBI PENSION FUND SCHEME - STATE GOVT"],
    ["SM008001", "HDFC PENSION FUND SCHEME E - TIER I"]
  ],
  "metadata": {
    "count": 151,
    "lastUpdated": "22-12-2025"
  }
}

Tip: Use this endpoint to programmatically discover scheme codes instead of hardcoding them or parsing the latest NAV endpoint.

2. Simple API for NAV

Fetch the raw NAV value for any individual NPS fund using its unique scheme code. This returns plain text, perfect for spreadsheet formulas.

Examples

Integration Guides

Google Sheets (using IMPORTDATA):
=IMPORTDATA("https://npsnav.in/api/SM001001")

Full Google Sheets Guide →

Microsoft Excel (using WEBSERVICE):
=WEBSERVICE("https://npsnav.in/api/SM001001")

Full Microsoft Excel Guide →

Need a scheme code? Use the Schemes API or view the full list of NPS funds.

3. Get Latest NAV for All Funds

Fetch the most recent NAV values for every NPS fund in a single request.

Option A: Detailed Format

Returns PFM Name, Scheme Name, NAV, and Last Updated Date.

Endpoint:

https://npsnav.in/api/latest

Response Example:

{
  "data": [
    {
      "PFM Code": "PFM001",
      "PFM Name": "SBI PENSION FUNDS PRIVATE LIMITED",
      "Scheme Code": "SM001001",
      "Scheme Name": "SBI PENSION FUND SCHEME - CENTRAL GOVT",
      "NAV": "46.7686",
      "Last Updated": "01-10-2024"
    }
  ],
  "metadata": {
    "currency": "INR",
    "dataType": "NAV",
    "count": 151,
    "lastUpdated": "01-10-2024"
  }
}

Option B: Minimal Format

A lighter, faster version containing only Scheme Code and NAV.

Endpoint:

https://npsnav.in/api/latest-min

Response Example:

{
  "data": [
    ["SM001001", 46.7686],
    ["SM008001", 93.4021]
  ],
  "metadata": {
    "count": 151,
    "lastUpdated": "01-10-2024"
  }
}

4. Detailed Fund Data (With Returns)

Get performance metrics including 1-day to 5-year returns for a specific fund.

Endpoint:

https://npsnav.in/api/detailed/SM001001

Response Example:

{
  "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"
}

5. Historical NAV Data

Access past NAV values to track the historical performance of your investments.

Endpoint:

https://npsnav.in/api/historical/SM001001

Response Example:

{
  "data": [
    {
      "date": "01-10-2024",
      "nav": 46.7686
    },
    {
      "date": "30-09-2024",
      "nav": 46.7231
    }
  ],
  "metadata": {
    "currency": "INR",
    "dataType": "NAV",
    "lastUpdated": "01-10-2024"
  }
}

Historical Data in Spreadsheets

Additional Resources

Why Use NPSNAV.in API?

  • Versatile: Plain text, JSON, and historical data options.
  • Integrations: Built for Google Sheets and Excel functions.
  • Up-to-Date: Real-time synchronization with fund updates.