GOVSRCH using COM API

igorg
igorg Advocate

How can I run something similar using COM API?

RIC sample: ANVHA.AX

I cannot get it using RSearch COM API or Excel.

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    @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")

Answers

  • igorg
    igorg Advocate

    I'm having the same issue with Hong Kong : 4427.HK

  • igorg
    igorg Advocate

    I'm trying to get all RICs

    Your sample returns : SG095378323=

    I want to get ANVHA.AX


  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

    I'm still not following. Would you mind elaborating on what you're looking to achieve? Are you trying to get all RICs for a given bond? Then you shouldn't use RSearch. RSearch serves the use case when you're looking for a list of instruments based on a criteria (e.g. all bonds issued by companies domiciled in a given country and with maturity dates between X and Y). RSearch returns one identifier per instrument. If you're looking to get all RICs for a given bond use DEX2 library with the field TR.RICS. Or in Excel use

    =TR("SG095378323=","TR.RICS")
  • igorg
    igorg Advocate

    I'm trying to get all RICs for Australia and Hong Kong for all Asset Types.

    For equities and funds I use RSearch COM API with RIC = '*.AX'. But they do not return me bonds. If I use AssetType = 'BOND' I still do not receive those RICs: 4401.HK,4402.HK, 4403.HK, 4404.HK, 4405.HK... They are Fixed Income type. I don't know what to use in AssetType to get them.

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

    You're not going to get these RICs from RSearch. RSearch returns only the primary RIC for an instrument, and for bonds typically the primary RICs are composite, not exchange RICs. E.g. the primary RIC for 4403.HK is KY202243436=. If you're looking to get RICs for bonds listed on HKEx, you can get them from chains 0#BONDA.HK, 0#BONDH.HK and 0#BONDP.HK. If you're looking for something else, then you need a better, less ambiguous definition for what you're looking for than "all RICs for Australia and Hong Kong for all Asset Types". A country is not an attribute of a RIC. Many financial instruments cannot be attributed to a single country. Even for stocks "all RICs for Australia" could mean all stocks listed on ASX or all stocks of public companies headquartered in Australia, which is not the same thing. For bonds there's even more ambiguity: country of issuer domicile, country of issuer incorporation, exchange country for listed bonds, borrower country when borrower is different from the issuer etc.

  • igorg
    igorg Advocate

    Alex, you're right, my definition was bad. But I just wanted to point that I need an universe of the tickers/rics, but not a single instrument.

    The problem is: I have an expected list of the symbols. After usual RSearch collection I found that some of them are missing. Then I realized, one of the reasons is "bonds". And yes, those symbol are all listed on ASX and HKG.

    For the chain request - can it be done using C++ COM API or it should be Python Data API?

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

    You can retrieve chains using AdxRtChain class of AdfinX Real-Time COM library.