Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Quek avatar image
5 ●0 ●0 ●1

Stock Screen for Inactive Stocks in a particular exchange

I am trying to screen for all stocks in a particular exchange, using the TR.ExchangeMarketIdCode. When I screen for active stocks, using the command below, it works.

'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeMarketIdCode,"XTAI"))'


However, when I try to get the list of inactive stocks, using the following command, I get nothing back.

'SCREEN(U(IN(Equity(inactive,public,primary))), IN(TR.ExchangeMarketIdCode,"XTAI"))'


Can i screen for inactive stocks by exchange market code? (I know I can screen for inactive stocks if i used the screen by country, but that is not what i want.)

#productscreeningscreener
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image   wasin.w

Hello @Quek

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
aramyan.h avatar image
5k ●16 ●2 ●7

Hi @Quek ,


Thank you for your question. I have checked on my end, the code looks working. It seems that there is no values for the specified screen. For example, removing IN(TR.ExchangeMarketIdCode,"XTAI") returned me values suggesting that inactive is a valid command.


Generally, the way I approach screener functions is to build the screen using SCREENER app in Workspace, then exporting the query as formula and finally take the screener code from excel into my query. That way I am certain both on the query syntax as well as the values I will get.


screenshot-2023-06-02-at-133719.png


Could you please kindly try this workflow and let me know if you get any values in Workspace which you can't via the python query?


Best regards,

Haykaz


screenshot-2023-06-02-at-133719.png (272.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.