question

Upvotes
Accepted
77 6 14 19

escape character in rdp.search

I am trying to look for some data on the option chain root 0#WM*.U.

I used both the query "0#WM*.U" as well as the filter "RIC eq 0#WM*.U". However this * is taken as an arbitrary character in stead of only returning "0#WM*.U" . Is there a way to only return "0#WM*.U" with * taking only the value * ?

1642153121519.png



eikon-data-apirdp search
1642153121519.png (60.8 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.

1 Answer

· Write an Answer
Upvote
Accepted
15.5k 32 5 10

hi @laurens

Please use 'xeq' instead of 'eq' for the exact attribute as 'xeq' cannot be used with wild cards and is case-sensitive.

for example

rdp.search(
    view = rdp.SearchViews.EquityQuotes,
    filter = "RIC xeq '0#WM*.U'",
    select = 'DTSubjectName, ExchangeName, RIC, RCSAssetCategoryLeaf, Currency, AssetState, UnderlyingQuoteRIC',
    top = 1000
)

1642154349281.png

For more detail about RDP search, you may check this article


1642154349281.png (18.6 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.