Identifying Warrants and Their Terms from ISINs

Summary

The document describes how to identify the underlying asset, strike, and maturity of French traded warrants when only their ISINs are available. Its suggested workflow uses Bloomberg: look up the ISIN in the terminal to open the security record, then view its descriptive details. For spreadsheet users, Bloomberg’s data API can return instrument fields, including the underlying ticker, while the terminal’s field search helps locate fields for maturity and other terms.

This is a practical data-retrieval method rather than an explanation of warrant valuation or trading. It assumes access to Bloomberg and does not compare alternative datasets, discuss coverage or licensing, or explain how to validate returned terms against an exchange or issuer source. The example illustrates the lookup process, but the particular field names and interface may vary by instrument and platform version.

Key ideas

• An ISIN can be used to open a warrant’s security record in a market data terminal.
• The security description can provide the underlying, strike, and maturity details.
• A spreadsheet data API can retrieve instrument fields such as the underlying ticker.
• Field search tools help identify the relevant API fields for other terms.
• The approach assumes access to Bloomberg and does not assess other data sources.

Tags

# finding the strike / maturity of warrants given their ISINs


# finding the strike / maturity of warrants given their ISINs












I have a list of French traded warrants identified by their ISINs. I do not know, however, to which stock they refer and what is their strike/maturity.

Which datasets allow me to retrieve this information?

Many thanks!

## Answer by assylias (score 0, accepted)

https://quant.stackexchange.com/a/14953

You used the Bloomberg tag so I will assume that you have access to a Bloomberg terminal.

Let's say your ISIN is `FR0011671296`.

- In the terminal, you can type: `ID <Go>` then type the ISIN and the security's page will open. You can then type `DES <Go>` to see the details.

- If you are in Excel, you can use the API. For example to get the underlying you would use: `=BDP("FR0011671296 ISIN", "OPT UNDL TICKER")`. To find other fields, the best way is to go back to the terminal and type, for example, `FLDS MATURITY <Go>` and you will see a list of related fields that you can use in Excel.

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.