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
Hi All,
May I know what APIs can I use to get the RICs and prices for warrants and rights? For example, SEDOL BMCDGP7 that is linked to RIC ACII_t.N. Are there any formulas we could use to get RICs and prices for multiple rights/warrants?
Currently for equities, we are using RSearch("EQUITY","Search:'Identifier' ExchangeName:'Exchange Name'","NBROWS:1") to get the RIC and tr(e15,"tr.priceclose","SDate=2021-01-14") to get the prices.
Thank you!
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
Hi @angelalock
May I add that the Eikon Excel formula provided by my colleague can be converted to Python code with APIs below
1. Eikon Data API as below
import eikon as ek
ek.set_app_key('### YOUR APP KEY ###')
df, err = ek.get_data(['BMCDGP7', 'BMVF784']
, [ 'TR.CLOSEPRICE', 'TR.RIC'], {'SDate': '2021-04-28'})
df
Here's the Eikon Data API - Quick start guide, which can help you getting start with using an API.
import refinitiv.data as rd
rd.open_session()
rd.get_data(['BMCDGP7', 'BMVF784'], [ 'TR.CLOSEPRICE', 'TR.RIC'], {'SDate': '2021-04-28'})
Hope this helps and please let us know in case you have any further questions
The TR function in Eikon Excel works with SEDOL codes. The formula looks like this:
=@TR("BMCDGP7;BMVF784","TR.CLOSEPRICE;TR.RIC","SDate=2021-04-28 CH=Fd RH=IN",B31)
The output is:
