@Stefan.Vincenz

To add to the response by @jonathan.legrand, I'm not sure why you say you do not have access to DSWS, since your Eikon subscription includes access to DSWS. But if indeed for whatever reason you cannot use DSWS, you should be able to retrieve the data you're interested in using Eikon Data APIs. To construct the list of stocks you're interested in, you may want to use Screener. See the article titled Find Your Right Companies with SCREENER. To find the field names and parameters for the data items you're interested in, you can use CodeCreator app in Eikon, which allows you to search for the field names or browse available field names by category, then select the parameters applicable to the field name selected. At the end of this CodeCreator produces a Python code snippet for the data retrieval call, which you can copy & paste into your IDE, and then modify it for the syntax that Eikon Data APIs library for R requires.

Hi,

1. You can search for indices on Workspace and pick the one that best fits your needs:

Then you can look into constituents:

2. Once you have your constituents, I'd suggest simply using the DSWS R library that was created by the Dev. Community:

https://github.com/CharlesCara/DatastreamDSWS2R

You can use this in a similar way to what I did in this article:

https://developers.refinitiv.com/en/article-catalog/article/information-demand-and-stock-return-predictability-coded-in-r-part-1

3. When you create a Request Table in Excel, does the data come up with Excel code in a single cell? If so, would you mind sharing it here? We might be able to reproduce it in R

Many thanks @jonathan.legrand and @Alex Putkov