How to Track NPS NAV on Microsoft Excel

Tracking the latest NAV of your NPS fund in Microsoft Excel is simple. By using the WEBSERVICE function, you can pull real-time NAV data directly into your spreadsheet. Here’s how to do it:

Step 1: Use the WEBSERVICE Function

Microsoft Excel offers the WEBSERVICE function, which allows you to fetch external data using a URL. This feature is perfect for tracking NPS NAV data.

=WEBSERVICE("https://npsnav.in/api/SchemeCode")

Replace SchemeCode with the actual code of the NPS fund you want to track.

List of all available NPS schemes can be accessed here.

Example:

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

Step 2: Calculate the Value of Your NPS Portfolio

Once you have the current NAV, you can calculate the value of your NPS portfolio by multiplying the NAV by the number of units you hold.

Example Calculation:

=WEBSERVICE("https://npsnav.in/api/SchemeCode") * 268

Make sure you input the correct scheme code and the number of units you hold in that particular NPS fund.

Step 3: Ensure You Choose the Right Fund

There are multiple NPS schemes under various tiers and schemes. Ensure that you choose the right fund as per your portfolio. You can find the complete list of scheme codes here.

Example NPS Portfolio on Microsoft Excel

Below is an example screenshot of how a sample NPS portfolio looks on Microsoft Excel:

Microsoft Excel NPS NAV Example

Trouble tracking NPS NAV on Microsoft Excel? Create an issue or contact us.