« How much time and interest do you save if you pay off your home loan using a step-up EMI? What happens to your mutual fund portfolio final value if you choose to buy a house? »

How to use Arthgyaan API to get NPS NAV to calculate your NPS corpus value?

Posted on 05 May 2024
Author: Sayan Sircar

Tags: Market Data ; NPS

4 mins read
📢Join 2400+ readers on WhatsApp and get new post notifications!

This article helps you get NPS NAV data via an easy to use API so that you can easily calculate, using Excel or Google Sheets, how much money you have in NPS.

How to use Arthgyaan API to get NPS NAV to calculate your NPS corpus value?

Disclaimer: The data provided by this API is not guaranteed to be complete, accurate, or delivered in a timely manner. No warranties are made regarding the reliability or suitability of the data for any purpose. This API is subject to rate limitations and is not intended for use in production environments. Commercial usage of the API is not permitted.

What is the NPS NAV API?

NPS NAV is available for download from the NSDL site but that is not easy to use in case you wish to track your NPS portfolio via Excel or Google Sheets. This API allows you to get the latest NPS NAV for the NPS funds where you have invested.

How to use the API?

In the examples below, we will use the example of the fund

SBI PENSION FUND SCHEME E - TIER I which has the ID sm001003.

The NAV for this fund as available by hitting this endpoint: https://arthgyaan.com/api/nps/

If you use the example id, then the query https://arthgyaan.com/api/nps/sm001003/nav.json will give you the NAV 52.7932.

You can then setup a table like this to track your NPS portfolio in Excel or Google Sheets:

Fund	Units (a)	Fund ID	NAV (b) from API	Value(a x b)
Tier 1 E	10000	sm001003	₹52.7932	₹527932.0
Tier 1 G	5000	sm001005	₹36.8006	₹184003.0
Tier 1 C	2000	sm001004	₹39.379	₹78758.0

The units figure comes from your NPS statement that you will get periodically via email.

Excel

If you are an Excel user, the you can use the WEBSERVICE function (Excel 2013 or later in Windows) like this in a cell to get the NAV:

=CHOOSECOLS ( TEXTSPLIT ( WEBSERVICE( "https://arthgyaan.com/api/nps/sm001003/nav.json") ,"""") ,4 ) +0

Excel will pop-up a warning about using the WEBSERVICE function to fetch live data from the Internet for the first time.

Excel Warning

If you get this pop-up, especially if you paste the formula above, please click “Paste everything” to continue.

For the name of the fund, use this:

=CHOOSECOLS ( TEXTSPLIT ( WEBSERVICE( "https://arthgyaan.com/api/nps/sm001003/name.json") ,"""") ,4 )

Google Sheets

If you are a Google Sheets user, the you can use the IMPORTDATA function like this in a cell to get the NAV:

=CHOOSECOLS (SPLIT ( IMPORTDATA( "https://arthgyaan.com/api/nps/sm001003/nav.json") ,"""") ,4 )+0

Here, Google Sheets will give an error pop-up on the top of the screen the first time you use this function. Please click “Allow Access” to continue.

Google Sheets Warning

For the name of the fund, use this:

=CHOOSECOLS (SPLIT ( IMPORTDATA( "https://arthgyaan.com/api/nps/sm001003/name.json") ,"""") ,4 )

To understand how to use this API for tracking your NPS corpus:

Arthgyaan Goal-based investing calculator

Easiest Way of Tracking Your NPS Portfolio

The easiest solution for getting the latest value of your NPS portfolio is to use the portfolio tracker function of the the Arthgyaan goal-based investing tool. There is no charge for using the portfolio tracking feature. All you have to do is enter the NPS fund ID in column E and the number of units you hold in column G.

We will use Google sheets to create a simple calculator for this calculation. There is a link to download a pre-filled copy of the Google sheet via the button below.

Important: You must be logged into your Google Account on a laptop/desktop (and not on a phone) to access the sheet.

Please refer to the “assets” tab of the sheet once you open it.

Of the three options, Excel, Google Sheets and the Arthgyaan Goal-based investing calculator, the Arthgyaan tool is easiest to setup and use. Apart from NPS, you can track your Indian mutual funds as well as any stock whose price comes from the Google Finance API.

Did you know that we have a private Facebook group which you can join for free and ask your own questions? Please click the button below to join.

Where to get the NPS Fund IDs?

The API needs the NPS fund ID to get the NAV.

Please refer to this article for the IDs of your NPS funds and, for reference, the latest NPS NAVs: Latest NAVs - National Pension System (NPS)

What's next? You can join the Arthgyaan WhatsApp community

You can stay updated on our latest content and learn about our webinars. Our community is fully private so that no one, other than the admin, can see your name or number. Also, we will not spam you.

To understand how this article can help you:

If you have a comment or question about this article

The following button will open a form with the link of this page populated for context:

If you liked this article, please leave us a rating

The following button will take you to Trustpilot:

Discover an article from the archives

Previous and next articles:

<p>This article shows how quickly you can pay off your home loan, and even save a lot of interest, by increasing your EMI steadily year-on-year.</p>

House Purchase Loans

How much time and interest do you save if you pay off your home loan using a step-up EMI?

This article shows how quickly you can pay off your home loan, and even save a lot of interest, by increasing your EMI steadily year-on-year.

Published: 1 May 2024

12 MIN READ

<p>This article shows how to understand the impact on your portfolio if you stop investing for a few years between today and retirement to buy a house.</p>

House Purchase Mutual Funds

What happens to your mutual fund portfolio final value if you choose to buy a house?

This article shows how to understand the impact on your portfolio if you stop investing for a few years between today and retirement to buy a house.

Published: 8 May 2024

3 MIN READ

Latest articles:

<p>This article provides a clear guide to navigating the insurance requirements when securing a home loan, helping you make informed decisions.</p>

House Purchase Loans Insurance

Understanding Insurance Requirements for Home Loans in India: What's Mandatory and What's Optional?

This article provides a clear guide to navigating the insurance requirements when securing a home loan, helping you make informed decisions.

Published: 15 May 2024

3 MIN READ

<p>This article discusses the steps for investors in high-income brackets but hesitant to commit to a home loan due to the fear of job instability.</p>

Behaviour House Purchase Loans

How to manage a home loan if you are worried about job loss?

This article discusses the steps for investors in high-income brackets but hesitant to commit to a home loan due to the fear of job instability.

Published: 14 May 2024

8 MIN READ

Topics you will like:

Asset Allocation (21) Basics (8) Behaviour (13) Budgeting (12) Calculator (25) Case Study (6) Children (17) Choosing Investments (40) FAQ (12) FIRE (13) Gold (22) Health Insurance (5) House Purchase (33) Insurance (17) International Investing (12) Life Stages (2) Loans (20) Market Data (8) Market Movements (17) Mutual Funds (47) NPS (8) NRI (19) News (18) Pension (8) Portfolio Construction (53) Portfolio Review (27) Reader Questions (8) Real Estate (7) Research (5) Retirement (38) Review (16) Risk (6) Safe Withdrawal Rate (5) Set Goals (28) Step by step (15) Tax (59)

Next steps:

1. Email me with any questions.

2. Use our goal-based investing template to prepare a financial plan for yourself.

Don't forget to share this article on WhatsApp or Twitter or post this to Facebook.

Discuss this post with us via Facebook or get regular bite-sized updates on Twitter.