API to get RIC price and for rights/warrants

angelalock

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!

raksina.samasiri

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.

2. RD Library for Python

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

Jirapongse

@angelalock

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: