How to get all possible values for `RCSUnderlyingProductGenealogy`

mark.szulyovszky
mark.szulyovszky
in Refinitiv Data Platform Libraries

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!

Tagged:

Best Answer

  • nick.zincone
    nick.zincone
    Answer ✓

    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.

Categories