Specify Asset Category in RSearch function in Excel COM add-in

Hi,

I have a question regarding the RSearch functioin in COM add-in in Microsoft Office, Please see attached secreen shot. I downloaded the tutorial 7 from this webiste:https://developers.refinitiv.com/eikon-apis/com-apis-use-microsoft-office/downloads

Is there a way to specify the Asset Category in this function? The asset Class is bond but i only need the products with Asset Category "bond" not "certificate of deposit" or "commericial paper".

Find more posts tagged with

eikon

eikon-com-api

Accepted answers

Alex Putkov.1

To include only bonds and exclude certificates of deposit and commercial papers use RCSAssetCategory keyword and values 'A:J' in the search criteria, e.g. the full search criteria string might be:

"RawContextFilter:'(DbType eq \'GOVT\' or DbType eq \'CORP\' or DbType eq \'AGNC\' or DbType eq \'OMUN\' or DbType eq \'OTHR\') and RCSAssetCategory eq \'A:J\' and IsActive eq true'"

And the full Excel worksheet function syntax is:

=RSearch("BOND","RawContextFilter:'(DbType eq \'GOVT\' or DbType eq \'CORP\' or DbType eq \'AGNC\' or DbType eq \'OMUN\' or DbType eq \'OTHR\') and RCSAssetCategory eq \'A:J\' and IsActive eq true'","NBROWS:100")

The best way to construct a search expression for use in RSearch library is to follow Search wizard available from Excel ribbon under Thomson Reuters tab. See this answer for detailed instructions.

All comments

Alex Putkov.1

To include only bonds and exclude certificates of deposit and commercial papers use RCSAssetCategory keyword and values 'A:J' in the search criteria, e.g. the full search criteria string might be:

"RawContextFilter:'(DbType eq \'GOVT\' or DbType eq \'CORP\' or DbType eq \'AGNC\' or DbType eq \'OMUN\' or DbType eq \'OTHR\') and RCSAssetCategory eq \'A:J\' and IsActive eq true'"

And the full Excel worksheet function syntax is:

=RSearch("BOND","RawContextFilter:'(DbType eq \'GOVT\' or DbType eq \'CORP\' or DbType eq \'AGNC\' or DbType eq \'OMUN\' or DbType eq \'OTHR\') and RCSAssetCategory eq \'A:J\' and IsActive eq true'","NBROWS:100")

The best way to construct a search expression for use in RSearch library is to follow Search wizard available from Excel ribbon under Thomson Reuters tab. See this answer for detailed instructions.

swang

Hi @alexputkov, thank you for your answer and the RCSAssetCategory works! Do you maybe have a more detailed instructions for RSearch function? Because the instructions in this answer didnt work for me

Alex Putkov.1

@swang

You can find documentation for RSearch function in Eikon Excel Help (from Thomson Reuters tab on Excel ribbon select Help - Thomson Reuters Eikon - Microsoft Office Help. Then in the Search field within the Help window type in "RSearch". The documentation for RSearch function explains function syntax and arguments, but it doesn't list all the search criteria available. For the latter you need to use the Search wizard. What exactly didn't work for you when you followed the instructions in the answer I referred you to?

EXPLORE OUR SITES