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".
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.
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?
Hi! I want to download bulk data for banks eg. ROA for all commercial banks in the US between 2010-2019. Is there any way using EIKON? Or simply I have to select a bank then to searach on the financials and to download at bank level? Thank you