Hello everybody. I would like to download the esg ratings for the stocks that are part of the Stoxx Europe 600 index. I opened the SCREENER app and filtered, for example, for negative screening. But how can I filter for only the stocks present in that index?
Also, is there a way to download the individual time series of the stocks that make up an index? For example, if I need to download the time series of the stocks of S&P 500 (Apple Inc, Microsoft Corp, Amazon, Facebook, J&J and so on) I Do I have to search and download them one by one or is there a way to download them all at once?
I need the .csv files so I can manipulate them in VBA or R software.
Thanks in advance for the help!