so that I can use this list to get monthly price data of all stocks
@107352022 I am not sure there is a good way to do this with a desktop Eikon API. You can build lists of instruments with the SCREENER app in Excel.
For more info on using the Screener app see video tutorial titled "Create Data Retrieval Functions using Equity Screener in Excel" available under Eikon main menu - Help - Tutorials and Training.
To add to the answer by @Zhenya Kovalyov, I cannot help but wonder what might be the purpose of this exercise. The reason I'm curious is that the universe of public companies covered in Eikon is ~65K. If you're looking for all stock tickers on all exchanges, which include non primary issues and cross listings, the universe will swell to ~180K tickers. If you're looking to retrieve even the basic data about the stocks and even if you limit the universe to only the primary issues, it's likely you won't be able to do this through Eikon. Also before you make any attempts to retrieve large amounts of data from Eikon I suggest you verify that your data usage is in compliance with the single user data usage license granted with Eikon. Eikon is a single user product. Any data retrieved from Eikon is for individual user's use only. Any distribution of data retrieved from Eikon, databasing, or use of data in any kind of enterprise or server side application is not permitted under the terms of standard Refinitiv contract. If you need to consume data in bulk or utilize it in enterprise applications, Eikon is not the right product for you. Instead Refinitiv offers a range of enterprise products specifically designed for this type of data usage.
