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?
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It only takes a minute to sign up.Sign up to join this community
You used the Bloomberg tag so I will assume that you have access to a Bloomberg terminal.
Let's say your ISIN is
ID <Go>then type the ISIN and the security's page will open. You can then type
DES <Go>to see the details.
=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.