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

Marwa.Mastouri
Marwa.Mastouri
in Eikon Data APIs

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

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    @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()

Categories