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.

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.

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)

Hi @charles.malafosse,

As @zoya.farberov 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

@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

@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'] != '']

Hi @chavalit.jintamalit,

Going back to this issue, when I add the parameter you suggested:

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

I get:

   Instrument      Investor Type Description
0  5000001154                               
1  4295955751                               
2  4295895691  Investment Advisor/Hedge Fund

So this didn't resolve my problem that the first 2 investors types were missing. Please note I don't want to do one request per investor as I have thousands of them so this would take too much time.

thanks

Hi @chavalit.jintamalit,

thanks for your answer but wouldn't it be easier if you just fix the deficiency?

Best