Issue with get_data returning multiple rows for one single investor

Hello, I want to get a field called TR.InvestorType using Python. I noticed that when I do:

data, err = ek.get_data(["5000001154","4295955751"], TR.InvestorType, {CURN: USD})

I get the right results. Then when I add for example the ID 4295895691:

data, err = ek.get_data(["5000001154","4295955751","4295895691"], TR.InvestorType, {CURN: USD})

then I get multiple rows for 4295895691 and I don't get the results for the first two companies anymore. Anyone has an idea on why I am getting this behavior?

Find more posts tagged with

python

eikon

api

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @charles.malafosse

- can you fix this so we don't have to do all this extra work to get correct data?

I believe that the data is correct. It is possible to have multiple investors.

There are multiple investors to the "4295895691" identifier.

- How can I get only one row returned (the most recent or the populated investor type data for ID 4295895691)

You can use "Data Item Browser" to explore the supported parameters on TR.InvestorType field.

In this case, you can set "End Number" to 1 so you would only get the first row in the result.

- Why these IDs return different data sets? Is it because one is listed and the others are not? How can we separate the two types?

I believe that the data is correct. It is possible to have multiple investors.

If you need further clarification on the content, you can contact Refinitiv Content Helpdesk at https://my.refinitiv.com/

Helpdesk would be able to suggest if there are any fields to allow you to separate them.

All comments

zoya faberov

Hello @charles.malafosse,

As I was able to confirm by running Eikon search on these instruments,

Some Permids (the identifiers you request by is permid) map to one RIC,, some to none ( the first two, they are "unlisted"), some to many such as the third, Alliance Trust.

Suggest to try this request to see this difference in action

data, err = ek.get_data(["5000001154","4295955751","4295895691"],  ['TR.InvestorType', 'TR.CommonName','TR.CompanyName'])

For me this results in

It appears, that you are looking for results that correspond to a listed RIC.

nick.zincone

Hi @charles.malafosse,

As @zoya faberov pointed out and as you observed, the 3rd PermID ("4295895691") does have multiple (~185 rows) returned. If you only want the InvestorType for both, I think you will have to merge the results. It appears the get_data() doesn't understand how to merge these 2 different data sets into one.

For example:

df1,err = ek.get_data(["5000001154","4295955751"], "TR.InvestorType")
df1

df2, err = ek.get_data(["4295895691"],  ['TR.InvestorType'])
df2

df = pd.concat([df1, df2])
df

chavalit-jintamalit

Hi @charles.malafosse

Just want to make the result more obvious.

This is the sample code:

data, err = ek.get_data(["5000001154","4295955751","4295895691"],
                        ['TR.InvestorType.instrument', 'TR.InvestorType.investorid', 'TR.InvestorType',
                         'TR.CommonName.instrument', 'TR.CommonName',
                         'TR.CompanyName.instrument', 'TR.CompanyName'])
data.head(10)

The multiple records are acutually from different investor ids.

charles.malafosse

@nick.zincone.1 @zoya.farberov @chavalit.jintamalit

Hi all, thanks for your answers. I have a couple of questions:

- can you fix this so we don't have to do all this extra work to get correct data?

- How can I get only only one row returned (the most recent or the populated investor type data for ID 4295895691)

- Why these IDs return different data sets? Is it because one is listed and the others are not? How can we separate the two types?

Thanks

zoya faberov

@charles.malafosse

Try selecting by value

data, err = ek.get_data(["5000001154","4295955751","4295895691"],  ['TR.InvestorType', 'TR.CommonName','TR.CompanyName'])

data.loc[data['Company Common Name'] != '']