I am looking for a way to screen for commodity instruments by source and other variables, similar to the attached screenshot. There is a sample screening query in the Data Retrieval and Discovery folder however I'm not sure how to modify the code for these parameters. I can see that these data items are available (i.e. CF_EXCHNG is the data item for Exchange) but am not sure how to incorporate this within the screen code. 
1
●0 ●0 ●0
Screen for commodity instruments by source and other variables
Hi @thestonkking ,
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
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
17.4k
●82 ●39 ●63
You can actually utilize the Search feature under the "Refinitiv Data Library" folder - specifically using the example: "Access__Search.ipynb". For example, you can create a search that looks like this:
rd.discovery.search(
view = rd.discovery.Views.COMMODITY_QUOTES,
filter = "( (SearchAllCategoryv2 eq 'Commodities' and " \
"RCSUnderlyingProductGenealogy eq 'U:Q') and " \
"(ExchangeName xeq 'Shanghai Futures Exchange'))",
select = "DTSubjectName,DisplayName,RCSUnderlyingProductLeaf," \
"RCSAssetCategoryLeaf,ExchangeName,DisplayType," \
"RCSAssetCategoryGenealogy,RIC,Periodicity,BusinessEntity," \
"PI,SearchAllCategoryv3,SearchAllCategoryv2," \
"SearchAllCategory,ContractType,RCSSourceTypeLeaf," \
"RCSUnderlyingProductGenealogy"
)
Within the "Advanced Search" app you are using, you can utilize the "Export Query" feature from the "Export Options" menu:
This will pull up search criteria and output options you see in the Commodities search results you have. Hope this helps.
1
●0 ●0 ●0
Thanks for the quick response Nick. Wasn't aware of the export capabilities in the AS app - very helpful.
