question

Upvotes
Accepted
neha.kabra avatar image
11 ●1 ●2 ●4

I would like to filter options from Chain, where only RIC's which are around the strike price are pulled. Pls confirm if this can be done via IPA API , please also provide the query to be used

rdp-apirefinitiv-data-platform
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 @neha.kabra

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


Alex Putkov.1 avatar image   Alex Putkov.1

@neha.kabra

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
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

I don't believe this can be done with IPA. But it may be possible using Search service on RDP. Check out the article titled Building Search into your Application Workflow for info on using RDP Search.
E.g. for OPRA stock options on IBM the following request returns 982 RICs: exactly the same as the current number of RICs in 0#IBM*.U chain

{   
    "View": "EquityDerivativeQuotes",   
    "Filter": "UnderlyingQuoteRIC eq 'IBM' and IsChain eq false and RCSAssetCategory eq 'A:1T' and ExchangeCode eq 'OPQ' and ExpiryDate gt 2021-07-14",   
    "Select": "RIC" 
}

But if I add "and StrikePrice gt 139.82 and CallPutOption eq 'Call'" to the filter to only search for in the money calls, the result is reduced to 255 RICs.

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.