Eikon "get_data" generates tons of duplicates

User73
User73 Newcomer
in Eikon Data APIs

I want to retrieve the analyst reccomendation data for a series of stock in a period of time. The code looks like the following:

a, b = ek.get_data('AAPL.O', ['TR.RecEstValue(SDate=1983-01-01, EDate=2021-01-09)',

'TR.RecEstValue(SDate=1983-01-01, EDate=2021-01-09).confirmdate',

'TR.RecEstValue(SDate=1983-01-01, EDate=2021-01-09).brokername',

'TR.RecEstValue(SDate=1983-01-01, EDate=2021-01-09).analystname'])


However, what I get is a huge time dataframe with hundreds of thousands of rows, most of which are simply duplicates. Indeed, dropping all the duplicates the dataframe reduces to few hundreds of rows.

How can I solve this problem?

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    Hi @User73

    FIrst of all, please review API limitation guideline at https://developers.refinitiv.com/eikon-apis/eikon-data-api/docs

    And please do not try to retrieve a very large amount of data in a single API call.

    For the duplicate? question, in fact, there is a property called "calcdate" which is a unique value of each unique data.

    a, b = ek.get_data('AAPL.O', ['TR.RecEstValue(SDate=2020-11-01, EDate=2021-01-09)',
    'TR.RecEstValue(SDate=2020-11-01, EDate=2021-01-09).calcdate',
    'TR.RecEstValue(SDate=2020-11-01, EDate=2021-01-09).confirmdate',
    'TR.RecEstValue(SDate=2020-11-01, EDate=2021-01-09).brokername',
    'TR.RecEstValue(SDate=2020-11-01, EDate=2021-01-09).analystname'])


    image

Answers

Categories