India's ISIN Dataset

Project Showcase
1

I came across ISINs when I started to manage my finances in beancount, and realized I could specify all my trading in plain text transactions using ISINs as the identifier for the mutual fund - ended up writing a beancount plugin that fetched information from Kuvera using a user-supplied ISIN->KuveraID mapping.

However, that led me down a rabbit hole of ISINs, and I came out the other side with a small scraper that fetched all valid ISINs from the NSDL website.

The dataset and scraper code is here: https://github.com/captn3m0/india-isin-data. From all my research, I’m fairly confident that my README is most detailed and accurate description of ISIN code structures in India. You can browse the data online easily at https://flatgithub.com/captn3m0/india-isin-data

Each release is automatically tagged on GitHub, and a human-readable changelog is generated alongside: https://github.com/captn3m0/india-isin-data/releases

I don’t really have any use for this dataset. If anyone does think of one, I’d be happy to hear :slight_smile:

There is some WIP to host the data on a lookup API as well (using Fly.io)

1 Like
2

Nice…
Such a professional (proper format, attribution, license, links) and sustainable (automation) effort. :clap:

Out of curiosity, how does this list compare to the list available at -
NSDL / Company Search / Securities with ISIN Codes.

For example, today’s list at the above page has 93,757 ISINs.

What’s missing in it compared to the one you have scraped together? (eg. expired/deleted ISINs?) :thinking:

3

PS: Not sure if you are open to PRs yet.
Nevertheless, here’s one github.com/captn3m0/india-isin-data/pull/9 :wink:

4

Somehow I’d never seen the CSV from the NSDL website :man_facepalming:. There are some differences however:

  1. The official CSV contains a few undocumented prefixes that I hadn’t seen before (INY, IN5-9) so that adds some 7k odd ISINs. These can be accounted for fairly easily.
  2. My dataset does include Expired/Blocked/Suspended ISINs, so that’s one important difference as you pointed out.
  3. The official CSV doesn’t include the majority of Government Securities (even active ones). For eg IN4920200099. My dataset has roughly 4.5k active Government Securities, so this might be an important difference for now.
  4. The official dataset does include pricing information, so it might be worth incorporating regardless.

Nevertheless, here’s one github.com/captn3m0/india-isin-data/pull/9 :wink:

Thanks, merged

5

This is amazing. I was trying to look at ISIN data for structured / historic government debt levels and especially state governments, given how that data isn’t available in analysis / visualization friendly format. The idea was to get a realtime snapshot of post-poll-time stat that “X regime dumped so much loan on each of you”

1 Like
6

As a minor update, I went ahead and made a real API of the Mutual Fund data that I was using earlier for my finances: mf.captnemo.in ([Source]). Uses the Kuvera API and AMFI data, and updates automatically to get you NAV and other information.

Same response: https://mf.captnemo.in/nav/INF843K01FC8, https://mf.captnemo.in/kuvera/INF843K01FC8.

I’d seen some other public APIs for this, but nothing that used ISINs.