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 @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:
