question

Upvotes
Accepted
1 0 0 0

How to get all possible values for `RCSUnderlyingProductGenealogy`

Hi! I'd like to figure out how to get all possible values for `RCSUnderlyingProductGenealogy`, to be able to easily search for commodities.

The filter part of my query is this:

`( (SearchAllCategoryv2 eq 'Commodities' and RCSUnderlyingProductGenealogy eq 'U:8') and (RCSUnderlyingProductGenealogy eq 'U:D\\U:5S' and (not (CallPutOption xeq 'Call') and not (CallPutOption xeq 'Put'))))`


Thank you!

pythonworkspace#technologysearchrefinitiv-data-libraries
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.

1 Answer

· Write an Answer
Upvotes
Accepted
18.3k 84 39 63

Hi @mark.szulyovszky

You can use Navigators to pull out all possible values for this property.

For example:

response = search.Definition(
    top = 0,
    filter = "SearchAllCategoryv2 eq 'Commodities' and not(CallPutOption xeq 'Call') and " \
             "not (CallPutOption xeq 'Put')",
    navigators = "RCSUnderlyingProductGenealogy"
).get_data()
response.data.raw["Navigators"]["RCSUnderlyingProductGenealogy"]["Buckets"]

You can find many examples within GitHub.

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.