Formula that can pull up INPJ.J for GB00B17BBQ50 using Python API
How to pull RIC using ISIN and select specific market without using RSearch formula
It seems RSearch formula below in Eikon will not work in Python API
=RSearch("EQUITY","Search:'"&A2&"' ExchangeCode:"&B2&"",,)
where A2 is GB00B17BBQ50 B2 is JNB
Best Answer
-
You can use RDP Library to achieve what you're looking for. The example below returns the RIC 'INPJ.J', given the ISIN 'GB00B17BBQ50' and exchange code 'JNB' as inputs.
rdp.lookup(view=rdp.SearchViews.EquityQuotes, scope='IssueISIN',
terms='GB00B17BBQ50', filter="ExchangeCode eq 'JNB'",
select='RIC')For a comprehensive review of using RDP Library to access the Search service on RDP, see the article titled "Building Search into your Application Workflow".
0
Answers
-
Hello @kenley.macandog123,
Is
ek.get_symbology(["GB00B17BBQ50"], from_symbol_type="ISIN",to_symbol_type="RIC")
what you are looking for?
Returns:
GB00B17BBQ50 INVP.L
0 -
@zoya.farberov Client needs to get South Africa listed RIC which is INPJ.J
0 -
Hello @kenley.macandog123,
By default, Eikon Data API returns primary symbol, by specifying bestMatch false
ek.get_symbology(["GB00B17BBQ50"], from_symbol_type="ISIN",to_symbol_type="RIC",bestMatch=False)
you should be able to see all RICs that map to this ISIN.
If this does not satisfy your requirement, in my understanding, an alternative approach that can be explored is to use SCREENER to define specific SCREEN expression, similar to this previous discussion thread, and apply the obtained expression via Eikon Data API python via get_data such as in this previous discussion thread.
To help define SCREEN expression, to determine if this is feasible, suggest to contact Eikon content experts via Refinitiv Helpdesk Online -> Eikon -> Content. This forum is most helpful for API usage general questions and discussions.
0 -
You can use RDP Library to achieve what you're looking for. The example below returns the RIC 'INPJ.J', given the ISIN 'GB00B17BBQ50' and exchange code 'JNB' as inputs.
rdp.lookup(view=rdp.SearchViews.EquityQuotes, scope='IssueISIN',
terms='GB00B17BBQ50', filter="ExchangeCode eq 'JNB'",
select='RIC')For a comprehensive review of using RDP Library to access the Search service on RDP, see the article titled "Building Search into your Application Workflow".
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛