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.
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
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