Looking for the right "instruments" that specify the entire universe of publicly listed companies in

Yuma

I am trying to extract ESG scores for all public companies in the US and am wondering 1) if I have to manually create a list (i.e., instruments=[...], where [...] is the hand-collected list) or 2) if there is a relevant instrument list. For your information, I can succefully get ESG score for instance IBM as follows:

df,err = ek.get_data(instruments="IBM", fields= 'TR.TRESGScore')

I tried to look for the past related questions but couldn't find any; I would also appreciate it if you could direct me to any of them as well.

Many thanks in advance.

Zhenya Kovalyov

@Yuma.Iwase you can use a screener query that needs to be created in the Screener app inside Excel. Take a look at this thread.

Yuma

Dear @Zhenya Kovalyov

That thread is exactly what I want to know. I greatly appreciate your support, thousand thanks.