question

Upvotes
Accepted
5 0 0 1

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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
39.2k 75 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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea