Eikon "get_data" generates tons of duplicates

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?

Find more posts tagged with

python

eikon

data

Download

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

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'])

All comments

chavalit-jintamalit

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'])

User73

Thank you very much for the answer! Is there a way to simply retrieve the required data without accounting for the 'calcdate' variable in order to avoid downloading the duplicates?

EXPLORE OUR SITES