Hello - While using Codebook app on Eikon, is there a way to retrieve the RICs fulfilling a certa...

Hello - While using Codebook app on Eikon, is there a way to retrieve the RICs fulfilling a certain condition- say I need to retrieve all Equity Option RICs for which FID 1056 is blank?

Find more posts tagged with

python

eikon

workspace

codebook

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @sandhya.rao

Please see this example:

All comments

chavalit-jintamalit

Hi @sandhya.rao

Please see this example:

sandhya.rao

@chavalit-jintamalit- Thanks for your reply. Is it possible to get similar output for the entire universe of Equity Option RICs at one go(if not say for all the options trading on a particular exchange)?

I see you are using individual RIC here to get the chain RIC. But say I have the chains already with me. So can I specify all the chains available within the get data function or is there any limitation.

I believe that as the RIC universe is vast there could be limitations with regard how much info could be retrieved. But I wanted to know as this would help in identifying suspects for various exchanges based on what value the FID should hold.

chavalit-jintamalit

Hi @sandhya.rao

When you input more than one chain RIC to get_data, the chains do not get expanded.

So you cannot pass in a list of chain RICs.

You can make a loop in Python to loop your chain RIC list.

This sample just print out the first 3 rows for each chain RIC.

EXPLORE OUR SITES