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:
=EPF.ID.ISIN.To.Ticker("US4592001014")And to convert a CUSIP to a ticker, well that is very simple too:
=EPF.ID.CUSIP.To.Ticker("037833100")To find out more about Excel Price Feed head over to the website and try it free for 10 days: https://www.excelpricefeed.com/
The Excel Price Feed Blog 
wel that did not work.
LikeLike
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 hello@coderun.net
Thanks, Andy
LikeLike
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?
LikeLike
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: hello@coderun.net,
Thanks
Andy
LikeLike