'extract the content of the Most Traded Options API for a given underlying.

hello I would like, if possible through Eikon Excel functions or through VBA Adfins or EIkon Data API to 'extract the content of the Most Traded Options API for a given underlying. thank you in advance for your feedback

Find more posts tagged with

python

eikon

derivatives

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

@Marwa.Mastouri

The only way I know to get the most traded options is to retrieve the entire options chain and sort it by volume. E.g. the code snippet below returns 5 options on IBM with the highest traded volume for the day.

df, err = ek.get_data('0#IBM*.U',['DSPLY_NAME','ACVOL_1'])
df.drop(0, inplace = True)
df.sort_values('ACVOL_1', inplace = True, ascending = False)
df.head()

All comments

Alex Putkov.1

@Marwa.Mastouri

df, err = ek.get_data('0#IBM*.U',['DSPLY_NAME','ACVOL_1'])
df.drop(0, inplace = True)
df.sort_values('ACVOL_1', inplace = True, ascending = False)
df.head()

EXPLORE OUR SITES