How to use get_data with RIC, date combinations?

Hi all,

I imported a dataframe with RICs and dates. Now I would like to use get_data to retrieve market capitalization for all RICs at the specific dates. Is that possible with python eikon api?

Dataframe looks like this:

I tried the following :

idfy = pd.read_csv(\distcompfy.csv', encoding='utf-8')
mc, err =ek.get_data(list(idfy['RIC']), fields = ['TR.CompanyMarketCap.date', 'TR.CompanyMarketCap.value' ] , parameters={'Scale': 6, 'Curn': 'USD', 'SDate': list(idfy['date'])})

But Python returns: "Error code 400 | Backend error. 400 Bad Request"

Is there a way to retrieve the data?

Best

Simon

Find more posts tagged with

python

eikon

data

time-series

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @sile

The problem is on the list of date in parameters.

You cannot make a request with SDate as a list.

If you want a range of date, you can follow this request.

But if you want a specific date not in range, you have to separate your request.

All comments

chavalit-jintamalit

Hi @sile

The problem is on the list of date in parameters.

You cannot make a request with SDate as a list.

If you want a range of date, you can follow this request.

But if you want a specific date not in range, you have to separate your request.

Alex Putkov.1

To add to the answer by @chavalit-jintamalit, to specify the frequency of the series you can add Frq parameter to the request. E.g. to retrieve annual series of market cap values you can use

ek.get_data('000002.SZ', 
    ['TR.CompanyMarketCap.date', 'TR.CompanyMarketCap.value'], 
    {'Scale': 6, 'Curn': 'USD', 
    'SDate': '20160101', 'EDate': '20190101', 'Frq':'FY'})

EXPLORE OUR SITES