How do I filter private companies by the number of employees?

I am trying to get a list of organizations (OrgPermID) for private companies that have more than a given number of employees. Someone gave me the following formula for Excel, but I need it using the Eikon API. The formula I was given is below. Can someone please tell me how to get this using the Eikon API? Thanks. =TF(TFScreen(TFFILTERSET(Companies,Active,1,IssuerStatus=Private),curn=USD,TF.PC.PCNumOfEmployees()>4000))

Find more posts tagged with

python

eikon

data

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @maria.vieira

Please review this article, https://developers.refinitiv.com/article/find-your-right-companies-screener-eikon-data-apispython

You can use SCREENER to build a sample screening syntax and use it with Eikon Data API.

Please note that in my example, I changed the number of employees to >10000.

Because >4000 condition return 13xxx records which exceed API limitation.

All comments

chavalit-jintamalit

Hi @maria.vieira

Please review this article, https://developers.refinitiv.com/article/find-your-right-companies-screener-eikon-data-apispython

You can use SCREENER to build a sample screening syntax and use it with Eikon Data API.

Please note that in my example, I changed the number of employees to >10000.

Because >4000 condition return 13xxx records which exceed API limitation.

kesavareddy102

I have tried the same method that you have explained above for lowes employees at my company, myloweslife where i am currently working, it worked like a charm, thank you very much for the clarity again that it can do the job, that image helps all newbies like me in some cases.

chavalit-jintamalit

Hi @kesavareddy102

Thanks for your feedback and I am glad the article provided the information you were looking for.

EXPLORE OUR SITES