How to use Excel to convert from an ISIN or CUSIP to a stock ticker

Today we released a small but very important new feature: a set of new formulas to convert commonly used financial instrument identifiers, such as a CUSIP or ISIN, to a ticker.

This has been a recurring request ever since we launched Excel Price Feed. Often a user is given a spreadsheet with a bunch of ISIN codes and wants to connect those with our live pricing formulas. The problem is that these formulas require a ticker not an ISIN.

What makes this now possible?

FIGI (Financial Instrument Global Identifier)

What is FIGI you may ask?

Well FIGI is an attempt to produce an open standard for financial identifiers, and part of that effort has produced a service that describes the links between different types of codes.

We have now integrated this into our software so conversion formulas are readily available in Excel:

For example, to convert an ISIN (US4592001014) to a ticker (IBM) this simple Excel formula can be used:


And to convert a CUSIP to a ticker, well that is very simple too:


To find out more about Excel Price Feed head over to the website and try it free for 10 days:

4 thoughts on “How to use Excel to convert from an ISIN or CUSIP to a stock ticker

  1. Thomas F January 12, 2023 / 4:11 pm

    wel that did not work.


    • andysinclair January 13, 2023 / 6:29 pm

      Hi Thomas, Sorry to hear that the formula is not working for you. Can you send me your spreadsheet and I can take a look?: Please send it to the team at
      Thanks, Andy


  2. vincent March 8, 2023 / 6:38 pm

    doesnt work for me either. downloaded the add-in, selected it in excel and used the formula but nothing shows. Is there another step that’s not explained?


    • andysinclair March 17, 2023 / 8:48 am

      Hi, thanks for your comment. Can you send me the formula or spreadsheet you are trying to use and I can investigate further? Either post the formula here, or send it to:,


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s