How can I run something similar using COM API?
RIC sample: ANVHA.AX
I cannot get it using RSearch COM API or Excel.
@igorg
I don't think I'm following what you're trying to do. Are you asking what criteria you could use to retrieve these bonds with RSearch? Here's an example of RSearch Excel worksheet function that returns SG095378323=, which is the primary RIC for ANVHA.AX.
=RSearch("BOND","RawContextFilter:'DbType eq \'CORP\' and IsActive eq true' IssuerOrgid:'100651023' MaturityDate:<2020-08-01")
I'm having the same issue with Hong Kong : 4427.HK
I'm trying to get all RICs
Your sample returns : SG095378323=
I want to get ANVHA.AX