Unable to get a list of all private companies of an specific country

[gilbertopenedo]

Hi,

I´m trying to get a list of private companies that are listed on eikon using eikonapir.

The command lines are the following:
set_app_id("my_app_id")
type <- 'IN(Private(OrgType(COM, UNK, MKP)))/UNV:Private/)'
country <- 'IN(TR.HQCountryCode,"BR")'
companies <- paste0('SCREEN(U(',type,',',country,')')
columns <- list(TR_Field(field_name = 'TR.CommonName'))
list_companies <- get_data(companies,columns)

I was successful using this method for public companies, setting type as 'IN(Equity(active,public,primary))/UNV:Public/)'. But it´s not working for private companies.

Could you help me?

[RicoDiel]

I strongly assume the problem is that there simply are to many private firms in Brasil.
To narrow it down, you can adapt your call as follows:

set_app_id("my_app_id")
type <- 'IN(Private(OrgType(COM, UNK, MKP)))/UNV:Private/)'
country <- 'IN(TR.HQCountryCode,BR)' # i changed "BR" to BR inside this string, else we get undesired output
industry <- 'IN(TR.NAICSSubsectorCode,321)' # Manufacturing > Wood Production
range <- paste(country, industry, sep = ",")
companies <- paste0('SCREEN(U(',type,',',range,')')
columns <- list(TR_Field(field_name = 'TR.CommonName'))
list_companies <- get_data(companies,columns)

It might be too late for you, but i hope it helps others

[gilbertopenedo]

Thank you! Em quarta-feira, 5 de agosto de 2020 10:33:50 BRT, RicoDiel <[email protected]> escreveu: I strongly assume the problem is that there simply are to many private firms in Brasil. To narrow it down, you can adapt your call as follows: set_app_id("my_app_id") type <- 'IN(Private(OrgType(COM, UNK, MKP)))/UNV:Private/)' country <- 'IN(TR.HQCountryCode,BR)' # i changed "BR" to BR inside this string, else we get undesired output industry <- 'IN(TR.NAICSSubsectorCode,321)' # Manufacturing > Wood Production range <- paste(country, industry, sep = ",") companies <- paste0('SCREEN(U(',type,',',range,')') columns <- list(TR_Field(field_name = 'TR.CommonName')) list_companies <- get_data(companies,columns) It might be too late for you, but i hope it helps others — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.