search

ahmedmohamedali / eikonapir

Other
40 stars 23 forks source link

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

Open gilbertopenedo opened 6 years ago

gilbertopenedo commented 6 years ago

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 commented 4 years ago

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 commented 4 years ago

Thank you! Em quarta-feira, 5 de agosto de 2020 10:33:50 BRT, RicoDiel notifications@github.com 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.