GOVSRCH using COM API
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
-
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")
0
Answers
-
I'm having the same issue with Hong Kong : 4427.HK
0 -
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")
0 -
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.
0 -
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.
0 -
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?
0 -
You can retrieve chains using AdxRtChain class of AdfinX Real-Time COM library.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 630 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 86 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛