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.

1. 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 code? View list of all NPS funds and scheme codes.

2. 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"
  }
}

3. Detailed Fund Data (With Returns)

Get performance metrics including 1-day, 1-month, 1-year, 3-year, and 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"
}

4. 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.