Finding European Equity Option Listings in Bloomberg

# Where can I find data about Options for Europe (entire dataset)?


# Where can I find data about Options for Europe (entire dataset)?












I need to get data about the entire dataset (i.e. all) of options for European countries. Where can I do that? For example, if I had to do it for US options, I would just use WRDS (to which I have access through my institution) and simply use the query "search entire dataset"). For European data I have access to Eikon Thomson Reuters and Bloomberg, but no such option is available (not even going trhough Eikon API using Python). Moreover, I don't have access to OptionMetrics for Europe. What are the options left instead of split the data in a huge number of small chunks and then downlaoding what needed? What I really need is just a list of the options, not necessarily the data themselves.

## Answer by David Duarte (score 0, accepted)

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

May not be exactly what you are looking for but in Bloomberg you can use the securities finder (`SECF <GO>`) to get European equities with options.

- Choose "Equities" as the category

- Go to the "Equity Options" tab, or any other (Index Options or Options on Eqty Future)

- Filter by Currency, Exchange or whatever you want

- Click the export button to download the list to excel

You might not get all that you want in a single go, but you can download lots of information on equities with options

Then you can use python to loop through all the equity tickers and extract the option chain.

There are several wrappers for the `blpapi`. I usually use `pybbg`. Try something like this:

```
import pybbg
bbg = pybbg.Pybbg()

stocks = [
    "FP FP Equity",
    "ATL IM Equity",
    "RNO FP Equity",
    "MC FP Equity",
    "AIR FP Equity",
    "ASML NA Equity"
]

options = []
for stock in stocks:
    chain = bbg.bds(stock, "OPT_CHAIN")
    options.append(chain)
```

However, be aware of your data limits as querying all the the data for European options will most certainly pass your daily limit