ek.get_data('BPCL',['TR.ISINCode']) does not give the ISIN though I can see the ISIN for this on Eikon terminal.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
ek.get_data('BPCL',['TR.ISINCode']) does not give the ISIN though I can see the ISIN for this on Eikon terminal.
Above is the output on eikon screen but dosent come when calling from API
(Private comment) The API documentation does not say that get_data() requires RICs in the instrument parameter. Does it? It does not say whether get_symbology() fails or passes multiple results if the results are ambiguous. It does not say how, in general, to map an unambiguous ticker such as "BCPL on NSE Mumbai" to a RIC. There does not seem to be a mapping function that takes { ticker, exchange } and returns a RIC. Is there? There is of course search but that's not (yet) in the public API. I think these questions need to be answered here. @Olivier DAVANT ?
Hello @abbanerjee
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
Hi @abbanerjee
From my understanding, Ticker is not unique so you may or may not get best match.
This picture is just for example:
So get_data function could not resolve it
Please note I am not using RIC code but ticker. The ticker for BPCL on NSE exchange is BPCL and in this case its a coincidence that ticker is BPCL and RIC is BPCL.NS. Another example where this is not the case is for example Reliance Power.
My goal is not to use the RIC but get a mapping from ticker to ISIN. It works for others and does not work for this specific case. The regular help desk directs all API related questions to this forum which is time consuming and frustrating.
Hi @abbanerjee
Alternatively, you can use get_symbology function.
Ok great. Thanks for the interim solution but can someone please also look at my original question? Is it an aberration that it works for other tickers or is there something specificially wrong in the content setup of BPCL ?
Also for GAIL its not working - possible there are multiple matches. Whats the best way arround this ?
ek.get_symbology('GAIL',from_symbol_type='Ticker',to_symbol_type=['ISIN'])
error
GAIL No best match available
Was able to do this.
ek.get_symbology('GAIL',from_symbol_type='Ticker',to_symbol_type=['ISIN'],bestMatch=False)