hi Refinitiv-team, I want to download price and fundamental data for all single stocks in a specific country. My aim is to cover all historically available stocks (so that there is no survivorship bias in the data). For example for Australia I want to use the lists WSCOPEAU, FAUS, DEADAU (cp. Schmidt et al (2019)*), but I cannot access these using the Eikon api (which establishes a connection to R). My questions are: 1. Are there more complete lists available in order to cover all stocks (active, dead, delisted etc.) within a country than the one I proposed? 2. What is the best way to get this data into R? I can only use the Eikon API but do not have access to DSWS. 3. I want the time-series fields "P", "PA", "RI", "PTBV", "NOSH", "DPS", "EPS", "VO" and static fields "MNEM", "DSCD", "TYPE", "RIC". Is my only option to Create a Request Table in Excel and then load the data into R? Many thanks for your help
*Schmidt, Peter S., et al. "Common risk factors in international stock markets." Financial Markets and Portfolio Management 33.3 (2019): 213-241.