Pct of Shares held domestically

eikon23

Dear all,

I am using Eikon/Datastream API on Webservice.

I tried extracting aggregated percentage of shares held by domestic investors on a daily basis. To do so I have tried using Shares Held with Country Perm ID as well as Tr.PctCountry but it does not seem to load. The Country Perm ID List also does not load. Can somebody help me with my task and provide me the perm id for vietnam.

My goal is to have daily data on % of shares owned by domestic investors on domestic stock which in my case is Vietnam.

Thanks everybody

jonathan.legrand

Hi @eikon23,
Have you had a look for the field you may be after in DIB?

I believe that the field name you may be after is "TR.Numbersofsharesownedbyforeigninvestors". You can use this with Sreener, e.g.:

import pandas as pd
import refinitiv.data as rd
rd.open_session()
df: pd.DataFrame = rd.get_data(
    universe = 'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.HQCountryCode,"VN"), TR.CompanyMarketCapitalization>=1000000000, CURN=USD)',
    fields = ['TR.NUMBEROFSHARESOWNEDBYFOREIGNINVESTORS']
    )
display(df)
rd.close_session()

However, I am not sure which companies you are after. Not all comapies have 'TR.NUMBEROFSHARESOWNEDBYFOREIGNINVESTORS' data; the above included. If you cannot find the field you are after in DIB, I would suggest either asking this (content) question on my.refinitiv.com, or using the Search functionality which may answer your need.