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))
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
18k
●21 ●12 ●20
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.
16
●0 ●0 ●0
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.
Thanks for your feedback and I am glad the article provided the information you were looking for.
